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

How to check if a table is being used in sql server?

0 Answers  

What does null mean?

0 Answers  

Some queries related to SQL

0 Answers   Motorola,

Differences between Standby Vs No recovery?

2 Answers   Wipro,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

What are the underflow and overflow behaviors on float literals?

0 Answers  

What is store procedure? When do you use?

0 Answers  

How to enforce security in sql server? : sql server security

0 Answers  

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

What is a transaction and why is it important?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories