Answer / karthik soundararajan

TableA -- Existing Table

ID
5
5
5
5
5

Solution : SELECT DISTINCT ID INTO TableB FROM TableA

It create a table called TableB and insert only one record as shown below:

ID
5

Answer / sheshu4040

SELECT DISTINCT * INTO TABLE_NEW FROM TABLE_EXISTING

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

Write query to return all rows sql?

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is amo? : sql server analysis services, ssas

0 Answers  

---