Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of statements that are supported by sql?
- 1 Answers
- 1124 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sumeet Bhatnagar
SQL supports several types of statements to manipulate and query data in a relational database:n1. Data Definition Language (DDL) Statements: These statements are used to create, alter, or delete database objects such as tables, views, indexes, and schemas.n2. Data Manipulation Language (DML) Statements: These statements are used to insert, update, delete, and retrieve data from the database.n3. Transaction Control Statements: These statements are used to manage transactions, such as COMMIT, ROLLBACK, SAVEPOINT, and BEGIN TRANSACTION.n4. Catalog (Metadata) Statements: These statements are used to retrieve information about database objects, such as DESCRIBE, TABLE, INDEX, and SP_HELP.n5. Control of Flow Statements: These statements are used to control the flow of execution in SQL code, such as IF-ELSE, CASE, LOOP, WHILE, and GOTO.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a coalesce function?
What is the difference between for xml raw and for xml auto?
List the ways in which dynamic sql can be executed?
Explain “row_number()” in sql server with an example?
what is spatial nonclustered index
What are wait types?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to enter binary string literals in ms sql server?
What kind of problems occurs if we do not implement proper locking strategy?
Is it possible to have clustered index on separate drive from original table location?
How can I check that whether automatic statistic update is enabled or not?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Can you index views?
Does view occupy space?
what is the difference between openrowset and openquery?
