Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-12 : 07:34:38
|
| sivanantham writes "How to create Stored Procedures in SQL Server 2000?also give me samples with Cursors and allThanksSivanantham" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 07:35:31
|
| Refer to Books online and Google.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-12 : 09:38:37
|
| Use the database wizard in Enterprise manager |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-12-12 : 09:47:07
|
| [code]CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] [ FOR REPLICATION ] AS sql_statement [ ...n ] [/code]CODO ERGO SUM |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
creating Stored Procedures in SQL Server 2000