Answer Posted / mohan kuamr

# 3

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 is explicit mode in sql server?

1016

---

Explain about extended stored procedure?

862

---

What is the osql utility?

909

---

What is difference between equi join and inner join?

857

---

What is #temp and @table variable in SQL server?

1025

---

Explain an automatic checkpoint

914

---

How to recompile stored procedure at run time?

1005

---

How to filter out duplications in the returning rows in ms sql server?

1066

---

What is the Main Difference between ACCESS and SQL SERVER?

1065

---

What is role playing dimension with two examples? : sql server analysis services, ssas

952

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2027

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1016

---

How will you decide the active and passive nodes?

1070

---

What is logshipping and its purpose?

944

---

Can a table be created inside a trigger?

920

---