Answer Posted / sathish kondaveeti

create table value(num int(3))
insert into value values(001)
insert into value values(003)
insert into value values(023)

to see this table
select * from value

What are the diifferences between the ms sql server vs mysql?

1235

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

996

---

What is the use of =,==,=== operators?

1057

---

Can we call stored procedure in view in sql server?

940

---

Explain the usage of floor function in sql server.

1019

---

What is buffer cash in sql server?

1204

---

Can two tables share the same primary key?

984

---

What are the different types of backups avaialabe in sql server 2005?

1062

---

How to use old values to define new values in update statements in ms sql server?

1330

---

Does group by sort data?

949

---

How will you know when statistics on a table are obsolete?

1129

---

How to execute a stored procedure in ms sql server?

1250

---

what types of replication are supported in sql server? : Sql server database administration

1129

---

What is sql language?

1230

---

what is bit datatype? : Sql server database administration

963

---