Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~184 People Reached
Favorite Forums
Member Avatar for gedkins

I have a stored procedure in SQL Server 2008 that follows: USE [Numbers] GO /****** Object: StoredProcedure [dbo].[thenextnum] Script Date: 09/23/2009 15:35:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[thenextnum] @descrip varchar(50) as begin declare @t table (nextseq varchar(100)) update number_definition_table set Current_Number=Current_Number+1 output inserted.prefix_format +(Case …

Member Avatar for GeekByChoiCe
0
184