Get Best SQL Injection assignment

Get Best SQL Injection assignment

 

Note: In class we are using SQL Server 2000 Service Pack 4, Northwind Database, .NET 4
And the SQLInjection.zip folder that I have attached.
I just need some screen shots and a query string to complete this part.

1. Open the SQL Injection web page browsing to this web page:
Localhost/SQLInjection/SQLInjection.aspx
2. Enter the following value for the Customer Id and retrieve the information:
ALFKI
Observe the results. Print out the results and attach to lab report. Try to infer how this query might have been constructed by the program given the user input ALFKI.
The SQL query command was:
SELECT Orders.CustomerID, Orders.OrderID, COUNT (UnitPrice) AS Items,
SUM(UnitPrice*Quantity) AS Total FROM Orders
INNER JOIN [Order Details]
ON Orders.OrderID = [Order Details].OrderID
WHERE Orders.CustomerID = ‘ALFKI’
GROUP BY Orders.OrderID, Orders.CustomerID
Test it out by using the SQL Query Analyzer.
3. Now, to get you started, here is a sample SQL Injection data that will retrieve the information about all customers from the database. Enter the following in the Customer ID field and hit the submit button:
ALFKI’ or ‘1’=’1
Print out the query results and attach them to the lab report. What is the query string for this query? Test it out by using the SQL Query Analyzer.

 

Want Guide to Assignments?

Are you a struggling student who is not able to cope with the pressure he is handling in case of taking online tests due to various other activities? Or are you finding it very complicated to finish the given tests promptly with some good grades? Don’t worry, Examshelpers can help you in this situation! The IWantOnlineclasshelp.com service provider is the best quality of services you can avail of today for the betterment of your future and for the perfect arrangement of premium-level of test-taking services on your behalf. We have been consistently providing outstanding help to each & every student who is looking for affordable, reliable, and qualitative services in a timely manner. Whether it is about test issues or exam-related issues, you are facing, we can cover all by pay someone to take my online test services on the go. The Online Test Help query is solved here quickly. Just call us or mail us, and we will be there to bring some professional quality exam-taking services with a money-back guarantee, therefore you will have nothing to drop. Pay to do an online exam now.

Placeholder $3.99
Get Best SQL Injection assignment
  • 200+ Downloads
  • 8k Views