January 17th, 2012, 08:39 AM
|
|
Registered User
|
|
Join Date: Jan 2012
Posts: 23
Time spent in forums: 7 h 25 m 55 sec
Reputation Power: 0
|
|
|
SQL store procedure to PostgreSQL function
Quote: | please guid me how can i convert this store procedure to postgreSQL function |
Code:
CREATE PROCEDURE [dbo].[sp_InsertUserData]
@DataLabel varchar(50)=' ', // taking input from user
@DataDescription varchar(500)=' ', taking input from user
@UserDataDetailId varchar(500) output
AS
BEGIN
begin try
begin transaction
INSERT INTO UserDataDetails ( DataLabel, DataDescription)
values (@DataLabel, @DataDescription)
set @UserDataDetailId = SCOPE_IDENTITY();
commit transaction
end try
begin catch
rollback transaction;
print error_message()
end catch
END
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
