|
|
-
|
|
Queue data structure work First in First out basis (FIFO). Its means that the first inserted item will come out first
...
|
|
-
|
|
Ever had a situation where you had to attach a database when all you had were the data files? Perhaps when you downloaded the AdventureWorks sample databases from CodePlex? Here's a script to attach a database with just the data files using CREATE DATABASE....ATTACH_REBUILD_LOG statement...
|
|
-
|
|
If you want to save your PowerPoint presentation in HTML format and want it to show in a browser(IE) then following code might help you. Please be informed that this may not work for other browsers (other than IE)
Read more: http://msdn.microsoft.com/en-us/library/microsoft.office.interop.powerpoint.application.aspx
...
|
|
-
2
Liked
|
0
Production
|
1
Comments
|
|
How to: Check the Status of E-Mail Messages Sent With Database Mail?...
|
|
-
|
|
**Use case:** after some abortive attempt to make a copy of a database you can face with a problem that you have a copy of original database with all data, but all DEFAULT constraints were lost.
This script allows you to get a list of all DEFAULT cons...
|
|
-
|
|
1)How to Create User Define Role?
2)How to Give Particular Access to Role?...
|
|
-
|
|
using this script we can format number user defined format for positive and negative value...
|
|
-
|
|
This script demonstrates how to backup a database to a network share (i.e. UNC path). This script is written to take a full database backup for demonstration purposes. However, you can customize this script to suit your backup strategy (differential/log/full backup)....
|
|
-
4
Liked
|
0
Production
|
3
Comments
|
|
This script is export gridview data in excel file...
|
|
-
|
|
This script helps restore a database from a backup file lying on a network share (i.e. UNC path). Please customize this script for your configuration. For demonstration purposes, this script has been written to perform a complete restore of the database....
|
|