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 @@error in sql?

0 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

What does Master database contains?

0 Answers   Abacus,

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

What is lock escalation?

1 Answers  

---

What are the different types of collation sensitivity?

0 Answers  

---

What is MSDE?

2 Answers  

---

What are the triggers in sql?

0 Answers  

---