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 |
how to find 6th highest salary
Do you know concepts and capabilities of sql server?
How will you decide the active and passive nodes?
How to delete the duplicate rows from a table in SQL Server ??
Explain the collation?
Does group by or order by come first?
What is page-level compression?
What are different backups available in sql server?
DIFFERENCE BETWEEN SQL SERVER 2005 and 2008
How many types of TRIGGERS are there in MS SQL Server?
8 Answers CarrizalSoft Technologies, TCS, United Healthcare,
What is used to replicate sessions between instances in coldfusion clusters?
CLR Integration ? what is Notification services ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)