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,960 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,989 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,528 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,003 reads
Blogs
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - PASS Video
By Rayis Imayev
(2019-Oct-23) Video recording of my webinar session on Continuous Integration and Delivery (CI/CD) in Azure...
Invest in Yourself Stop Making Excuses
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...
Every Execution Plan Is An Estimated Plan
I consider myself to be the most responsible for making such a huge deal...
Forums
SQL Management studio 2014 express edition
Guys, Can I use SSMS 2014 Express edition to connect to a lower and...
unable access sql provider in powershell without running an invoke-sqlcmd first
I encountered a weird issue and hope that somebody may have a fix for...
Function to pad Bigint with leading zeros or other single characters
Comments posted to this topic are about the item Function to pad Bigint with...
Ask SSC