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
2011-01-20 (first published: 2011-01-08)
1,734 reads
This func returns the max value,min value and count of values from collection of values
2011-01-20 (first published: 2011-01-08)
1,734 reads
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.
2011-01-10 (first published: 2010-12-23)
3,616 reads
This procedure creates insert statements for the given table and given range of values of primary key column.
2011-01-07 (first published: 2010-12-23)
2,967 reads
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
2011-01-06 (first published: 2010-12-23)
2,023 reads
I have added 2 functions here, one for email validation and another to split the string by specified separator by user.
2010-12-23 (first published: 2010-12-11)
1,612 reads
This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.
2010-12-15 (first published: 2010-12-08)
1,035 reads
This is part of a series of new job blog posts. You can find...
SQL doesn’t really give us too many tools out of the box to allow...
Did you know that you can change the browser used by SQL Server Management...
Hello experts, I'm seeing a strange issue. A user reported that they could not...
Hi, is it possible to restore an SQL Server DB to an earlier snapshot...
I have an Azure SQL DB where I have set up the Azure active...