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,738 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,738 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,619 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,975 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,053 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,650 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,039 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello All, I have recently joined a project, where main, core tables with millions...
Long time listener, first time caller. I have a problem that my usual bag...
evening All hoping someone can shed some light - I have a (originally) 2...
How many table hints can I include in a query?
See possible answers