Hi there,
I think that posting the SQL error would help really... so here it is:
27/8: lmsulk: End of illegal lock count dump --------------
--------------------------------------------...
I have a sql server, and in the mssql$hq\backup folder on the HDD it is takigng up much space. There is only 10 gb left on the drive. In that folder are a buch of .bak files that are about 2g...
Select non zero min value over several columns
Ex.
Col 1 Col2 Col3
23 0 6
I would want to select 6
not 0
Thanks
I need to know how to list the index name (and their attribute) on a given table of a SQL databases.
show index? which table name to assign?
thanks
Hi,
I have a list of databases that resides on remote computers. I have access to computername/servername, IP-address and database names for each database. And what I want to do is to connec...
I have two sql servers,
SQLA is SQL 2000 with a database named CLUB containing tables: CustomerFirstName CardID CustomerLastName
SQLB is SQL2005 with a database named HOTEL containing t...
Hi,
How to search ignoring the dot.
SELECT*
FROM Contact
WHERE Phone LIKE '%7842131%' COLLATE French_CI_AI
The result is
021 / 784.21.31
Thanks !
Hello Experts,
I need a select across all columns in the table for a special term.
Example:
SELECT * from Table_Data where * like '%QS%'
So, this does not work, I know but what is the ...
Hell programming Gods I have a new one for you guys that should be a cakewalk for you but I'm a noobie so its kicking my butt. I need to update a sql table cell with another field inside the s...
I am still in my first few months of SQL Programming and I have learned alot so far. Can anyone recommend a great software product or video(s) to watch to help me learn more? I currently use R...
How can I connect to Pervasive SQL from windows Excel; what drivers do I need, I am looking for ODBC drivers but Pervasive website says it is provided with original sofware, Is there any place...
I received the following solution:
if Request.Form("Plant") = "P100" AND InStr(Request.Form("Project"), "Sustaining") > 0 Then
....
End If
Now what I need is:
if Request.Form("Plant")...
I have an app that connects to SQLBase via OLEDB. I am finding that some clients machines have the provider name as 'SQLBaseOLEDB' and others have it as 'SQLBaseOLEDB.1'. What is the differe...
I wasn't sure what software to select. I'm using Teradata SQL Assistant and trying to build a new column based on values from two other columns. I'm trying the case statement below but getti...
I am preparing to install MS CRM for SBS. How do I create a SQL instance for CRM?
The CRM installation aborts because the 'SQL server does not exist or access denied'.
Thanks in advance.
I am generating ASP pages using Recrystallize but in order to be viewed on the web server the original report's data source has to be changed. The data source is Microsoft Access and from the ...
The SQLBase 9.0 Tutorial 2 for ASP.NET sample, says to add the reference to the "Gupta SQLBase .Net Data Provider", I don't have this showing in my "registered references". I can browse to th...
Hi Experts,
I've SQLBase Db but lost my db password.How to recover password?
I hope I can explain this so it makes sense.
I'm using a SQL DB that has two tables that track the application of A/R activity (Payments, Credits, Charges, refunds, invoices, etc.). Table ...
Hi,
I have two tables like sample_1 and sample_2. Below are the structure of both the tables.
Sample_1 Sample_2
ID ...
Hi,
I've made a C# program to do some database editing on a SQLBase database. If the database is online then the connection succeeds, not surprisingly. But if the database is offline the co...
I have SQLBase Version 8.5.0-PTF4. On attempting to make an ODBC connection via MDAC/VBScript I get an error 80004005 on the first sql statement and all attempty to correct this have so far fa...
I have 2 tables one has the Last Name Deffner in its columns and the other has Deffner JR in its columns. How can I make a table Join from Deffner to Deffner JR?
