1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / rezaafandi

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Why would you call update statistics?

1 Answers  

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

What is the purpose of object explorer and its features? : sql server management studio

1 Answers  

Anyone please explain me the concept of Serialization?

3 Answers  

What protocol does sql server use?

1 Answers  

what is hash nonclustered index

1 Answers  

What are the differences between stored procedure and view in sql server?

1 Answers  

What’s the use of custom fields in report?

1 Answers  

what's the information that can be stored inside a bit column? : Sql server database administration

1 Answers  

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1 Answers  

How to divide query output into multiple groups with the group by clause in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories