How do you implement session management in SQL Server mode?
No Answer is Posted For this Question
Be the First to Post Answer
ow to bring suspect mode datbase online from scratch
Explain microsoft sql server functions?
Which language is supported by sql server?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
how to select a field with firstletter as capital and remaining are small letters
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What is BCP? When do we use it?
Explain about extended stored procedure?
What functions can a view be used to performed?
What is sql view?
How you can change a cross join into an inner join?
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