Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Bharat Panthee

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

SQL Function to get Max, Min values from given collection of values

This func returns the max value,min value and count of values from collection of values  Read more...
By Bharat Panthee 2011/01/20 | Source: SQLServerCentral.com | Category: aggregates
Rating: |  Discuss |   Briefcase | 1,623 reads

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.   Read more...
By Bharat Panthee 2011/01/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,971 reads

Store Procedure to create Insert statement from exisiting records

This procedure creates insert statements for the given table and given range of values of primary key column.  Read more...
By Bharat Panthee 2011/01/07 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 2,862 reads

Display multiple rows values as single row value

It will display the multiple rows values in one row value.Like if there are 5 rows with values then that will be displayed in single row with specified separator.  Read more...
Rating: |  Discuss |   Briefcase | 3,519 reads

SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.  Read more...
By Bharat Panthee 2010/12/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,402 reads

Eval arithmetic statement function in SQL

This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.  Read more...
By Bharat Panthee 2010/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 957 reads
   Items 1 to 6 of 6