sql server blog
http://www.wiseowl.co.uk/blog/s217/sql_server_tutorial.htm
Wildcard in Sql Server Select the LIKE operator allows us to perform basic pattern-matching using wildcard characters. For Microsoft SQL Server, the wildcard characters are defi… Read MoreAlternatives to @@IDENTITY Normal 0 false false false EN-US X-NONE X-NONE … Read Morecursors status1 Find out the cursors that are allocated but not opened or closed view sourceprint?01.--Method 1 02. 03.select name from sys.dm_exec_cursors(0) where… Read MoreCursors How to Perform SQL Server Row-by-Row Operations Without Cursors USE AdventureWorksGO… Read MoreSQLServer TSQL CheatSheetSQLServer TSQL CheatSheetDECLARE and SET VaribalesDECLARE @Mojo intSET @Mojo = 1SELECT @Mojo = Column FROM Table WHERE id=1IF / ELSE IF / ELSE Stateme… Read More
0 comments:
Post a Comment