Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 2169 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How many types of built in functions are there in sql server 2012?
What is a Join in SQL Server?
What does it mean to be in union?
What is the difference between value type and reference type?
syntex of insert
What is apply operator in sql?
What is onf in normalization form?
What is precedence constraint?
How to write an inner join with the where clause in ms sql server?
Why normalization is used?
Define synonym?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
