You are here
Home > 2017 > October

ALTER COMMAND in sql

ALTER COMMAND It is used to modify the structure of the exiting table. Using ALTER command, it is possible to rename columns or the table itself, add or delete column, change the data type of exiting columns, add or drop the constraints in SQL server.   adding a column: ALTER TABLE allows

Handling NULLs in sql

Handling NULLs ISNULL() and COALESCE() functions are used to handle NULLs when combining data from different tables. ISNULL() and COALESCE() functions are commonly used functions that return first value that is not NULL among their inputs. ISNULL(): The ISNULL() function return first value that is not null among their input. It

Top