what is meant by sql injection with example and one more
question how to catch the errors in sqlserver
Answers were Sorted based on User's Feedback
Answer / sudheer
sql injection attacks are used to steal information from a
database from which normally not be available and /or to
gain access to an organaization 's host computers through
the computer that is hosting the database.
EXAMPLE:
select email,pwd,login_id,fullname from members where
email='x'
Now somebody does not put 'x' as the input but
puts 'x ;drop table members;' so the actual sql wich will
execute is
select email,pwd,login_id,fullname from members where
email=x;drop table members;
Think once what happens to ur database.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / kanan
how to catch the errors in sqlserver?
BEGIN TRY
SELECT 1/0
END TRY
BEGIN CATCH
RETURN ERROR_NUMBER()
RETURN ERROR_MESSAGE()
RETURN ERROR_LINE()
END CATCH
Is This Answer Correct ? | 6 Yes | 0 No |
What are the types of subscriptions in SQL Server replication?
Do you know how to implement service broker?
What is the system function to get the current user's user id?
What is the need for group functions in sql?
How to manipulate data from one table to another table ?
what is raid and what are different types of raid configurations? : Sql server database administration
explain different types of jions with examples briefly?
How do I delete a sql server database?
Does an index slow down updates on indexed columns?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is policy management?
What is a partitioned view?