Answer Posted / mohan kumar.a

The main four query statements are:-
1.) select
ex:select * from table_name

2.) insert
ex:insert into table_name(c1,c2,c3...) values(v1,v2,v3..)

3.) delete
ex: delete * from table_name

4.) update
ex:update table_name
set col_name='value'
where col_name='something'
note:examples are based on ms sql server database.k

What are the default system databases in sql server 2000?

1034

---

Why use cursor in sql server?

1087

---

What is the difference between ddl and dml?

1059

---

Define Wed Edition in SQL Azure?

100

---

What is built-in/administrator?

1021

---

How do you know if sql server is running on your local system?

1050

---

What are the functions in sql server?

958

---

What is sql sandbox in sql server?

1241

---

What is a fill factor?

1091

---

How do I manually uninstall an instance of sql server 2016?

1046

---

Would you store your query in a ssrs report or a database server? State the reason why?

155

---

Explain trigger classes i.e. Instead of and after trigger?

884

---

What is the index requirement in SQL Azure?

98

---

how you can list all the tables in a database?

1034

---

How many types of cursor type are there?

1098

---