(SQL SERVER): What is the difference between NULLand blank?
NULL has no bounds, it can be used for string , integer , date , etc. fields in a database.
NULLisn't allocated any memory.
Empty IS allocated to a memory location; although the value stored in the memory is"".
(SQL SERVER): What is a defaultvalue in sql?
The DEFAULT keyword provides a default value to a column when the SQL Server INSERT INTO statement does not provide a specific value.
Insert:
(SQL SERVER): What Arithmetic Operators opperators are available in SQL SERVER?
+ (Add) Addition
- (Subtract) Subtraction
* (Multiply) Multiplication
/ (Divide) Division% (Modulo)
(SQL SERVER):(DEF'N): What are arithmetic operators?
Arithmetic operators run mathematical operations on two expressions of one or more data types. They're run from the numeric data type category.
(SQL SERVER):(True/False): The plus (+) and minus (-) operators can also be used to run arithmetic operations on datetime and smalldatetime values.
TRUE.
(SQL SERVER): What is the difference between globaltemporary tables and local temporary tables?
Local temporary tables are visible only in the current session, while globaltemporary tables are visible to all sessions.
(SQL SERVER): What is normalization in database terms?
The process of organizing data to minimize redundancy. It usually involves dividing a databaseinto two or more tables and defining relationships between the tables. ... For example, in an employee list, each table would contain only one birthdate field.