How to check if stored procedure is running in sql server?

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

What does executeupdate return?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

What are different types of subquery?

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

Where cross join is used?

0 Answers  

---

What is difference between join and natural join?

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---