Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
exists SQL keyword
Name: Jim Date: November 19, 2002 at 06:01:49 Pacific OS: Win2K CPU/Ram: 1GB
Comment:
I'm trying to write a SQL command to drop a table if that table exists. I can't seem to come up with the correct syntax but think I need to use the exists keyword. Please help!
Summary: sql = "SELECT * FROM customers WHERE customersname LIKE '%Pre%'" (it is a good practice to write the SQL keywords in capital letters to distinguish them easily) % works as a wildcard just like the * ...
Summary: Does anyone know what the "top" keyword is for SQL when using Oracle? For example - it is generating 2 rows for the result to my query, and I want it to only display the top row. I think the word is ...
Summary: This is a better way to check: Dim RS As ADODB.RecordSet Dim CN As ADODB.Conenction Dim SQL As String Dim ErrorString As String ErrorString = "" Set RS = CreateObject("ADODB.RecordSet") Set CN = Creat...
