#一起看斜阳#的专栏

TBPROCCREATE Procedure TbProc@model varchar(2),@pagename varchar(32),@object varchar(32),@autoField varchar(32)=nullasset nocount onselect @model=upper(@model)select @pagename=lower(@pagenam

CREATE function fBOMmat(@matcode varchar(16))returns @bom table(Num smallint,MatCode varchar(16),Coef real,String varchar(1000),advannum int)asbeginif exists(select * from T142 where matcode

******* 导出到excelEXEC master..xp_cmdshell bcp SettleDB.dbo.shanghu out c:/temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P"" /*********** 导入ExcelSELECT * FROM OpenDataSource( Microsoft.