How to test values returned by a subquery with the in operator?
No Answer is Posted For this Question
Be the First to Post Answer
What is nolock hint in sql server 2008
Can you explain what is the use of custom fields in report?
syntax and example for bitmap index in sql???
Explain various data region available in ssrs with their use?
What is normalization and what are the advantages of it?
What are the basic functions for master, msdb, model, tempdb and resource databases?
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
What happens if you delete a table that is used by a view?
What sql server means?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
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 the difference between row_number and dense_rank?