Explain about protocol layer present in SQL server?
How to create a trigger for insert only?
How connect excel to sql server?
What is the purpose of forms?
how to replace double quotes by single quotes in sql server
Why the trigger fires multiple times in single login?
Explain what is sql server english query?
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 magic tables in sql server?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
hi i gone though satyam interview. what is Acid Properties?
How do I find the transaction log size in sql server?
What is a non clustered primary key?