Answer / Ashish Srivastava

To create a data source in SQL Server, you can use the 'CREATE DATABASE' command or 'CREATE SYNONYM' based on whether it is a database or synonym.

Magic Tables ?

2 Answers   Thomson Reuters,

---

Which are ddl commands?

1 Answers  

---

How to loop through returning rows?

1 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

How to assign null values to variables or columns?

1 Answers  

---

What is a group function explain with an example?

1 Answers  

---

What is "scheduled jobs" or "scheduled tasks"?

1 Answers  

---

How to concatenate two binary strings together?

1 Answers  

---

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?

1 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1 Answers  

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1 Answers  

---

Tell me about joins in database system and explain each in detail.

1 Answers   Axtria, ITC Indian Tobacco Company,

---