What is a heap?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
What are the advantages of paper records?
Can you please differentiate between a primary key and a unique key?
Which table keeps the locking information?
Are all views updatable ?
Explain the steps to use transact-sql cursor?
What is an indexing technique?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to verify a user name with sqlcmd tool?
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 Replication?
What is a field name?