Plz explain me the SP - SQL Server Forums

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

Development Tools

ASP.NET

Plz explain me the SP

Author

Topic

Swati Jain
Posting Yak Master

139 Posts

Posted - 2007-04-13 : 06:52:49

DECLARE @RC int
DECLARE @SUBORDER_GUID varchar(50)
DECLARE @SUBORDER_MODIFIED_BY varchar(50)
SELECT @SUBORDER_GUID = NULL
SELECT @SUBORDER_MODIFIED_BY = NULL
EXEC @RC = [M3].[dbo].[M3_SUBORDER_SPLIT] @SUBORDER_GUID, @SUBORDER_MODIFIED_BY
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: M3.dbo.M3_SUBORDER_SPLIT'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-13 : 06:56:17

Read about Procedure and Output parameter in sql server help file

Madhivanan

Failing to plan is Planning to fail

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-13 : 07:03:39

SP? But I don't see the contents of SP here...all you posted is how you are calling an SP, returning completion status in some variable and printing the status variable.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources