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,612 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,961 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,992 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,545 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,011 reads
Blogs
Daily Coping 4 Jun 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – June 2020 – DML Triggers
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...
Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism
By Cludio-Silva
We have seen how we can export and save the results to a folder...
Forums
Marketing Your Brand On Pinterest
Strategic Ways to Use Marketing Your Brand On Pinterest. Make sheets with watchwords in...
Database Extended Properties
Comments posted to this topic are about the item Database Extended Properties
Ask SSC