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.

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

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

What is @@error in sql?

0 Answers  

---

What is cursors?

0 Answers   NA,

---

What is optimization and its types?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

Do you know exporting and importing utility?

0 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

Can you index views?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

How to retrieve error messages using odbc_errormsg()?

0 Answers  

---

What is Lock table in SQL?

0 Answers   Wipro,

---