练习篇：
电子商务简单uml模型
个人喜欢uml建模后再建数据库，有段时间没用sql server，，特此复习下，练习代码如下：
master nocount on;dbo.sysdatabases ) databaseoptimization databaseoptimization on(name ,filename ,size = 10,maxsize = unlimited,filegrowth )log on(name ,filename ,size = 5mb,maxsize = unlimited,filegrowth )gouse databaseoptimization .() as random.(@sourcevarchar(256),@paddingchar char(1),@totallength tinyint) returns varchar(512) (ltrim(@source)););;(@source););(512);() .(@length tinyint) ();;(38,0);;();;;() from view_random;return @return;.() returns varchar(30) (30);(,,,dbo.padleft( dbo.random(,8);;;;;;;;;;;;----------------------------------------------------------------------------------------------------------(sys.objects (n) ).; .(,(20) not null,(40) not null,(40) not null,(20) null,(20) null,(100) null,(11) null,(6) null,(getdate()),(0));ix_customer_name .(name);;;.(,,) values(dbo.padleft(),,dbo.padleft(),,,);;--(sys.objects (n) ).; .((30) not null,,(50) null,(20) null,(100) null,(11) null,(6) null,(500) null,(getdate()),(0),(0),);.pk_order_orderid ) ;.fk_order_orderid ) .() ;.();;;(30); ;open cursorcustomer;cursorcustomer into @cursorid;(rand()*@ordercount) ;print @randomcount;; dbo.randomvalue();print @randomorderid;.(,customerid,postingway,receiver,address,phone,) values(@randomorderid,@cursorid,(),,,,());;;cursorcustomer into @cursorid;endclose cursorcustomer;deallocate cursorcustomer;----------------------------------------------------------------------------------------------------------(sys.objects (n) ).; .(,(100) not null,(100) null,,,,(1),(500) null,(getdate()) );;;;.(,,)values(null,'',1);;.(),(), ; ;cursorproducttype .();;;;;open cursorproducttype;cursorproducttype into @typecursorid;set nocount on;(rand()*@producttypelevel2count) ;print @typerandomcount;;.(,,)values(@typecursorid,'',2);;.(),(), ;;;cursorproducttype into @typecursorid;endclose cursorproducttype;deallocate cursorproducttype;----------------------------------------------------------------------------------------------------------(sys.objects (n) ).; .(,(100) not null,(max) null,,(38, 2) null,(38, 2) null,(200) null,,,(0),(8, 1) null default (1),(getdate()),(getdate()),(1)).fk_product_producttypeid_producttype_id ) .() ;cursorproducttypewithlevel .();;;;;open cursorproducttypewithlevel;cursorproducttypewithlevel into @producttypecursorid;set nocount on;(rand()* @productrandommax) ;print @producttyperandomcount;;.(,,,,)values(,);;.(),(), ; ;cursorproducttypewithlevel into @producttypecursorid;endclose cursorproducttypewithlevel;deallocate cursorproducttypewithlevel;----------------------------------------------------------------------------------------------------------(sys.objects (n) ).; .(,(30) not null,,(38, 2) null,).().() ;.().() ;.();;(30);(38,2);(8,1);;open cursororder;cursororder into @ordercursorid;cursorproduct ,discountrate,saleprice .();open cursorproduct;cursorproduct into @productcursorid,@productcursordiscountrate,@productcursorsaleprice;(rand()*50) ;.(,,,)values( @ordercursorid,@productcursorid,,@detailquantity)cursorproduct into @productcursorid,@productcursordiscountrate,@productcursorsaleprice;endclose cursorproduct;deallocate cursorproduct;cursororder into @ordercursorid;endclose cursororder;deallocate cursororder;