SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Rss

   Items 1 to 3 of 3   
 

Search all columns in every table for a value

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...
By Michael Davis 2010/01/25 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |  Briefcase | 1,684 reads

SQL & the JOIN Operator

How the JOIN operator works, the different types of JOINs and relevant information about joining tables.  Read more...
By Wagner Crivelini 2009/10/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |  Briefcase | 15,931 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2009/09/16 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |  Briefcase | 1,063 reads
   Items 1 to 3 of 3   
 
Tags
backup (1)    
cross join (1)    
cte (1)    
full join (1)    
inner join (1)    
interstorm (1)    
join (1)    
left join (1)    
michael davis (1)    
restore (1)    
right join (1)    
row_number (1)    
search (1)    
t-sql (1)