Hi Friends,
I have a database table called "Person". In the DOB column of that person table, I have the dates in various formats, like "mm-dd-yy", "mm/dd/yy", "mm/dd/yyyy" etc. Now I have to ...
Hi Experts
I've been looking all over the internet and can't find a single example on how to create Pervasive Stored Procedures... Can anyone please give me a useful link/material that give...
I am an excel user and my formula tables are getting a bit too big for excel. I have never used an relational database software but feel pretty comfortable learning to use them. I need to le...
I have set up a SQL 2000 Database with a separate table containing all links I wish to search in a database. The list contains an exhaustive list of links to all press releases, product pages...
We are implementing an application which relies on (admittedly old) Pervasive SQL. It will likely be running on Windows Server 2003. The question I have: what tools are available for monito...
Somehow while installing SQL 2008 I ended up with no sysadmins except for sa, NT Authority.system, NT Service\MSSQLServer and NT Service\SQLServerAgent. Since I did not set it up in mixed mode...
I receive the following error when I try to access a crystal report. Other reports that i have written have no trouble retriving data...
"failed to retrieve data from the database, (micro...
Hi All,
I am extracting data from Oracle database to a flat file. and using the External table i am loading into a Post gres sql database.. this is for the database migration . I am facing ...
Hey there,
I am wanting to know if its possible (and how exactly) I can insert some values into a database from another query and change the values of certain fields,
So if I go
INSERT...
I normally use SQL Server but this project requires me to work for the first time with the Microsoft SQL Server Database File (SqlClient) in VS2008 (.NET 3.5)
This is a single database.mdf ...
I am trying to setup SQL to send, just the changes, in a table from our Production SQL 2005 DB to our Test SQL 2005 DB. The databases are identical as the test DB is just a backup and restore...
Hi guys,
Im using SQL 2005 and wish to do the following but getting an error:
select [Serial number] + ',' + _ResourceGuid as [Altiris] from vasset
where [Status] = 'Active' and [Serial...
I'm trying to filter a recordset that I called using a stored procedure, the stored procedure is a cross tab query, for some reason it fails when I try to applu a routine filter statement on i...
For the life of me I can't remember my password to a database I started about 5 weeks ago. Is there any way to recover that or even change it?
I have a working search page which query's a MySQL database using the following query:
SELECT * FROM main WHERE Name LIKE '%$search%' LIMIT 0, 35
This works fine, but the "Names" are lik...
Hi Everyone,
I'm trying to produce a RSS file with php-mysql.
I also want to save the produced file in my directory.
Can anyone help me ? Do you know any tutorial ?
Regards
Hi i am trying to download mysql 5.1 zip format in the internet, but i got only the .exe format, so please give me the download link to get the mysql db in zip format.
thanks
imp_date = load time
startdtime = when a number is dialed
The following sql returns multiple results since these records are called multiple times.
results_trz has customer info
callt...
Hi.
My question is about Role Based Access Control (RBAC).
I am looking at the image half way down the page here...
http://en.wikipedia.org/wiki/Role-based_access_control
Firstly, wh...
Let's say we have several separate systems working locally with a local database ("the clients"), and a then a separate central database hosted online ("the server").
I want to 'synchronise' ...
I have a intermediary table that I am using to convert data from our old system to our new product/Inventory system. I receive a dump file from the old system and I've placed it into a table ...
