Answer Posted / monal

You can also do this.

create table Test
(officeid integer not null,
empid integer not null,
age integer ,
sex varchar(5),
name varchar(20),
PRIMARY KEY (OFFICEID, EMPID))


this will also create composite primary key and cluster
index on composite primary key.

Explain Geometry datatype in sql server 2008 with example

967

---

What is transact-sql ddl trigger?

1101

---

How to create a new schema in a database?

1137

---

What is the benefit of normalization?

1074

---

What security features are available for stored procedure?

1029

---

What is the meaning of resultset type_scroll_insensitive?

950

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

934

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1502

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1320

---

How to fetch the next row from a cursor with a "fetch" statement?

1066

---

how to use DTS package in 2000,2005,2008 in sql server

1828

---

What is PROJECTION Operation?

1011

---

What happens if the update subquery returns multiple rows in ms sql server?

1121

---

What are clustered and non-clustered index?

998

---

Why do we need different type of parameter?

1049

---