SQL Query to Return Information About all Databases in SQLServer

Check this post for sqlserver faqs


SQL Query to Return Information About all Databases in SQL Server


exec sp_helpdb


Check here for SQL Query to delete multiple databases in sqlserver
SQL Query to rename database in sqlserver.
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

Query to get only day from particualar date

Query to get only day from particualar date
select day(datecolumnname)as day from tablename

query to get system date

query to get system date and time using sqlserver

select getdate()

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