Answer / Ashok Ram

The cost of SQL Server 2016 varies based on the edition (express, standard, enterprise) and licensing model (per processor or per core). As of the time of this response, you can find the latest pricing information on Microsoft's official website.

What is difference between group by and having?

1 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,

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

1 Answers  

---

How to verify a user name with sqlcmd tool?

1 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

1 Answers   IBM,

---

What are the 2 types of classifications of constraints in the sql server?

1 Answers  

---

What are the different SQL Server Versions you have worked on?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

1 Answers  

---

What is the difference between row_number and dense_rank?

1 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

1 Answers  

---