sqlserver 常用整理

创建表

IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N‘[dbo].[mysqltest]‘) AND type IN (‘U‘))
	DROP TABLE [dbo].[mysqltest]
GO

CREATE TABLE [dbo].[mysqltest] (
[id] bigint  NULL,
[b] date  NULL,
[c] datetime  NULL,
[e] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[mysqltest] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
‘MS_Description‘, N‘顶顶顶顶‘,
‘SCHEMA‘, N‘dbo‘,
‘TABLE‘, N‘mysqltest‘,
‘COLUMN‘, N‘id‘
GO

插入数据

INSERT INTO [dbo].[mysqltest] ([id], [b], [c], [e]) VALUES (N‘1‘, N‘2020-12-23‘, N‘2020-12-23 17:33:00.100‘, N‘2020-12-23‘)
GO

原文：https://www.cnblogs.com/txdblog/p/15211277.html