SET NOCOUNT ON :- not return a count value
@@Identity :- return a value in primary key field which related with the newly inserted row
GETDATE() :- get the sql server time
Tuesday, August 30, 2011
Write a Stored Procedure
This is basic thing, how to insert data using stored procedure. There are 4 fields I used in my User table (Id,UserName,Password,DateCreated).
SET NOCOUNT ON :- not return a count value
@@Identity :- return a value in primary key field which related with the newly inserted row
SET NOCOUNT ON :- not return a count value
@@Identity :- return a value in primary key field which related with the newly inserted row
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment