when running a stored procedure can I print debugging statements

[mit99mh]

I'm new to sql server so assume nothing!

when running a stored procedure can I print debugging statements defined in the stored proc to the query analyser

eg

CREATE PROCEDURE CS_insertUsers
@id int
AS

if exists( SELECT id FROM CS_users )
begin
// print to query analyser "id found "
return (0)
end
GO
Any help much appreciated

 

[clapag22]

What I've seen suggested (and have done on longer SP's I have created) is to add a "debug" parameter to your SP:

create proc proc_name @parm1, @parm2, ... @parmN, @debug bit
as

if @debug = 1
begin
print 'declare variables'
end

declare @var1,
@var2,
...
@varN

if @debug = 1
begin
print 'check to see if @parm1 exists'
end

if exists (select * from tbname where f1 = @parm1)

etc
etc