This category contains useful information relating to Transact SQL (TSQL).
While going through “Question of the day” from
http://www.sqlservercentral.com/, I discovered an issue with the ISNULL function.
If you were to run the query in this script you will be surprised to hear, that the result returned is “A”. I am sure you would expect the result to be “ABC”.
Script to return a list of database tables (the schema and table name) along with a count of the records within each table. This can come in useful if you are trying to compare databases.
When SQL Server is installed, the “tempdb” database is placed by default, on the same drive that SQL Server is installed on.
As this is usually the same drive as the operating system, it is best to move the “tempdb” database to a separate drive.
Whilst studying for my MCITP Database Developer certification, I have come across a very useful function that returns the value of the first non-NULL value from multiple choices
The default value of a parameter can be specified as NULL. In this case, if you do not supply a parameter, SQL Server executes the stored procedure according to its other statements. No error message is displayed.
The procedure definition can also specify that some other action be taken if you do not give a parameter.
CJayMead's SQL Server, Endeca, MS Office Help © 2019