SQL Fetching Record One by One without using Cursor
SQL Fetching Record One by One without using Cursor --Fetching Record One-by-One without using Cursor DECLARE @EMP_ID CHAR( 11 ) SET ROWCOUNT 0 SELECT * INTO #MYTEMP FROM Employee SET ROWCOUNT 1 SELECT @EMP_ID = EMP_ID FROM #Employee WHILE @@ROWCO download file now