Answer / kiran kumar

it is not possible.since you have to provide 1000(if table
have 1000 records) city Name based on certain condition.So
there is no alternative.

What is isnull() operator?

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

How to use clusters?

0 Answers   Amdocs,

---

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---