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...
SQLServerLog.com - Database Tips, Techniques and Tutorials
SQL SELECT INTO Statement
SQL SELECT INTO statement is used to create a new table from an existing table with all selected rows and columns. Hence, SELECT INTO statement is also used to backup table data in day...
SQL LIKE Operator
SQL LIKE operator is used to find the specified pattern in a column. LIKE operator is used with WHERE clause and searches for regular characters or wildcard characters, wildcard characters are %, [ ], _,...
SQL DELETE Statement
SQL DELETE statement is used to remove row(s) from a table or view. Caution: This is very common mistake done by database users that they forget to include WHERE condition and all records gets deleted....
SQL INSERT INTO Statement
SQL INSERT INTO statement is used to add new records in a table. Syntax 1 You can sequentially insert values into columns according to table structure without mentioning column names. INSERT INTO TableName VALUES (value1,...
SQL UPDATE Statement
SQL UPDATE statement is used to update or modify existing record(s) in a database table. Caution: Make sure that while using UPDATE statements always remember WHERE conditions, else it will update all records in a...
