Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
What is the purpose and syntax of the IIF() function?
IIF(boolean_expression, true_value, false_value)
The IIF function returns one of two values, depending on whether the Boolean expression evaluates to true or false.
This function is new to SQL Server 2012.
What is sp_rename?
Changes the name of a user-created object in the current database. This object can be a table, index, column, alias data type, or Microsoft .NET Framework common language runtime (CLR) user-defined type.
- sp_rename [ @objname = ] 'object_name' , [ @newname = ] 'new_name'
- [ , [ @objtype = ] 'object_type' ]
How is the isolation level set, and what are the possible isolation levels?
SET TRANSACTION ISOLATION LEVEL ___;
- 1. READ UNCOMMITTED
- 2. REPEATABLE READ
- 3. SNAPSHOT
- 4. SERIALIZABLE
- 5. READ COMMITTED
- ↳ READ_COMMITTED_SNAPSHOT
What would you like to do?
Home > Flashcards > Print Preview