Useful resources,xml (Transact-SQL)
The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.
Useful resources, Datetime arithmetic in SQL
A view has a data of its own
Data can be inserted into the table using its own view
Data can be updated in the table using its own view
A table can be altered by altering its corresponding view
A View is derived from another table
Useful resources, sp_help
Many-to-One is a type of relationship in RDBMS.
Select (salary+40^2*30/5) from employees
Useful resources, Operator Precedence (Transact-SQL)
Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing
What will be the output of the following query?
Select Substring(Hobbies,3) From students Where name= "john"
It will give an error
The "text" and "ntext" data type can store character based data. These data types can be used in joins.
Useful resources,ntext, text, and image (Transact-SQL)