Declare @ID uniqueidentifier DECLARE cursor_name CURSOR FAST_FORWARD READ_ONLY FOR SELECT ID FROM tableName OPEN cursor_name FETCH NEXT FROM cursor_name INTO @ID WHILE (@@fetch_status <> -1) BEGIN PRINT @ID FETCH NEXT FROM cursor_name INTO @ID END DEALLOCATE cursor_name
sql
Output from SQL Server as XML
select * from table for xml auto, elements
Insert into SQL Server table from CSV file
BULK INSERT table FROM 'c:\file.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO