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

SQL Query to Copy Structure and Data of One table To Other in SQLServer

How to copy structure and data of one table into another table?

Syntax: Select * into Newtable from Oldtable

Ex: select * into emp1 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