SQLServerLog.com - Database Tips, Techniques and Tutorials

0

SQL UNIQUE Constraint

SQL UNIQUE constraint is uniquely identifies each row(s) in a table. You can have multiple UNIQUE constraints defined in a table. It prevents to enter duplicate values on uniquely identified columns that do not...

0

SQL NULL Values

SQL NULL value represent a field or column where no value is mentioned. NULL value is not equal to zero or blank space. By default a column may contain NULL values. Here we will...

0

SQL DEFAULT Constraint

SQL DEFAULT constraint is used to specify and inserts the default value in a column when there is no value specified to insert for a new record. Below query creates a table named ‘Students’...

0

SQL SUM() Function

SQL SUM() function returns the total sum of all values of a numeric column in a table. You can use SUM function with number values only and also NULL values are ignored during addition....

0

SQL DROP Statement

SQL DROP statement is used to completely delete the object from the database or you can drop database itself. You can use DROP statement to delete tables, indexes, views, procedures, users, databases etc. DROP...