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
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,616 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,965 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,998 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,568 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,026 reads
Blogs
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Daily Coping 20 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Updated Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available...
Forums
DATEDIFF with GETWEEK worth of data
I have such an issue. I have units, on sale date and also how...
SQL REporting SErvices 2017 , how do I deny permission to users
I set site level and user level Security entry for domain users, but still...
Alter Procedure With Invalid Object Name
We are trying to update a stored procedure to reference objects that don't yet...
Ask SSC