Stored Proc

Question

Stored Proc

shailesh.arban

Newbie

Points: 7
More actions
June 8, 2009 at 5:50 am

#72231

Hi,
more than one sql statements are possible in stored procedure?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Yes

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Eralper SSCarpal Tunnel Points: 4438 More actions · Answer 2

Hello,

Actually the definition of a stored procedure includes that it is formed of a number of sql statements forming a batch of t-sql statements.

You can even call numbers of other sql procedures, sql cursors, send email, etc.

Eralper

SQL Server, T-SQL Development

Eralper
SQL Server and T-SQL Tutorials and Articles
Microsoft Certification and Certification Exams