set nocount on

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ysyang
Posts: 41
Joined: Tue 14 Jun 2005 09:10

set nocount on

Post by ysyang » Tue 03 Feb 2009 04:13

Hi

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
and execute sp

Code: Select all

exec testout
Reult Tab print 13 records and Message Tab print "(13 rows affected)".

but when procedure is alter

Code: Select all

alter procedure testout
AS
set nocount on
select top 100 * from dbo.DatabaseLog
Message Tab is not print message

How can I distinguish between the two SDAC?

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 03 Feb 2009 08:24

SDAC doesn't allow to see the number of rows affected for statements inside a stored procedure.

Post Reply