- 11 months ago
- Aditya Kumar Patel
- 382 Views
- Comments
- SQL Server
The clustered index is used to reorder the stored data in physical order of the table and search based on the key values. Each table can have only one clustered index.
- 11 months ago
- Aditya Kumar Patel
- 394 Views
- Comments
- SQL Server
A global temporary table is created using CREATE TABLE statement with the table name prefixed with a double number sign (##table_name).
- 11 months ago
- Aditya Kumar Patel
- 397 Views
- Comments
- SQL Server
UNION: Union command is used to select related information from two tables. It will remove duplicate rows, it will retrieve unique rows from all tables.
- 11 months ago
- Aditya Kumar Patel
- 432 Views
- Comments
- SQL Server
Triggers are used to execute a batch of SQL code when insert or update or delete commands are executed on a table.
- 11 months ago
- Aditya Kumar Patel
- 429 Views
- Comments
- SQL Server
A Stored Procedure is a collection or a group of SQL statements. Stored Procedures are a precompiled set of one or more statements that are stored together in the database.
- 11 months ago
- Aditya Kumar Patel
- 355 Views
- Comments
- SQL Server
Constraints are rules and restrictions applied on a column or a table such that unwanted data can't be inserted into tables.
- 11 months ago
- Aditya Kumar Patel
- 440 Views
- Comments
- SQL Server
Temp table is a temporary table that is generally created to store session specific data. Once the connection's severed for any reason, the table's automatically dropped.
- 11 months ago
- Aditya Kumar Patel
- 421 Views
- Comments
- SQL Server
1. TRUNCATE is a DDL command 2. TRUNCATE is executed using a table lock and whole table is locked for remove all records. 1. DELETE is a DML command. 2. DELETE is executed using a row lock, each row in the table is locked for deletion.
- 11 months ago
- Aditya Kumar Patel
- 387 Views
- Comments
- SQL Server
A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table.
- 11 months ago
- Aditya Kumar Patel
- 343 Views
- Comments
- SQL Server
index is used to increase the performance and allow faster retrieval of records from the table