Example of calling stored procedure in tsql

1. ------------------------------------
2. -- Author: flystone
3. -- Version: v1.001
4. -- Date: 2008-08-01 12:39:33
5. ------------------------------------
7. -- Test data: Ta
8. If object_id ('ta ') is not null
9. Drop table Ta
10. Go
11. Create Table TA (BNO int, bname nvarchar (5), Editor nvarchar (5), bpub nvarchar (7), bdate numeric (5, 1 ))
12. Go
13. Insert into Ta
14. Select 1, 'database methods', 'wang ', 'gaojiao', 2006.9 Union all
15. Select 2, 'information system', 'Liu ', 'kexue', 2006.8 Union all
16. Select 3, 'database instance', 'wang ', 'gaojiao', 2006.9 Union all
17. Select 4, 'database exercise ', 'zhang', 'jixie ', 2005.4
18. Go
20. -- Create proc
21. Create proc proc_a
22. @ BNO int
23. As
24. Select * from Ta where BNO <= @ BNO
25. Go
28. -- Start
29. Select *
30. From OpenRowSet ('sqloledb', 'server =.; uid = sa; Pwd = ', 'exec csdn_test.dbo.proc_a 2') as
31. Select *
32. From OpenRowSet ('sqloledb', '.'; 'sa '; '', 'exec csdn_test.dbo.proc_a 2') as
34. Select *
35. From OpenRowSet ('sqloledb', 'driver = {SQL Server}; server =.; uid = sa; Pwd = ', 'exec csdn_test.dbo.proc_a 2') as
39. -- Drop proc
40. Drop proc proc_a
44. -- Result:
46. /*
47. BNo bname editor bpub bdate
48. --------------------------------------------------------------------------------------------
49. 1. Database principle: Wang gaojiao 2006.9
50. 2. Information System Liu KEXUE 2006.8
52. (The number of affected rows is 2)
53. BNo bname editor bpub bdate
54. --------------------------------------------------------------------------------------------
55. 1. Database principle: Wang gaojiao 2006.9
56. 2. Information System Liu KEXUE 2006.8
58. (The number of affected rows is 2)
59. BNo bname editor bpub bdate
60. --------------------------------------------------------------------------------------------
61. 1. Database principle: Wang gaojiao 2006.9
62. 2. Information System Liu KEXUE 2006.8
64. (The number of affected rows is 2)
65. */
66. -- End