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,730 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.
2011-01-10 (first published: 2010-12-23)
3,611 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.
2011-01-07 (first published: 2010-12-23)
2,957 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.
2011-01-06 (first published: 2010-12-23)
1,988 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.
2010-12-23 (first published: 2010-12-11)
1,516 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.
2010-12-15 (first published: 2010-12-08)
1,002 reads
Blogs
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
Forums
Sql 2014 sp3 - extra stats created
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC