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 |
Why are you getting errors when creating a new odbc dsn?
What is the use of toad or sqldbx.?
How can you start sql server in different modes?
What are sql dirty pages?
What is resource governor in sql server?
What is use of except clause? How does it differ from not in clause?
How to execute the cursor queries with "open" statements?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
What are the different types of triggers in SQL SERVER?
Explain query editor regions
What is user stored procedure & it purpose?
What are the benefits and tasks of object explorer? : sql server management studio