Can you create a logon trigger in sql server 2005 express edition?
No Answer is Posted For this Question
Be the First to Post Answer
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
Explain different types of locks in sql server.
What is "scheduled jobs" or "scheduled tasks"?
Which system tables contain information on privileges granted and privileges obtained
How to attach adventureworkslt physical files to the server?
How to add code to the existing article (using improve article)?
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 is Sqlpaging in SqlServer 2005 ?
Tell about MOM Tool(Microsoft Operator Manager)?
How to execute a sql statement using odbc_exec()?
Is SET a SQL Keyword?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,