What is history table in sql server?

0 Answers  

---

How to connect PK and FK?

2 Answers  

---

How much space does sql server 2016 take?

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

What is outer join in sql server joins?

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

Explain transaction server implicit?

0 Answers  

---

What is log ldf?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---