Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag cursor Rss

   Items 1 to 4 of 4   

Windowing Functions: Tell me when that changes.

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource  Read more...
By Michael Morin 2016/02/17 | Source: | Category: windows functions
Rating: |  Discuss |   Briefcase | 4,711 reads

Instance wide script to add user (the 4th way)

The script can be used to perform any task against all databases hosted on an instance. This is an example script that checks if a user is in a database if it is not then create the user and add it db_datareader role.   Read more...
Rating: |  Discuss |   Briefcase | 532 reads

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.  Read more...
By Tom Staab 2015/12/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,060 reads


By Naveen PK 2015/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,610 reads
   Items 1 to 4 of 4   
t-sql (2)    
cte (1)    
database size (1)    
lag (1)    
lead (1)    
login (1)    
loop (1)    
max (1)    
set-based (1)    
while loop (1)    
windows functions (1)