USE [master]
GO
/****** Object: Database [TestE1] Script Date: 2023-06-09 5:44:24 AM ******/
CREATE DATABASE [TestE1]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'TestE1', FILENAME = N'C:\SqlServerDb\TestE1.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'TestE1_log', FILENAME = N'C:\SqlServerDb\TestE1_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
ALTER DATABASE [TestE1] SET COMPATIBILITY_LEVEL = 150
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [TestE1].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [TestE1] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [TestE1] SET ANSI_NULLS OFF
GO
ALTER DATABASE [TestE1] SET ANSI_PADDING OFF
GO
ALTER DATABASE [TestE1] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [TestE1] SET ARITHABORT OFF
GO
ALTER DATABASE [TestE1] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [TestE1] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [TestE1] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [TestE1] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [TestE1] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [TestE1] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [TestE1] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [TestE1] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [TestE1] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [TestE1] SET DISABLE_BROKER
GO
ALTER DATABASE [TestE1] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [TestE1] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [TestE1] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [TestE1] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [TestE1] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [TestE1] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [TestE1] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [TestE1] SET RECOVERY FULL
GO
ALTER DATABASE [TestE1] SET MULTI_USER
GO
ALTER DATABASE [TestE1] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [TestE1] SET DB_CHAINING OFF
GO
ALTER DATABASE [TestE1] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [TestE1] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [TestE1] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [TestE1] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'TestE1', N'ON'
GO
ALTER DATABASE [TestE1] SET QUERY_STORE = OFF
GO
USE [TestE1]
GO
/****** Object: Table [dbo].[People] Script Date: 2023-06-09 5:44:25 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[People](
[ID] [uniqueidentifier] NOT NULL,
[TsDatatime] [datetime] NOT NULL,
[TsDatatime2] [datetime2](7) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_People] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [TestE1] SET READ_WRITE
GO
没有合适的资源?快使用搜索试试~ 我知道了~
31-SqlServer-datetime-Code.zip
共17个文件
cs:8个
json:4个
csproj:2个
需积分: 5 0 下载量 25 浏览量
2024-01-18
21:51:18
上传
评论
收藏 11KB ZIP 举报
温馨提示
SqlServer数据类型“datetime”存在准确性和舍入问题,并且已被没有此类问题的“datatime2”数据类型取代。但是,“datetime”仍然存在于许多旧数据库中。我们将展示.NET Entity Framework环境中的这些问题如何导致令人困惑的情况。
资源推荐
资源详情
资源评论
收起资源包目录
31_SqlServer_datetime_Code.zip (17个子文件)
Code
ExampleE2
ExampleE2.sln 1KB
ExampleE1
TestE1ContextFactory .cs 1KB
Program.cs 3KB
TestE1DB
People.cs 408B
TestE1Context.cs 983B
ExampleE2.csproj 1KB
appsettings.json 135B
efpt.config.json 1KB
DatabaseSqlScript
TestE1.sql 6KB
ExampleE1
ExampleE1.sln 1KB
ExampleE1
ExampleE1.csproj 1KB
TestE1ContextFactory .cs 1KB
Program.cs 2KB
TestE1DB
People.cs 408B
TestE1Context.cs 983B
appsettings.json 135B
efpt.config.json 1KB
共 17 条
- 1
资源评论
寒冰屋
- 粉丝: 994
- 资源: 573
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功