![]() IF OBJECT_ID( ' dbo. IF OBJECT_ID( ' dbo.Product') IS NOT NULL DROP TABLE dbo.Product IF OBJECT_ID( ' dbo.Order') IS NOT NULL DROP TABLE ![]() ![]() ') AND type in (N ' P', N ' PC'))ĪS BEGIN SET NOCOUNT ON SET STATISTICS IO OFF DECLARE AS DATETIME = GetDate()ĭECLARE AS INT = 1000 DECLARE AS INT = CHECKSUM( 30052007) - Using all the same seed, We try to get the same database for everybody IF OBJECT_ID( ' dbo.OrderLine') IS NOT NULL DROP TABLE OrderLineĬREATE TABLE OrderLine(OrderId int NOT NULL, LineNumber int, ProductId int NOT NULL, Qty numeric( 18, 3) NOT NULL, LineTotal numeric( 18, 2) NOT NULL, CONSTRAINT pk_OrderId_LineNumber PRIMARY KEY CLUSTERED (OrderId ASC, LineNumber ASC)) GO IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '. Avery Dennison is a materials science and manufacturing company specializing in the design and manufacture of a wide variety of labeling and functional materials. Copy Code - Fabrics V1.2 - Creating a SQL database from scratch USE Fabrics
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |