Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



what is meant by sql injection with example and one more question how to catch the errors in sqlse..

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

what is meant by sql injection with example and one more question how to catch the errors in sqlse..

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

Post New Answer

More SQL Server Interview Questions

Why are you getting errors when creating a new odbc dsn?

0 Answers  


How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  


What is scalar user-defined function?

0 Answers  


How much does sql server 2016 cost?

0 Answers  


What is ems sql management studio? : sql server management studio

0 Answers  


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  


Explain left outer join and right outer join?

0 Answers  


What are the types of stored procedures in an sql server?

0 Answers  


What are the triggers in sql?

0 Answers  


What is optimistic concurrency?

0 Answers  


What is indexed view?

0 Answers  


Categories