How to defragment table indexes?
No Answer is Posted For this Question
Be the First to Post Answer
What is the osql utility?
How do you optimize Sql queries ?
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
What is openxml in sql server?
What is the difference between SQL notification and SQL invalidation?
What happens when converting big values to numeric data types?
What is importing utility?
Write a query for primary key constraint with identity key word?
what are constraints? Explain different types of constraints? : Sql server database administration
whats new about truncate in sql server 2008?
0 Answers MedSave Healthcare, Serco,
What is difference between Datepart() and Datename() in SqlServer?
Explain what are sparse columns?