Here we will go through the some useful SQL Queries.... To Retrive all the Database of SQL server.
use master; select name from sysdatabases To Retrive all the tables of SQL server.
SELECT table_name FROM information_schema.tables To Retrive all the DataTypes of SQL server.
select name from systypes To Retrive all the Stored procedure of a Database with ascending order.
select name from sysobjects where type='p' order by name asc
To delete StoredProcedure.
use dbname ; drop procedure procedurename To BackupDatabase.
use master;BACKUP DATABASE dbnameTO disk= pathname
To Restore Database.
use master;restore database backupfilename from disk=pathname with replace