SQL Query to Return Information about a single database

Sql Server Faqs

Check this post for SQL Query to Return Information About all Databases in SQL Server

SQL Query to Return Information about a single database


Syntax:exec sp_helpdb databasename


ex:exec sp_helpdb lakshmi

Query to get only year from particular date

Query to get only year from particular date
select year(datecolumnname)as year from tablename

query to rename table

query to rename table using sqlserver

sp_rename existingtablename,newtablename

query to get column names of table

query to get column names of particular table using sqlserver 2000

select name from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

sql query to get column count of table-query to get number of columns in table

query to get number of columns of particular table using sqlserver

select count(*)as NOC from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')

query to retrieve top 5 records from table

query to get top 5 records using SqlServer

select top 5 * from tablename
This query displays top 5 records of your table.

select top 5 * from emp.

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs