How to encrypt Strored Procedure in SQL SERVER?
No Answer is Posted For this Question
Be the First to Post Answer
Why Do you want to work in this company?
What is the purpose of update statistics and scope_identity() function?
How do I view a stored procedure in sql server?
What do you know about system database? : SQL Server Architecture
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is normalization? Explain its different types?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
when you create a database how is it stored? : Sql server database administration
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 basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to create a testing table with test data in ms sql server?