27,579
社区成员
发帖
与我相关
我的任务
分享
IF NOT OBJECT_ID('[tb]') IS NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb]([id] uniqueidentifier default newid(), a int)
INSERT [tb](a) select 1
GO
SELECT * FROM [tb]
/*
id a
-------------------------------------------------- -----------
7830906D-64D6-4A14-8379-034B1AB16F54 1
(1 行受影响)
*/
或这样IF NOT OBJECT_ID('[tb]') IS NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb]([id] nvarchar(50) default newid(), a int)
INSERT [tb](a) select 1
GO
SELECT * FROM [tb]
/*
id a
-------------------------------------------------- -----------
7830906D-64D6-4A14-8379-034B1AB16F54 1
(1 行受影响)
*/