hi to all teachers,... Friends who write in the query mode Full text Search in

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

0 Answers
2140 Views
I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

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?

0 Answers

What is the beast way to write CTE in SQL Server ?

0 Answers HCL,

What are the different types of backup avaible in SQL SErver

6 Answers Emphasis, IBM,

How to drop existing views from a database in ms sql server?

0 Answers

After the SQL installation what are the jobs will you configure?

1 Answers G7 CR Technologies, IBM, Satyam,

What are the advantages to use stored procedures?

0 Answers Ernst Young,

List some case manipulation functions in sql?

0 Answers

How to set database to be single_user in ms sql server?

0 Answers

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers

What is the stored procedure?

0 Answers

What is the language structure to add a record to a table?

0 Answers

What are commonly used odbc functions in php?

0 Answers

For more SQL Server Interview Questions Click Here