What is self contained multi valued query?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between migration and upgradation in sql server?
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 are the mathematical functions supported by sql server 2005?
What is the diffrence between update_one and auto_fix?
Why we should not use triggers?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
What are the types of subquery?
Explain what is the difference between a local and a global temporary table?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
What are primary keys and foreign keys?
What are the different acid properties?