Sign Up Login


  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

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

What is a file group?

0 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,




What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

What is reference section?

0 Answers  

What is local temp table?

0 Answers  

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

What is extent? Types of extents?

0 Answers  

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

how to know description of a table in sqlserver 2000

8 Answers  

For more SQL Server Interview Questions Click Here
Categories