Stored procedures using ms sql and asp

SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON
GO

CREATE Procedure up_new_profile
(
@member_id int,
@active bit,
@market varchar(50), ’ Does this part of code values need to equal the exact code values in values section in code?
@salutation varchar(25),
@suffix varchar(25), ’ @suffix varchar(25), and @suffix or can it equal @strsuf?
@snfname varchar(75),
@snlname varchar(75),
@profile_id int output
)
as
insert into profile(
member_id,
active,
market,
salutation,
suffix,
snfname,
snlname,
)
values(
@member_id,
@stractive
@strmakt ’ Does this part of code values need to equal the exact code values in values section in code?
@strsal
@strsuf@suffix varchar(25), and @suffix or can it equal @strsuf?
@strsfn
@strsln
)

select @profile_id = @@identity
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

Thanks in advance

i will guess that the answer is no

what happened when you tested it? ™

While running it in Query Analyzer I get the following error:

Incorrect syntax near ‘,’. Incorrect syntax near the keyword ‘print’. Must declare the scalar variable “@profile_id”.

okay, i ~think~ that i now understand what you were asking

yes, the variable names have to be the same in both places

I would advise you to read up about

@@identity, SCOPE_IDENTITY() and IDENT_CURRENT(‘tablename’)

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/