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

optimization techinques

2680

---

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

---

Can foreign key be deleted?

929

---

what is bit datatype? : Sql server database administration

923

---

What is a database table?

977

---

Explain rdbms?

1043

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1849

---

What is the difference between an index and a unique index?

1005

---

Is sql server a database?

1004

---

What is the advantage of sql server?

1036

---

What are the differences between left join and inner join in sql server?

1110

---

do views contain data ?

976

---

What is difference between order by and group by?

1009

---

What are system databases into sql server (2005/2008) : sql server database administration

1019

---

Difference between uniqe index and uniqe constraint?

984

---