Be Stronger Then You Excuses

Happiness is the best medicine.

MS-SQL query and ShortcutKey

1:- Change Database Name using QueryAlter database Test modify name=Test1you can also use system stored proceduresp_renameDB 'Test1','Test'2:- How to get all table name from database First select database and run below query.SELECT name FROM sys.tables3:- How to Get All stored procedures in database.SELECT   ROUTINE_SCHEMA, ROUTINE_NAMEFROM INFORMATION_SCHEMA.ROUTINESWHERE...