How can I create a new template for import ? : sql server management studio
No Answer is Posted For this Question
Be the First to Post Answer
Explain difference between control flow and data flow?
Which are ddl commands?
What is Covering Indexes? Plz explain with example
What are basics of policy management?
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
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
How does stuff differ from the replace function?
What is a linked server in sql server?
what is the difference between Delete and Truncate command in SQL
What are the differences between left join and inner join in sql server?
How to enter unicode character string literals in ms sql server?
What is unique key constraint?