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

Content with tag cursor Rss

   Items 1 to 3 of 3   

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 | 418 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 | 4,908 reads


By Naveen PK 2015/08/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,594 reads
   Items 1 to 3 of 3   
t-sql (2)    
database size (1)    
login (1)    
loop (1)    
set-based (1)    
while loop (1)