How do I find the port number for sql server?
No Answer is Posted For this Question
Be the First to Post Answer
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is a livelock?
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
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 resolve the orphan use problem? : sql server security
What are the types of constraints?
Explain different types of collation sensitivity?
does physical index sort data
how to find nth highest salary
103 Answers Cognizant, IBM, NexGen, Oracle,
Different Types of Functions ?
What is difference between after and before?
Explain sp_configure commands, set commands?