Category: SQL Server

0

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...

0

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 %, [ ], _,...

0

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....

0

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,...

0

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...

0

SQL SELECT TOP Clause

SQL SELECT TOP clause is used to retrieve top N records or by percentage value from specified table(s) and limits the records by mentioned value in the query. If you want to fetch records in...