variable

MsSQL Server Stored Procedure, declare variable and cursor recordset

How do set variable and set value variable in MsSQL Server Stored Procodure? let’go to these example : USE [dbname] GO /****** Object:  StoredProcedure [dbo].[sp_importCust]    Script Date: 12/01/2011 22:30:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[sp_importCust] @parSessionID VARCHAR(16) AS DECLARE @cif  varchar(255), @cust_name     varchar(255), @join_date     varchar, @sales_code     varchar(255), @sales_name     varchar(255), … Continue reading →