|
| |
Create or Drop index in a table through T-sql
Indexes are the part of a database. In Below query i am showing how to Create an Index in a Table
|
Error "String or binary data would be truncated" in Sql 2005
This error message appears when you try to insert a string with more characters than the given colu
|
Get the list of all tables of a database
In
sql server 2005, We can get the list of tables from the Sys.Tables from
a database. With the b
|
Add a column and set primary key in a table through query
In many situations we need to modify the table definition in database. I am showing how to add a C
|
how to get list of stored procedures in sql server 2005
How to get list of stored procedures in sql server 2005 and How to
select the data base from quer
|
Transaction in Sql server
Have you heared any thing like transaction in sql server. no.... Transaction is statement which ha
|
Exception handling in store procedure in sql server 2005
Exception handling is used to handle the errors occurred in program. If any problem occurred then a
|
Get the total space of all databases
This query tells the total number of space covered by the all databases of sql server. Copy and pa
|
Script to Truncate All Tables in a Database
This script truncate all tables or reset all tables of a database. In this script a loop is runnin
|
Script to get the detail of every database or specific database
This script will show the detail of the every database of the sql server. It will show the space o
|
|