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

Scripts by Vimal Lohani

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Store a file and Retrieve it in SQL Server

Store a file & Retrive it in Sql Server  Read more...
By Vimal Lohani 2016/10/21 | Source: SQLServerCentral.com | Category: binary data
Rating: |  Discuss |   Briefcase | 1,970 reads

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/27 | Source: SQLServerCentral.com | Category: detach database
Rating: |  Discuss |   Briefcase | 955 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric :  Read more...
By Vimal Lohani 2014/10/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,456 reads

Accurate Time between Two Dates in Year, Month,Day Format

This script shows the total time between two dates.  Read more...
By Vimal Lohani 2016/03/29 | Source: SQLServerCentral.com | Category: date difference
Rating: |  Discuss |   Briefcase | 3,023 reads

Code For Truncating Table with foreign Key Constraints

This can be used for data warehouses as well as truncating table with foreign key constraints.  Read more...
By Vimal Lohani 2016/04/08 | Source: SQLServerCentral.com | Category: truncating tables
Rating: |  Discuss |   Briefcase | 2,570 reads

Defragmentation and update statistics for all online databases

Defragment and Update Statistics.   Read more...
By Vimal Lohani 2016/05/25 | Source: SQLServerCentral.com | Category: defragmentation.
Rating: |  Discuss |   Briefcase | 2,076 reads
   Items 1 to 6 of 6