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

Content with tag Queries Rss

   Items 1 to 13 of 13   
 

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 15,170 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By stumbling fish 2011/12/12 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 3,820 reads

Send Query Result as HTML Mail

Send a SQL query result as HTML mail using cdosys  Read more...
By EYER Daniel 2011/11/22 | Source: SQLServerCentral.com | Category: mail
Rating: |  Discuss |   Briefcase | 5,484 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,794 reads

Execute a dynamic query without return the resultset

This script illustrate how to execute a dynamic query without return the resultset, but capturing the result.  Read more...
By andre.brunaldi 2008/09/10 | Source: SQLServerCentral.com | Category: dynamic
Rating: |  Discuss |   Briefcase | 900 reads

Send Query Result as HTML Mail

Send a SQL query result as HTML mail using cdosys  Read more...
By EYER Daniel 2011/11/22 | Source: SQLServerCentral.com | Category: mail
Rating: |  Discuss |   Briefcase | 5,484 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By stumbling fish 2011/12/12 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 3,820 reads
   Items 1 to 13 of 13   
 
Tags
apply (1)    
capture (1)    
cdosys (1)    
columns (1)    
definition (1)    
dry (1)    
dump (1)    
dynamic (1)    
find (1)    
html (1)    
locate (1)    
mail (1)    
object (1)    
object name (1)    
object search (1)    
permissions (1)    
report (1)    
result (1)    
resultset (1)    
search (1)    
sql server 2005 (1)    
t-sql (1)    
without (1)