MSDE (SQL Server 2000) does not return @@Identity

Hi All,
First my apologize for cross posting. It's already posted in
sqlserver.programming. But I see this group would also help me.
I'm creating an appplication with some stored procedures. The stored
procedure needs to return the @.@.Identity of the table's new record. The
function has no errors and compiles without any warnings. The function
does work fine some times (returning value). But most of the calls are
failing and the function does not return proper value.
CREATE PROCEDURE CreateNewCourse
@.CourseName NVARCHAR(256),
@.Duration Int,
@.Contents NVarChar(500),
AS
DECLARE @.Identity int
INSERT into CourseMaster
(
CourseName,Contents,
Duration
)
VALUES
(
@.CourseName,
@.Contents,
@.Duration
)
SET @.Identity = SCOPE_IDENTITY()
return @.Identity
Any suggestions?
TIA.
Return identity as an output parameter.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Anbu" <t_anbazhagan2001@.yahoo.co.in> wrote in message
news:1143608634.206122.169410@.e56g2000cwe.googlegr oups.com...
> Hi All,
> First my apologize for cross posting. It's already posted in
> sqlserver.programming. But I see this group would also help me.
> I'm creating an appplication with some stored procedures. The stored
> procedure needs to return the @.@.Identity of the table's new record. The
> function has no errors and compiles without any warnings. The function
> does work fine some times (returning value). But most of the calls are
> failing and the function does not return proper value.
>
> CREATE PROCEDURE CreateNewCourse
> @.CourseName NVARCHAR(256),
> @.Duration Int,
> @.Contents NVarChar(500),
>
> AS
>
> DECLARE @.Identity int
>
> INSERT into CourseMaster
> (
> CourseName,Contents,
> Duration
>
> )
> VALUES
> (
> @.CourseName,
> @.Contents,
> @.Duration
> )
>
> SET @.Identity = SCOPE_IDENTITY()
>
> return @.Identity
>
> Any suggestions?
>
> TIA.
>

MSDE

I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx
|||

tmorton wrote:

See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx

Thank you very much

MSDE

Hi all expert,
Are there any programming skill related to MSDE. Also i don't know if
here is the best place to ask this question.
Thanks.
Rena.Programming against MSDE is the same as against SQL Server. Best group is pr
obably, for general questions,
.programming.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rena" <rena@.hotmail.com> wrote in message news:OVKw9gFMEHA.3016@.tk2msftngp13.phx.gbl...[vbc
ol=seagreen]
> Hi all expert,
> Are there any programming skill related to MSDE. Also i don't know if
> here is the best place to ask this question.
> Thanks.
> Rena.
>
>[/vbcol]

MSDE

Hi all expert,
Are there any programming skill related to MSDE. Also i don't know if
here is the best place to ask this question.
Thanks.
Rena.
Programming against MSDE is the same as against SQL Server. Best group is probably, for general questions,
..programming.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rena" <rena@.hotmail.com> wrote in message news:OVKw9gFMEHA.3016@.tk2msftngp13.phx.gbl...
> Hi all expert,
> Are there any programming skill related to MSDE. Also i don't know if
> here is the best place to ask this question.
> Thanks.
> Rena.
>
>

MSDE

Hi all expert,
Are there any programming skill related to MSDE. Also i don't know if
here is the best place to ask this question.
Thanks.
Rena.Programming against MSDE is the same as against SQL Server. Best group is probably, for general questions,
.programming.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"rena" <rena@.hotmail.com> wrote in message news:OVKw9gFMEHA.3016@.tk2msftngp13.phx.gbl...
> Hi all expert,
> Are there any programming skill related to MSDE. Also i don't know if
> here is the best place to ask this question.
> Thanks.
> Rena.
>
>