Answer / Vivek Misra

"No, the WRITETEXT statement does not activate triggers in SQL Server. It is used to write data into a filegroup or a specific file within a database, bypassing the regular table structure and data manipulation logic, including triggers.

What is extended stored procedures?

1 Answers  

---

what is sql injection?

2 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

1 Answers  

---

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

---

What are types of subqueries?

1 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Why we use functions in sql server?

1 Answers  

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1 Answers  

---