2007-05-17

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)

2007-05-10

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.

2006-11-25

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

2006-11-18

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/