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 system database in sql server 2005?

988

---

can a table be moved to different filegroup? : Sql server administration

912

---

What do you understand by sql server agent?

908

---

What is difference between count (*) and count column?

841

---

what is isolation level at dead lock?

2088

---

What is the difference between functions and stored procedures?

1093

---

How do I open port 1433?

883

---

What are the advantages of using a stored procedure?

942

---

Difference between report and query parameter.

1026

---

What is collation?

1098

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2323

---

Explain the functionalities that views support?

1046

---

What do you mean by tablesample?

1035

---

Explain cross join or cartesian product in sql?

842

---

What is database replication?

1079

---