How do you know if sql server is running on your local system?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

Can we call stored procedure in trigger?

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

Who is the owner of a schema in ms sql server?

0 Answers  

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

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,

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---