Skip to content

Instantly share code, notes, and snippets.

@eternaltung

eternaltung/sp_Test2.sql

Created February 26, 2015 10:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save eternaltung/9d318986630b5d27a385 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save eternaltung/9d318986630b5d27a385 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sp_Test2.sql
CREATE PROCEDURE [dbo].[sp_Test2]
@table1_Id INT OUTPUT
AS
print 'sp_Test2:insert'
insert into testTable1 values('col1')
select @table1_Id = @@IDENTITY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment