Hello MySQL/Database experts, I'm working on an application that uses MySQL as its storage engine. I'm SELECTing and INSERTing blob fields into the database. EDIT: I'm using CDatabase/CRecordSet with the 3.51 ODBC driver.Right now I'm using MyISAM tables, and my INSERT performanc...

let say i have this value in my Table1Table1 = Date + EnteredNumber1/Dec/2006 | 23/Dec/2006 | 15/Dec/2006 | 37/Dec/2006 | 28/Dec/2006 | 29/Dec/2006 | 510/Dec/2006 | 1i want to display the Number per day for 1 week range starting from 1/Dec/2006 where First Day Of the Week is Sundayi'm able do t...

Hi,How can I use a stored procedure to reschedule a job in SQL Server 2000?[Edited to using a product that exists!]I am using SQL Server 2000. I have a stored procedure that I call from a scheduled job. The stored procedure depends on several data updates being completed. Here is the example.Job:...

I have a query that basically looks like thisselect campus, labhours / 2 + lecturehours as creditsfrom tableswhere conditionsgroup by campusThe table that stores lecture and lab hours for each class stores the kind of hours and numbers of hours so there's are generally 2 records for classes wit...

"ORA-00903 : the table not found " is returned while accessing oracle database through ADO recordset .my code looks like this : // strSql is set as _T("select * from GDTEL_GROUP ") in advance ; // m_pConnection has been Open sucessfully in advance . // m_pConnection has the same privilege which...

Hi !I'm new to this particular forum and i hope that this is the right place to ask:I have an email list. is there a way to send a message through an sql query to the whole list ?I have 1000 email addresses for examlple which i can display using a SQL query, can i send them all a message using...

CREATE OR REPLACE PROCEDURE GD_ENT_BPMS.TESTPROC ispGroupId varchar2(20) ; pResult varchar( 1024 ) output; // store the result need to return to caller. BEGIN select * from gdtel_group where GROUPID= pGroupId into pResult; END;The procedure written by me is wrong .My intention...

how to rename a column name of a table through sql command<br/>e.g column name is UserName and its changed to Name<br/>plz tell me

HelloI have a problem with a query for a MS Access Database (2000), hopefully someone can help me with solving it.What I want to do i fairly simple. I want to create a query for a report, based on the information that is entered into a form. Basically your average search form.In the query I have a I...

i am very new to extended stoared procedure.<br/>i want it to use to send multiple records to sp at once <br/>can any one Explain me what is the exact excution sequance of CLRSP<br/>is this method useful for my task <br/>Plz Help me. <br/>Its urgent.

Any one knows where i can download it ?<br/>Is it compatible with msde 2000. Tables under MSDE can be transferred to MSDE 2005 ?<br/>Thanks a lot !

Hi all, I want to know whether my task can be accomplished using SQL Queries if not what are the other way I can do it.. My existing system is now retrieving all the records from various tables, and now I need to modify the existing query to retrieve the values as mentioned below(Result Record Set...

how to list the data-structure (table_structure ) of a talbe ?<br/>there are several application listed in the folder in program-files,which one can do that ? thanks ?<br/>not so difficult.

Hi,<br/>My problem is that i want to create triggers on table located in different databases. Can any one help me out , "how to create a trigger from on database on to the tables in different databases.. " .If any doubt plz write back to me.

Hi,Can anyone please form a regualr expression pattern for the following..a) 2345 To 5432 - I want to search for all the numbers between 2345 and 5432 For example it should give me 4567 as a result if present.b)2345 To 5432 - 123* - I want to search for all numbers starting from 2345 and b...

Hi, i had been some a problem with the delete statement. When i try to delete X rows of a table in a transaction, it doesnt work properly, some rows arent deleted. Im working with one thread and concurrency.I tried before delete the same information with stored procedure and the same problem happene...

My database is using SQL Server 2005 Express Edition and located in the office. I would like to know if it's possible for me to connect the office database directly from home so that i can do programming at home.<br/>Thank you.

Hi !<br/>A joint of 2 tables looks like:<br/>select *<br/>from<br/>t1 a join t2 b<br/>on t1.col1=t2.col1<br/> <br/>Trouble is i dont know how to make a joint on 2 columns. (col1+col2).<br/>Could anyone help me with that please ?<br/>Thanks !

Hi !One of my tables lacks information that another table contains, telephone number for example.I'd like to update the column "Telephone" of table b wherby table a.in the code:select a.telephoneb.telephonefromt1 as a full join t2 as bona.id=b.id whenever t2 has an empty cell it should be updat...

Hello,I have in a network 2 databases. One holds all the data and the other (SQL 2005 Express) holds only an part of the data. But this local database holds also the newest data which is til now not in the remote database. What is the best way to send this data to the other database? on the local si...

Hi !I'm searching a select statement to show my table in groups.Id like to show all members living in city: "a" and at the end of the list a number showing how many living in "A".Then city "B" ..and at the end the total of members.i wrote:selectlastname,city,count(city)frommytablegroup by city...

I tired installing SQL server 2005 express in one pc n I got an error. Here is the log file--Installing using command line '"C:\DOCUME~1\Ken\LOCALS~1\Temp\VSD3A.tmp\SqlExpress\sqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=someinstance SQLAUTOSTART=1 SECURITY...

I would like to know if it's possible to use one query to do insertion after checking there are no duplicate record ? If same record found, it will give up the insertion automatically?<br/>Thank you

is it integer ? I assumed that it is integer but the code below can't work as my expectation.therefor I suspect that it doesn't correspond to integer in VB or c++,but what type of it exactly ? thanks . _ParameterPtr parGroupId ; _variant_t varGroupId ; _CommandPtr cmmd; HRESULT hr = cmm...

using vc++ from vs2005, using ADO, would like to openan ms access db using the fully qualified path and name of the .mdb file instead of using an ODBC alias.attempts to feed the file path to the connection string all fail.is this doable? if so would appreciate a sample connection string.thanks - j...

i can do all the basic ops to an ms access table that has records in itthrough a vc7.0 gui interface (add, delete, save etc).adding a record to such a table basicaly isrecordsetptr->MoveLast();recordsetptr->AddNew(AddRecord);loop thru rec fields change values recordsetptr-Update(.,.);runn...

is it possible for stored procedure of oracle to declare or even return a large string whose length exceed 32767 ? Thanks. CREATE OR REPLACE PROCEDURE TESTPROC (strID in varchar2 , TestRet OUT pls_integer) isstrTemp varchar2 (32767) ; strTemp2 character (32767 ) ; // the variable is limitted withi...

problem has been resolved .

how ? is it hard to implement that ? if it was really hard I would try aother way .

Hallo!I am using a ACCESS datebase and try to create a table with an unique autoincrement column. I habe found many examples for SQLServer, but nor for ACCESS. Does any knows?CREATE TABLE myTable (ID integer default autoincrement primary key, name varchar(30))Does only works in SQLServer.Please... h...

I have two tables that I'm accessing in order to do an insertPerson - PersonId uniqueidentifier - LastName varchar(50) - FirstName varchar(50)...andUserAccounts - PersonId uniqueidentifier - Username varchar(50) - Password varchar(50)I have some code that tries to insert a record in...

How to find the tables that uses the specific column name in the database (oracle 9i)?

We have upgraded our application from Berkeley DB sleepycat version3.3.11 to Berkeley DB sleepycat version 4.5.20.Following are the changes in Berkeley DB 4.5 release:The log file format changed in the Berkeley DB 4.5 release. No databaseformats changed in the Berkeley DB 4.5 release.So can anyone t...

dear all i would like to ask someone who has that exprience to use PATINDEX in mssql ? if i want to use this function in microsoft access for that script , which can i use it to instead PATINDEX into access some example MSSQLGOSELECT DocumentID, PATINDEX('%reflector%', Title)AS POSITIONFR...

hi,<br/> I want to maintain all user details in single database. anybody tel me the answer.<br/> bY<br/>anitha

Hello,I need help figuring out how to write a query for the following condition. Any help will be appreciated. Here's the example:Table1Table1ID, FruitT11, AppleT12, BananaT13, PeachTable2Table1ID, ColorT11, RedT12 GreenT11, YellowT13, OrangeT12, YellowHow do I write a query in MS SQL as foll...

Hi.I want to change the parameter of one field in my products table. The product's owner is currently listed as "master," and I want to change it to "Susan." I'm not sure what type of query I should use: SELECT, ALTER TABLE, CHANGE...?I've come up with this skeleton:SELECT ,master, fr...

Hi DB Gurus,I am using SQL server 2000 and VB6 for my project. In its one module I have to import a raw data from a text file having row terminator = \n and field terminator = TAB. I am using following SQL to import data.BULK INSERT billing_master.dbo.test FROM 'c:\abc.dat'...

I would like to know how to copy the database files (mdf) of SQL Server 2005 Express to SQL Server 2000.<br/>Thank you

I have a table in Oracle that lists a material, a date, and the inventory amount on that date. I want to create a query that brings back a list of materials where inventory has increased a certain percentage, lets say 100%, across two different dates, like yesterday and today. I'm using a thi...

Hi, I would like to create some queries (actually, preferrably views) in ms sql server that allow for user input. The reason why I want this, is because I am trying to generate some reports about my data using excel (for example periodical reports, in which case I would have to give the queries a st...

I'm using MDX to query a database and I have a list of value I want to exclude. This would be similar to SQL equivilent of <> (not equal to) or not like. Can someone show me an example of how to syntax an exclusion? Here is a query sample showing some values I want to include:SELECT [M...

I want to collect a huge string from a bunch of query result then send it to the client .<br/>use varchar2 can't suit my diamond ,the length of it is limitted within 32 * 1024 bytes. <br/>just offer me the rough direction , I would figure out the remaining <br/>thanks.

Hi there,Hopefully someone out there can give me a hand even though my description of problem is quite vague.I am modifying a form in Access 2003 which has counts based on the number of items in each of 2 list boxes. These (invisible) list boxes each contain a subset of the data contained in a visi...

Here I am again with another question related to producing reports in Excel by querying a ms sql database. The answer to my previous question was satisfying (thx Krzemo), so I hope that will also be the case for this next question ;-)I retrieve some information from the database by running a stored...

Hello,<br/>Can anybody tell me of a good website that provides information about oracle consulting? <br/>Someone recommended www.oracleplace.com. Any recommendations on this?<br/>karen

Hey There,I just created a simple form in Access, that stores a list of items of some sort...something i needed to do for my work office...Anyway, I want to add a button to the form, that upon clicking, will export a Report of the list of items in storage (or some other kind of query) to a Word Docu...

Hi everyone. I have installed postgreSQL version 8.1. I have created a table using the pgAdmin program under windows. The table is named Users. After that I use jsp and a bean in order to access the table. In the bean the code that does a simple sql query is: String SQuery = "select * from Use...

Hi all, I want to get the result from sql query which fetch data case sensatively i.e.The Queries -1. select * from data where name = "Nancy"2. 1. select * from data where name = "NANCY"Both queries are fetching same data but i want the data seprately. means 'Nancy' should not fetch "NANC...

Greetings database gurus!I created a register that keeps track of drawings that are issued to subcontractors. Here are my table relationships: http://www.mnd.co.uk/mike/drawing-reg-relations.gif I even got my beloved drawing register to create the following report (1 page of about 8): http://www.mnd.c...