- ------------------------------------
- --Author:Flystone
- --Version:V1.001
- --Date:2008-08-0112:39:33
- ------------------------------------
- --TestData:ta
- Ifobject_id('ta')isnotnull
- Droptableta
- Go
- Createtableta(bnoint,bnamenvarchar(5),editornvarchar(5),bpubnvarchar(7),bdatenumeric(5,1))
- Go
- Insertintota
- select1,'数据库原理','wang','gaojiao',2006.9unionall
- select2,'信息系统','liu','kexue',2006.8unionall
- select3,'数据库实例','wang','gaojiao',2006.9unionall
- select4,'数据库习题','zhang','jixie',2005.4
- Go
- --createproc
- createprocproc_a
- @bnoint
- as
- select*fromtawherebno<=@bno
- go
- --Start
- select*
- fromOPENROWSET('SQLOLEDB','SERVER=.;UID=sa;PWD=','execcsdn_test.dbo.proc_a2')ASa
- select*
- fromOPENROWSET('SQLOLEDB','.';'sa';'','execcsdn_test.dbo.proc_a2')ASa
- select*
- fromOPENROWSET('SQLOLEDB','DRIVER={SQLServer};SERVER=.;UID=sa;PWD=','execcsdn_test.dbo.proc_a2')ASa
- --Dropproc
- dropprocproc_a
- --Result:
- /*
- bnobnameeditorbpubbdate
- --------------------------------------------------------------------------------------------
- 1数据库原理wanggaojiao2006.9
- 2信息系统liukexue2006.8
- (所影响的行数为2行)
- bnobnameeditorbpubbdate
- --------------------------------------------------------------------------------------------
- 1数据库原理wanggaojiao2006.9
- 2信息系统liukexue2006.8
- (所影响的行数为2行)
- bnobnameeditorbpubbdate
- --------------------------------------------------------------------------------------------
- 1数据库原理wanggaojiao2006.9
- 2信息系统liukexue2006.8
- (所影响的行数为2行)
- */
- --END
TSQL中调用存储过程的例子
最新推荐文章于 2020-10-12 15:48:40 发布