What is a select query statement in ms sql server?
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 would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
What is the difference between constraints and triggers?
What is the difference between osql and query analyzer?
What command do we use to rename a db?
How do you clear a log file?
what is Equity join?
What is difference between delete and truncate commands?
What are the five characteristics of good data?
When do you use SQL Profiler?
What is transaction server explicit transaction?
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,