what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What is transact-sql language?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

What does the not null constraint do?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

What is compound operators?

0 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---