Skip to content

Category: SQL

Restoring a DB to a different directory

http://www.codeproject.com/Articles/708720/Solution-The-WITH-MOVE-clause-can-be-used-to-reloc

 

Hits: 289

Find all tables containing column with a certain name

 

Hits: 170

SQL – This will search any procedure, view, or function for a string.

 

Hits: 156

SQL Changing Schema Name

Changing it one by one use the following.

Changing all stored procedures.

 

Hits: 180

Simple Linq to SQL Insert and Update

 

Hits: 261