> >USE [Cal_hon_Desa] >GO >/****** Object: StoredProcedure [dbo].[Sel_Trae_Folio_ICS] Script Date: 05/30/2013 09:34:10 ******/ >SET ANSI_NULLS ON >GO >SET QUOTED_IDENTIFIER ON >GO > > >-- ============================================= >-- Author: xxxxx >-- Create date: 11-01-2012 >-- Description: Selecciona los datos de operacion a calcular >-- ============================================= >ALTER PROCEDURE [dbo].[Sel_Trae_Folio_ICS] > >AS >BEGIN > Select Folio_TB_ics from PRM_Folios > UPDATE dbo.PRM_Folios > SET Folio_TB_ICS = Folio_TB_ics + 1 >END > >>
DECLARE @Folio_TB_ics INT UPDATE dbo.PRM_Folios SET @Folio_TB_ics = Folio_TB_ics , Folio_TB_ICS = Folio_TB_ics + 1 SELECT @Folio_TB_icsstore last value
DECLARE @Folio_TB_ics INT UPDATE dbo.PRM_Folios SET @Folio_TB_ics = Folio_TB_ics = Folio_TB_ics + 1 SELECT @Folio_TB_ics