how many triggers you can have on a table? : Sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
How can you see what type of locks used?
How make remote connection in database?
What is database mirroring?
Mention the different authentication modes 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 types of normalization?
Can you create a logon trigger in sql server 2005 express edition?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is difference between equi join and natural join?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is indexed view? How to create it?
What are the different ways you can create databases in sql server?