All articles with keyword "SQL"
Accessing SQL Server Through an ASP Page
At some of my client sites, the SQL Enterprise Manager TCP/IP port (typically 1203) is blocked by a firewall. Since getting a firewall port opened nearly requir...
Click for more...
Building SQL Statements
If you are building SQL statements within your ASP code that have data that might have single quote characters in it, be sure to replace every single quote with...
If you are building SQL statements within your VB code that have data that might have single quote characters in it, be sure to replace every single quote with ...
Don't Use Reserved Words
A reader recently passed on a reminder to the rest of you to not use reserved words. While we know this in VB since VB will generally catch that type of syntax ...
Limiting Search Results
If you have a query that you know will return a lot of records, you can use the SQL TOP keyword to limit the number of records that are returned. I will often d...
Searching for Apostrophes
This question comes up a lot: how to search for a name like O'Brien from within SQL. The problem is that the single quote character is used to delimit strings w...