demo033.sql

T-SQL示例大全

/* 文件名称: Demo033.sql */
USE NorthwindSQL
if exists (select * from dbo.sysobjects where id = object_id(N'MyPerson') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table MyPerson
GO

CREATE TABLE MyPerson
(
代号 int IDENTITY(10,5) NOT NULL,
姓名 nvarchar(12) NULL
)
GO

INSERT MyPerson VALUES ('章立民')
INSERT MyPerson VALUES ('洪志豪')
INSERT MyPerson VALUES ('章舒涵')

SELECT @@IDENTITY AS 最后一个代号

DROP TABLE MyPerson