set nocount on
Posted: Tue 03 Feb 2009 04:13
Hi
I'm create sample procedure at SSMS(SQL Server Management Studio)
and execute sp
Reult Tab print 13 records and Message Tab print "(13 rows affected)".
but when procedure is alter
Message Tab is not print message
How can I distinguish between the two SDAC?
I'm create sample procedure at SSMS(SQL Server Management Studio)
Code: Select all
create procedure testout
AS
set nocount off
select top 100 * from dbo.DatabaseLog
Code: Select all
exec testout
but when procedure is alter
Code: Select all
alter procedure testout
AS
set nocount on
select top 100 * from dbo.DatabaseLog
How can I distinguish between the two SDAC?