09 2004 档案
摘要:数据倒入还是建议用 bcpif exists (select * from tempdb..sysobjects where id = object_id(N'tempdb..#T')) drop table [#T]Create table #T(id int identity(1,1) not null, remark varchar(8001) null)Insert into #TExec master.dbo.xp_cmdshell 'type e:/data.txt' select * from #T剩下就靠你自己 根据"数据类型"
阅读全文
摘要:转贴,仅引用了 FSO,PDF 格式可以自己写,就像标志语言:Creating a PDF from a Stored Procedurehttp://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp不愿注册就贴出来:Creating a PDF from a Stored ProcedureRegular Columnist : MIvica Posted: 08/26/2003 More Articles From This Columnist 14089 Reads Add A.
阅读全文