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,746 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,746 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,620 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,985 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,080 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,678 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,044 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers