what happens on checkpoint? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
What factors you will consider calculating the storage requirement for that view?
What are the differences between stored procedure and the dynamic sql?
What is a db view?
How to replace given values with null using nullif()?
How many clustered indexes there can be on table ?
What is key set driven?
What is merge join?
What is scheduled job and how to create it?
what are constraints? : Sql server database administration
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
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
How do you clear a log file?