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

What are the underflow and overflow behaviors on float literals?

0 Answers  


What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,


Do you know sql server 2008 backup compression?

0 Answers  


What is a non-clustered index?

0 Answers  


Is candidate a key?

0 Answers  


How to connect php with different port numbers?

0 Answers  


What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  


Why truncate is ddl command?

0 Answers  


What is difference between rollback immediate and with no_wait during alter database?

0 Answers  


How do I find the sql server database version?

0 Answers  


How to copy the tables, schema and views from one sql server to another?

0 Answers  


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  


Categories