Differentiate between mongodb vs. Sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the four main query statements?
Is it possible to update the views? If yes, how, if not, why?
What is dbcc? Give few examples.
What are window functions in sql server?
What is a subquery in a select query statement in ms 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
How to enter unicode character string literals in ms sql server?
What is the default isolation level of the sql server database?
What is 3nf normalization form?
What are distinctive joins find as a part of sql?
What is update_statistics command?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.