If I have strings with ' and " in them. How can I make sure I can put the string into an SQL query and have the query work?
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10181793.html
Zones:
Visual BasicDate Answered: 07/22/1999 Grade: B Views: 0
This SQL statement works under Delphi and SQL Server Analiser, but it wont work with ASP. Does anyone know why?
strSQL = "SELECT COUNT("Code") as NumRecords FROM Department"
Error :
Microso...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10322671.htm...
Zones:
ASPDate Answered: 04/04/2000 Grade: A Views: 0
I have an Evaluation Copy of SQL Server 7.0 and when I go into the Query Designer of a View and right-click in the Diagram or SQL pane I do not get an option to Change Type. I wish to create a Del...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10640481.html
i have tried numerous combinations but can't find a way to do wildcard queries in sql like i can in access. in access, i would use the term LIKE "*a*" to do the query. could someone tell me what th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11622798.html
In a app I wrote I have an SQL statement that takes an extremely long amount of time to run. I am looking for a way to break out of the query if it takes longer than usual. (The same as if you ar...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20086084.html
Zones:
MS AccessDate Answered: 10/29/2001 Grade: A Views: 0
Hi , i have a number of results i want to display and was wondering the best way. I'm querying 2 values for example
Where currency=EUR and Name=John
Where currency=DEM and Name=John
Where curr...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20223692.html
Zones:
MS AccessDate Answered: 11/19/2001 Grade: B Views: 0
Here is my problem:
I need to fill a dataset, but queries last quite long (about 10 minutes). Returned amount of data is not very large and once the dataset is filled there's no problem but while ...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_20615949.html
Zones:
C#Date Answered: 08/03/2004 Grade: A Views: 0
I'm not much of an SQL type and this one is a bit beyond me....
I have a table of account #s, dates, and payments. Let's say that the columns are named:
account_id, date_rec, amount
I wan...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20631562.html
Zones:
DatabasesDate Answered: 05/31/2003 Grade: A Views: 0
is there a way to set the source of a report to an sql query?
j00lean
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20733455.html
Hi,
I have data in my table like this.
SITE D1 D2
-------------------------------------------------- -----------
A ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20793898.html
