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