Author: Instructor
Oracle / PLSQL: CONVERT Function
Description The Oracle/PLSQL: CONVERT function converts a string from one character set to another. The only practical use of the[…]
Read moreCAST and CONVERT (T-SQL)
CAST and CONVERT CAST and CONVERT functions convert an expression of a particular data type into another data type. The CAST[…]
Read moreData Type Conversion
Data Type Conversion Data type conversion is when a particular data type is converted into another data type. There are[…]
Read moreISNULL – Microsoft (T-SQL)
ISNULL function defined ISNULL is a Microsoft T-SQL function created to recognize NULL values and respond with a replacement value. It is[…]
Read moreWhat is T-SQL (Transact-SQL)
T-SQL (Transact-SQL) T-SQL (Transact-SQL) is a programming language but more specifically it is an extension (enhancement) made by Microsoft and[…]
Read moreTable Value Constructor
Table Value Constructor (Transact-SQL) Table Value Constructor (TVC), sometimes called Row Constructor, let you create a table expression simply by[…]
Read moreTimestamp Filename SQL Backup
Timestamp Filename Can you create a date timestamp filename for SQL server backup files? A client recently asked if this was possible[…]
Read more