Trailmax Tech

Max Vasilyev: ASP.Net MVC development in Aberdeen, Scotland
Skip to content
  • My Talks
  • cacheCopy
  • NSaga
  • Cake.SqlServer
  • About

sql

Working with Cursors in SQL Server

Posted on November 15, 2009December 8, 2016 by trailmax
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
Uncategorized   sql
0

Output from SQL Server as XML

Posted on November 15, 2009February 26, 2010 by trailmax
select * 
from table
for xml auto, elements
Uncategorized   sql
0

Insert into SQL Server table from CSV file

Posted on November 15, 2009February 26, 2010 by trailmax
BULK INSERT  table
FROM 'c:\file.csv'
WITH
( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )
GO
Uncategorized   sql
0
  • «
  • 1
  • 2

Tags

.Net asp.net Autofixture automation azure Azure-DevOps bat build server BuildServer c# cakebuild commands Dependency Injection di drivers eclipse EntityFramework git html https Identity iis java javascript jquery Linux microsoft mocking mvc OpenXml recipe regexp Registry script sql sql server stackoverflow testing tfs unit-testing Vista visual studio Windows Wireless XP

Blogroll

  • HR.Net Consaltancy and blog
  • My Git Cheat-Sheet
  • My Twitter
  • Wordpress Hosting

Recent Posts

  • Laundry Basket Bias
  • mstsc.exe vs HD screen
  • Windows Terminal
  • Using private NuGet feed with dotnet publish
  • Keyboard Shortcuts for Git in Visual Studio
Powered by WordPress | Theme: Bootstrap Basic