Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is normalization of database? What are its benefits?

0 Answers  

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,

What are the advantages of stored procedure in sql server?

0 Answers  

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

What is an sql server agent?

0 Answers  

diffrence between function and procedure

5 Answers   Wipro,

How to list all columns in a table using odbc_columns()?

0 Answers  

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

Define indexes?

0 Answers  

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

For more SQL Server Interview Questions Click Here
Categories