HELP - Stored Proc/Insert Stmt/Return column value...

[ASP .NET Newbie]

I am trying to insert a new record into my database, and have it return a
uniqueidentifie r as the "newcatid". I don't use integers as my "id"'s, but
rather uniqueidentifie rs. Here's my Stored Proc:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS
INSERT INTO Categories (catname) VALUES (@catname)
/* SET NOCOUNT ON */
RETURN

Any help please?!

[Greg Burns]

Since the GUID doesn't have to come from the db, I would create it on the
client and pass it to your sproc...

Here is just a bunch of random code that uses GUID's client side, hope it is
not too confusing. :^)

Dim g As Guid
g = System.Guid.New Guid

cmd.Parameters. Add(New SqlParameter("@ GUID", SqlDbType.Uniqu eIdentifier,
16)).Value = g

Dim myGUID(8) As Byte
myGUID = g.ToByteArray

myGUID = CType(dr.GetSql Binary(0).Value , Byte())

myGUID = CType(cmd.Param eters("@GUID"). Value, Byte())

HTH,
Greg

"ASP .NET Newbie" <Ch*********@Pr ospectiveLink.c om> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...

I am trying to insert a new record into my database, and have it return a
uniqueidentifie r as the "newcatid". I don't use integers as my "id"'s, but rather uniqueidentifie rs. Here's my Stored Proc:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS
INSERT INTO Categories (catname) VALUES (@catname)
/* SET NOCOUNT ON */
RETURN

Any help please?!

[Greg Burns]

Should also mention, if you still want to do it on the server then:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS

SET @newcatidID = NEWID()

INSERT INTO Categories (catidID, catname) VALUES (@newcatidID,@c atname)

Greg
"Greg Burns" <greg_burns@DON T_SPAM_ME_hotma il.com> wrote in message
news:%2******** **********@tk2m sftngp13.phx.gb l...

Since the GUID doesn't have to come from the db, I would create it on the
client and pass it to your sproc...

Here is just a bunch of random code that uses GUID's client side, hope it
is
not too confusing. :^)

Dim g As Guid
g = System.Guid.New Guid

cmd.Parameters. Add(New SqlParameter("@ GUID", SqlDbType.Uniqu eIdentifier,
16)).Value = g

Dim myGUID(8) As Byte
myGUID = g.ToByteArray

myGUID = CType(dr.GetSql Binary(0).Value , Byte())

myGUID = CType(cmd.Param eters("@GUID"). Value, Byte())

HTH,
Greg

"ASP .NET Newbie" <Ch*********@Pr ospectiveLink.c om> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...

I am trying to insert a new record into my database, and have it return a
uniqueidentifie r as the "newcatid". I don't use integers as my "id"'s,

but

rather uniqueidentifie rs. Here's my Stored Proc:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS
INSERT INTO Categories (catname) VALUES (@catname)
/* SET NOCOUNT ON */
RETURN

Any help please?!

[ASP .NET Newbie]

This is actually the approach I went with. I had done it on the client side
in ASP, but I'm in ASP.NET development now, and changing things over to
utilize Stored Procedures.

Thanks for your help!

Chad

"Greg Burns" <greg_burns@DON T_SPAM_ME_hotma il.com> wrote in message
news:O1******** ******@TK2MSFTN GP09.phx.gbl...

Should also mention, if you still want to do it on the server then:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS

SET @newcatidID = NEWID()

INSERT INTO Categories (catidID, catname) VALUES (@newcatidID,@c atname)

Greg
"Greg Burns" <greg_burns@DON T_SPAM_ME_hotma il.com> wrote in message
news:%2******** **********@tk2m sftngp13.phx.gb l...

Since the GUID doesn't have to come from the db, I would create it on the client and pass it to your sproc...

Here is just a bunch of random code that uses GUID's client side, hope it is
not too confusing. :^)

Dim g As Guid
g = System.Guid.New Guid

cmd.Parameters. Add(New SqlParameter("@ GUID", SqlDbType.Uniqu eIdentifier,
16)).Value = g

Dim myGUID(8) As Byte
myGUID = g.ToByteArray

myGUID = CType(dr.GetSql Binary(0).Value , Byte())

myGUID = CType(cmd.Param eters("@GUID"). Value, Byte())

HTH,
Greg

"ASP .NET Newbie" <Ch*********@Pr ospectiveLink.c om> wrote in message
news:u5******** ******@TK2MSFTN GP12.phx.gbl...

I am trying to insert a new record into my database, and have it return a uniqueidentifie r as the "newcatid". I don't use integers as my "id"'s,

but

rather uniqueidentifie rs. Here's my Stored Proc:

ALTER PROCEDURE dbo.spNewCat
(
@newcatidID uniqueidentifie r OUTPUT,
@catname varchar(50) )
AS
INSERT INTO Categories (catname) VALUES (@catname)
/* SET NOCOUNT ON */
RETURN

Any help please?!