|
|
-
1 Liked
|
0 Production
|
5 Comments
|
|
We recently ran into this interesting problem, to verify whether the IP Address of the user is between the range of IP Addresses or not. Below script will return 1, If IP Address is between the range, otherwise it return 0;...
|
|
-
9 Liked
|
0 Production
|
3 Comments
|
|
This example shows how to delete multiple elements from an XML document using XML DML in TSQL...
|
|
-
9 Liked
|
0 Production
|
3 Comments
|
|
This script demonstrates how to validate an email address using a Regular Expression in C#...
|
|
-
4 Liked
|
0 Production
|
3 Comments
|
|
This script is export gridview data in excel file...
|
|
-
11 Liked
|
2 Production
|
2 Comments
|
|
This is a script to to identify the unused indexes within a database. The column 'ReadsPerWrite' is an important field to consider. ...
|
|
-
9 Liked
|
1 Production
|
2 Comments
|
|
We all know the way to create foreign key on column, and we are using UI to create it mostly instead of script. Did you used script to add foreign key?
...
|
|
-
7 Liked
|
0 Production
|
2 Comments
|
|
Script to take database backup, compress it and upload to SFTP...
|
|
-
3 Liked
|
1 Production
|
2 Comments
|
|
SQL Server provides a way to verify a database backup using the T-SQL command - RESTORE. This verification ensures that all backup sets are readable, checksum verification (if backup is checksum protected) and checking for sufficient space on the destination drives....
|
|
-
2 Liked
|
0 Production
|
1 Comments
|
|
How to: Check the Status of E-Mail Messages Sent With Database Mail?...
|
|