Answer / Piyush Dwivedi

TSQL (Transact-SQL) is a query language used in SQL Server, SQL Azure, and Sybase. It's not the same as SQL Server itself, but it's used to interact with SQL Server.

Other than truncate statement, which other command can by-pass the trigger on the tables?

1 Answers  

---

What are the different authentication modes in sql server?

1 Answers  

---

How to loop through the result set with @@fetch_status?

1 Answers  

---

What is sql server transaction log file?

1 Answers  

---

What is the Difference Between Primary and Foreign Key?

1 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  

---

Define inner join in sql server joins?

1 Answers  

---

From where can you change the default port?

3 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

1 Answers  

---

How do I run a trace in sql server?

1 Answers  

---