Viewing 8 posts - 1 through 8 (of 8 total)
Thank you, GSquared. I found a working example here: http://www.dbazine.com/sql/sql-articles/larsen6
Regards,
-Benton
December 7, 2009 at 12:35 pm
This is gonna be a one-by-one update operation (primary key based), so it seems I don't need a cursor for this one. But indeed great cursor example for a newbie...
June 29, 2009 at 3:56 pm
Thanks for your example. I'm getting the idea.
But what if I would need to populate the MyInsertedTime column using an INSERT trigger anyway? Suppose I forgot to add the...
May 7, 2009 at 4:10 pm
Thanks for your example. After trying it in practice I'm getting the idea.
Regards,
-Benton
April 24, 2009 at 3:06 pm
Yes, when I create the procedure that way it returns a recodset of several records. So in short, the answer to my question is yes, right?
April 24, 2009 at 2:19 pm
Take this example for instance:
CREATE PROCEDURE [dbo].[LISTADOCS]
@INTERNOS BIT,
@numero integer output,
@descesp varchar(30) output,
@descing varchar(30) output
AS
BEGIN
SELECT @numero=NUMERO,@descesp=DESCESP,@descing=DESCING
FROM DOCS
WHERE INTERNO=@INTERNOS
END
If I call it like this:
declare @outpar1 int
declare @outpar2 varchar(30)
declare @outpar3 varchar(30)
exec listadocs 3...
April 24, 2009 at 2:00 pm
GSquared (4/23/2009)
April 23, 2009 at 11:41 am
WayneS (4/23/2009)
CREATE TABLE #MyTable
(
MyBooleanField...
April 23, 2009 at 10:51 am
Viewing 8 posts - 1 through 8 (of 8 total)