Help in writing complex store procedure or Big sot

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Help in writing complex store procedure or Big sot

Author

Topic

KumarHarsh
Starting Member

3 Posts

Posted - 2009-04-14 : 03:09:05

Hi,

I want to learn complex sotre procedure,which have several dml statement.
What is the correct syntax for writing it along with error handler,rollback and commit transaction.
Anyone there who would guide me.

Thanks

Best Regards
Kumar Harsh

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-14 : 03:15:10

There are examples in Books Online, the SQL Server helpfile.

E 12°55'05.63"
N 56°04'39.26"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-14 : 03:16:01

Also, stored procedure shouldn't be written complex.
Keep them as simple as possible.

It makes maintaining and handling much easier.

E 12°55'05.63"
N 56°04'39.26"

KumarHarsh
Starting Member

3 Posts

Posted - 2009-04-14 : 03:22:05

Hi,

I agree,but in case situation arise one should be prepared for it.

quote:
Originally posted by Peso

Also, stored procedure shouldn't be written complex.
Keep them as simple as possible.

It makes maintaining and handling much easier.

E 12°55'05.63"
N 56°04'39.26"

Best Regards
Kumar Harsh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources