数据库2005T-SQL语句创建表以及表的添加,修改.docVIP

《》 在?test01?数据库中使用Transact-SQL?语句创建表：book(book_id?nchar(6),?book_name?nchar(30),price?number(10,2))?和表?author(author_name?nchar(4),book_id?nchar(6),address?nchar(30))。设置book?中的?book_id?为主键，author?表中的?book_id?为外建，并设置两个表的关系。 2.下面分别用inset、delete、update语句添加、删除和更新数据， 程序及结果如下图： Insert语句： 结果如下表： Update语句： 结果如下： Delete语句： 结果如下图： 第一题总程序： CREATE TABLE test01.dbo.book( book_id nchar(6) NOT NULL, book_name nchar(30) NULL, price numeric(10,2) NULL, CONSTRAINT PK_book PRIMARY KEY CLUSTERED(book_id ASC) ) CREATE TABLE test01.dbo.author( author_name nchar(4) NOT NULL, book_id nchar(6) NOT NULL, address nchar(30) NULL, CONSTRAINT PK_author PRIMARY KEY CLUSTERED(author_name ASC) ) ALTER TABLE author WITH CHECK ADD CONSTRAINT FK_author_book FOREIGN KEY (book_id) REFERENCES book (book_id) go insulating properties of air ... GB/T9966.3-2001 test methods for natural facing stones part 4: wear resistance test method for GB/T996 6.4-2001 test methods for natural facing stones 5th part: test method for scleroscope hardness GB/T996 6.5-2001 test methods for natural facing stones 6th part: test method for acid resistance GB/T996 6.6-2001 test methods for natural facing stone test methods for natural facing stones 8th part: by uniform static pressure difference test stone mounted Structure strength test method of GB/T996 6.8-2001 13, sealant technical standards of architectural curtain wall construction with Silicon sealant silicone building sealant GB/T14683-2003 GB16776-2005 JC887-2001 dry hanging stone curtain wall with epoxy adhesive sealant for glass curtain wall joints JC/T882-2001 JC/T883-2001 mold for building stone building sealant sealant JC/ T885-2001 elastomeric sealant for insulating glass JC/T486-2001 14, building curtain wall fasteners for standard steel high strength bolts with large Hexagon head, large Hexagon nuts, washers technology GB/T1231-2006 high strength plain washers for steel structures GB/T1230-2006 high strength lar