This example demonstrates how to rename the store procedure using Transact-SQL... More

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

In this example, you will see how to get the length of a string in T-SQL. Len function returns the numeric. Len function is used to get the length. Len function can be used in SELECT query. Len function takes only one argument 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