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...

Read More

Transact-SQL Functions

 Transact-SQL (T-SQL) functions are subprograms that encapsulate a sequence of T-SQL statements. T-SQL functions can return a single scalar value, a single row, or multiple rows. There are two types of T-SQL functions: ·        Scalar functions: return a single scalar value, such as an integer, a string, or a date/time value. ·        Table-valued functions:...

Read More