SQL: Bulk import

Bulk import (save file.txt as csv): LOAD DATA INFILE 'file.txt' INTO TABLE 'tblFoo' (col1, col2, col3)

or
BULK LOAD IMPORT ('c:\file.txt') INTO TABLE 'tblFoo' (col1, col2, col3)

SQL Server 2000: make table backup with DTS

• Right-click the table
  • choose Export Data
• Choose a destination
  • Server: "nwdsql" and Database: NELausData
• copy table(s)
• UserXRef"_bkup" (Destination)

Done, then refresh explorer to view.

Install Google Search API Into Visual Studio

• Get the Google API and unzip. Import GoogleSearch.wsdl to the Project root.
• Right-click on the Project root.
  • Add Web Reference
    • Then type in the URL: http://localhost:1574/projectname/GoogleSearch.wsdl or http://foo.com/GoogleSearch.wsdl

Then you should see an App_WebReferences folder in your Project. And then a folder in that called localhost. And then files GoogleSearch.discomap and GoogleSearch.wsdl in that.

Test SQL Injection Attack on ASP

Username: foo
Password: abc' OR 'x' = 'x

Load a Control into Visual Studio

• Right-click on toolbar and "Choose Items"
• Then browse and go to your /Controls/ folder
• Then click on it and open
• Then click "OK"

Then it will be on your toolbar and there will be a Reference to it in your /Bin/