Answer / Huma Rizvi

@@ROWCOUNT is a system function in SQL Server that returns the number of rows affected by the last statement executed. It can be used to check if any rows were inserted, updated, or deleted.

What is hot add cpu in sql server 2008?

1 Answers  

---

How do I start and stop sql server?

1 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

1 Answers  

---

What is key set driven?

1 Answers  

---

What is shared lock?

1 Answers  

---

What happens if you delete a table that is used by a view?

1 Answers  

---

What is raid? : SQL Server Architecture

1 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

1 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Mention the uses of stored procedures.

1 Answers  

---

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 is an example of a foreign key?

1 Answers  

---