When we should use and scope of @@identity?
No Answer is Posted For this Question
Be the First to Post Answer
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 a constant or literal in ms sql server?
How are the unique and primary key constraints different?
How to create view in stored procedure sql server?
Which command executes the contents of a specified file?
what is diffrent between store procedure and trigger
Explain the difference between function and stored procedure?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How can delete duplicate records in cte in sql server?
How can sql server instances be hidden? : sql server security
Why SQL Agent is used?