SQLServerCentral - Scripts by Bharat Panthee

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,551 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,910 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,793 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...

By Bharat Panthee 2011/01/10 | Source: SQLServerCentral.com | Category: multiple rows value in single column

Rating:

|

Discuss |

Briefcase | 3,419 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,304 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 | 934 reads