----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: ChangingShiv Message 1 in Discussion Whats the difference between UNION and UNION ALL ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table. , while UNION ALL selects all records from both the tables. What is COMPUTE clause in SQL? COMPUTE clause is used in SQL to produce subtotals for each group. What is SQl injection ? It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a database from which the data would normally not be available and/or to gain access to an organizations host computers through the computer that is hosting the database. As name suggest we inject SQL which can be relatively dangerous for the database. Example this is a simple SQL SELECT email, passwd, login_id, full_name FROM members WHERE email = 'x' Now somebody does not put x as the input but puts x ; DROP TABLE members;. So the actual SQL which will execute is :- SELECT email, passwd, login_id, full_name FROM members WHERE email = 'x' ; DROP TABLE members; Full Interview Questions for .NET and SQL Server http://www.geocities.com/dotnetinterviews/ Full free download of interview questions in PDF format from http://www.questpond.com Help the community to make job search easier mail your questions to [EMAIL PROTECTED] Looking for a onsite job mail your resumes at [EMAIL PROTECTED] ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
