Some times when you click on the Database Diagram node in object explorer in SQL Server Management Studio,you get error message like Database diagram support objects cannot be installed.
|
String functions are mainly used to change the case of strings,concatenate strings,reverse strings,extract various part of strings and perform many other types of string manipulation.
|
Difference between Stored procedure and User Functions
|
SQL server Date Time Function allow to manipulate columns with DATETIME/SMALLDATETIME data types.
|
In SQL Server used Cast or Convert function to Format Date Time value or column into a specific date format.
|
SQL Server 2005 keyboard shortcuts
|
Truncate an Delete both are used to delete data from the table. These both command will only delete data of the specified table, they cannot remove the whole table data structure.Both statements delete the data from the table not the structure of the table.
|
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions in that they return values inserted into IDENTITY columns.
|
Find Nth highest Record/number/salary from table.In interview you can faced question like to give solution(query) for find Nth highest salary from given employee table.
|