This example demonstrates how to modify a store procedure in the current database... More

This example demonstrates how to delete a store procedure from your database.... More

n this example, you will see how to get month name from input data. I have used build in function named DATETIME. More

Most of developers don't know that where to use SET NOCOUNT { on | off }. More

A unique identity in each row in a table is called Primary key... More

how to get all databases name in MS SQL 2005/2008 More

yesterday, some one asked me , how to get the file size of all databases in MS SQL 2008 using SQL query, So i have decided to write a query in this blog to help to all those developers who don't know. T-SQL Script SELECT DB_NAME(DATABASE_ID) AS [DATABASE NAME] , CAST(( CAST(SIZE * 8 AS FLOAT) ) / 1024 AS VARCHAR) + ' MB' AS [SIZE] FROM SYS.MASTER_FILES Output

Here Aamir Hasan has explained difference between primary key and unique key constraints. More