Last post Feb 19, 2015 05:03 PM by smirnov
Feb 18, 2015 01:31 PM|Arial12|LINK
I have insert trigger on a table which counts total record in a table and also does lot of other things. I am passing some of these parameter to Store procedure.
when the store procedure is executed i want to print the total records which is counted in trigger. Is it possible? i can't use direct count on a store procedure
View is like this:,
declare @tcount int
select @tcount = count(*) from table1
if @tcount > 0
exec SP_t1 @tcount
now when I execute exec sp_t1 i want this store procedure to print the value came from this view.
Thanks for your help.
Feb 18, 2015 01:48 PM|smirnov|LINK
Where do you want to print it? In sql server management studio's console?
Feb 19, 2015 04:49 PM|Arial12|LINK
I want to print when Store procedure is executed using management studio.
In management studio, when I run exec Sp_t1 then i have to supply parameter for @tcount and then it print whatever value was supplied.
I want to print during execution time.
Feb 19, 2015 05:03 PM|smirnov|LINK
then use select