|
|
-
|
|
We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....
|
|
-
|
|
C# Net Convert number to word ...
|
|
-
|
|
Sometime we need to create Default values for columns after creating a tables, so as per need I am sharing a script to add Default to existing column on table....
|
|
-
9
Liked
|
0
Production
|
3
Comments
|
|
This script demonstrates how to validate an email address using a Regular Expression in C#...
|
|
-
|
|
using following code you can able to reverse string easily without using loop
private string Reverse(string strValue)
{
char[] chArray = strValue.ToCharArray();
Array.Reverse(chArray);
return new string(c...
|
|
-
9
Liked
|
0
Production
|
3
Comments
|
|
This example shows how to delete multiple elements from an XML document using XML DML in TSQL...
|
|
-
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. ...
|
|
-
|
|
This is a script we use frequently to identify the location of all clustered and non-clustered indexes as part of storage re-arrangement operations. It returns the list of all indexes along with the file group name....
|
|