demo034.sql

T-SQL示例大全

/* 文件名称: Demo034.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
(
代号 char(10)  NOT NULL,
姓名 nvarchar(12) NULL,
出生日期 datetime NULL
)
GO

INSERT MyPerson VALUES ('M190302123',NULL,'09/26/1967')
INSERT MyPerson VALUES ('M201102121','章立民','09/26/1967')

UPDATE MyPerson SET 出生日期 = NULL WHERE 姓名 = '章立民'

SELECT * FROM MyPerson

DROP TABLE MyPerson