Im new to Sysbase and Im working on a stored procedure that I need to commit on blocks of 1000 rows. Is there any parameter that I can set for example <BlockCommit=1000> ? if not, Is there any better solution than using a cursor?Any help will be appreciated.Thank you.PS.: Im using HP-UX...

If we open an updateable ADO recordet with adUseClient cursor location, then commercial OLE DB providers for Oracle add hidden ROWID column as primary key so that ADO cursor engine knows which rows to modify. I want to know if these is any freely available provider with source code that does the sam...

I have been looking for the installed size of SQL 2005 Express and I am referring to the size of SQL 2005 express after it is installed. I haven't seen any reference to that in the MS documentation, I have seen the amount of HD space requied for during the installation process but I need the In...

i just passed all my oracle exams using *********.com guides . they were right on money and had questions which were very close to real exams . Highly recommended . now iam off to start working on cisco track

Using SQL Server 2000 here and I have a table named "Calendar" that is an auxillary table created using scripts found on the web. Basically, the calendar contains an entry for every day for the next several years that has a datetime field, fields for the day of the month, month of the year, the year...

i am little doubtful about how the commit to savepoint works....suppose if i have code like this statements......savepoint astatemets .......savepoint b statements.......now if i want to commit to savepoint B...then the code before savepoint will be commited or code after savepoint B will be commite...

I have created a SDI app w/ MFC in VC++ 2005, that has database support and connects to a MS Access Database. The problem that I am having, is that I see automatically that it just sets up to allow you to sequentially move through them. I know how to disable these controls, but what I would like...

Hi everybodyI want to execute a script, which checks, if a table in my DB exists. If not, the table should be created. The script looks like the following:#!/bin/bash#$1 : username#$2 : password#$3 : sql script#$4 : path to the sql script#$5 : the user to start sqlplus with#$6 : the installation pat...

I need to store two float values (and something else) in a records of some table (MS Access database). And then query them by another application.There is two choices:1) store in two float (single) type fields2) store in one double type field (and then split it on two float values in querying applic...

Dear dev-archiveCan you suggest if I can create a single view of two different databases (may be one in Oracle and the other in SQL Server 2000, or, both in Oracle, or, bothe in SQL Server 2000)?Please provide the way, if it is possible at allThanks and regardsShouvik...

I have a database looking like this:Employee ((name), salary, boss, department)Sales((floor, productnr), volume)Supplier((company), address)Varehouse((company, department, productnr), volume)Department((department), floor)Product((productnr), thing)I want to get the following :*What bosses have more...

Dear Sir,Hello I am a learner watching your profile led me to this that u would kindly resolve my problem asap.It goes like: "The changes u requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or...

Hi all, I want to update a column with another col in a SP. LikeUpdate table_field1 = table_field1+ table2_fieldAll the fields for updating are already selected in the Select statement above this code in SP. But it just says syntax error and does NOT seem to recognize this table2_field s...

HiI am using SQL Server 2000. Is there a way to concatenate data from two columns into one value in the SELECT statement? If I use the following SELECT statement:SELECT TableIndex, Col2, Col3FROM TableWHERE TableIndex = 1It will give:1 8 aI would like it to give the following:1 8aThanks.Kobus...

Hi together,i'm using ADO from C++ to retrieve data recordsets from an SQLServer 2K database. Extracting a character string from a VARIANT is very slow in my opinions.I'm using following code:m_bstr = (_bstr_t) m_DbValue;int len = WideCharToMultiByte (CP_ACP, 0, sptr1, -1, (char*) ptr, bin...

hi all,i am trying to write a trigger for delete. it will insert data to another table now im getting every column with variable could i use like thiscreate trigger insertdata on tableA for deleteasdeclare @num int,@typ nchar(3) //select @num = number, @typ = type from deleted //insert into tableB(n...

i've got two tables[news] --< [comments] (this is relation one to many... - every news can have many comments) i need to get from one query:all the news columns + comments counti've tried something like this:SELECT ..., COUNT ( SELECT * FROM comm...

Hello everybody! Im using MySQL as my database.I have a problem on how to get the top 20 salesman per distributor regarding their sales.My table look like this....----Distributor table----distibutor_id distibutor_name 1 FDS Marketing 2...

Hello! Is there anyone know how to transfer the data from MSQL to MS-Access.<br/>Thanks a Lot!

My table access have 4 columns:accessid - (which is autoincremented)userid - (unique id number of each user)access_time - (unix timestamp form)ip - (ip adresse)----------------Each time user login, his time and ip is recorded.Now what I would like to do is find physical user that have more than one...

I'm developing an intranet system for a small company. The amount of users will within 30. Because they haven't any db administrators, I'm considering to choose Acess 2000 as their db server. But, I'm not sure that the ASP+Access architecture whether has any problems, such as s...

Friends, My requirement is to retrieve data from table in a hierarchical order like a tree. Structure of table is given below. Key Description Parent------------------ 1 Item 1 0 2 Item 2 1...

Hello,I am trying to accomplish the following goal in a stored procedure in SQL Server 2005:"For any given node in an xml variable, return via recordset a list of attributes."Take the following query:DECLARE @x xmlSET @x = '<Item> <Data Key="ID" Value="1001" /> <Data Key=...

Wat is the basic difference between a Union and a Join??<br/>Rgds,<br/>Chandru

In a non-unicode program, by using CRecordSet (MFC) I could enter and retreive cyrillic letters. If I include these letters in sql statements (e.g. in an insert statement), either in QueryAnalizer or from ODBC they reach the server distorted. "Regional and Language options/Language for non-Unicod...

We are experiencing slow installations of SQL 2005 Express such as taking an hour or more to install and all pereqs are already installed. We have spoken to MS about this and it is suppose to do with security checking on networks and that there is a patch. Well the patch doesn't appear to work...

let say i have one query SELECT [id]FROM table1and have 2nd querySELECT [Desc]FROM table2WHERE [ID] IN (SELECT [id] FROM Table1)i want to replace the bold part since it's basically from 1st query so if i want to change, just change from 1st querySELECT [Desc]FROM table2WHERE [ID] IN (EXEC 1stqu...

Dear all i had one question would like to ask someone who can give me a litter help if my database data like it traceno otherno username0913377594 0913377594 roger0913787170 0913787170 roger0915534569 0915534569 roger0925306029 0925306029 roger0930443931 0930443931 ro...

I need to store a tree to database and get it back. What is the optimal way to do this? Number of nesting levels must be >2.Currently I use table with int32 type as primary key. First three bytes represents nodes of three levels and last byte represents an object. So I can have up to 255 objects(...

I am trying to backup my databases using T-SQL to a snapserver. However when I use the following BACKUP DATABASE ca001 TO DISK = '\\snapaztar\sqlbackups\Great Plains'I get a device error or device offline. I have checked an I can access the snapserver through the unc path specified....

Hi,<br/>I am using Sql Server 2005 and I need to know from C# all databases in a specific instance of Sql Server.<br/>I imagine it should be in a system table, but I can't find it<br/>How could I do that?

Hey,Im creating a website which I want to have a search feature. Im building the page using asp.net c#. I am using a mysql db. Every table in the db has the same structure.On my page I have a text box and a button, when the button is pressed i want it to search the db and display related results in...

i have some problem regarding SEQ..i.e. Sequence database just like relational database..in relational database we konw three model will help entity relational model,relatonal model,object oriented data model...but i don't got similar information regarding SEQ. can u help me....pleaseSEQUIN -...

I'm currently porting our monitor application as an OCX (via C++). The initial feedback has been positive but the users want historic data to be selectable. However the data is stored in an Access 2000 database (though the next revision of the program will be SQL Server).Now my boss wants me...

I'm having trouble coming up with a query in SQL Server 2000, and I think using an expand and collapse technique i've read about might work but at the moment I don't have the reference with me and I can't remember how to apply it. I could be wrong on the technique though so any s...

hi all,<br/>we are trying to convert a mssql project to mysql . how can we convert this code ? <br/>Convert(NVarChar, mycolumn)<br/>thanks to all :)

I am running a query which has an index on 3 fields (storeID, Date, TransactionID). My problem is with the date, I think the query doesn't use the index because at the top I have a variable for Date, and use Convert(varchar,DateAdd(day,-1,getDate()),101) to get yesterday's date and remove...

I am looking for suggestions for creating a database, based on the following Criteria:1) use C++, not a managed language2) simple database that will be used for one person to save records that will have a number of fields, one field that can hold paragraphs of text.As a newbie to C++, and database p...

dear all how can i create view within declare ?if i had one script contains declare if it is possible to combine both table with union ?declare @a varchar(20)select @a = ptraceno from phonelevel where(ptraceno = '0913787170' or otherno = '0913787170')select * from phonelevel wher...

Hi,I have a problem with an Access Database. I am running some SELECT queries in a loop (from my Visual C++ app) but the problem is that after a while the queries start to slow down considerably, up to the point where it takes 20-30 seconds to execute a query that returns about 20 results. I am conn...

recurring instances of the same value in a list?<br/>In other words I need to create a list (a query) that contains all values of a certain field, each value listed just once.<br/>Thanks.

Suppose we have one table, addresses, that has an address ID and a type and our system has suppliers, customers, banks etc - all entities that can have addresses. We re-use the addresses table, no problem.. Suppose supplier, customer and bank all have an ID of their own, and its the same type as add...

Hello, everybody,I am in need of storing long pieces of text in database, length between 2000 and 4000 characters (nvarchar limit).If I have a column in a table:my_text nvarchar(2000)does this mean that in database the size used will always be 2000*2=4000 bytes at least (+ rounding), independent on...

Hi,I am working with a table that has over 1.5 million records. I am writing an application that reads from this table and does a bunch of stuff with the records. What I want to do is take a subset of the table (the first 5000 records) and insert these records into a new table.Is this possible? How...

Hi Everyone,<br/>Iam using MS-ACCESS database.<br/>I have given my primarykey as auto number.<br/>so in my code when i use Insert statement how to give that autogenerated number in insert statement.<br/>thanks<br/>k

Hello guys, im using MySQL and using 16 views to generate my crystal report. My problem is, when i generate my report it takes 1 and a half hour just to view the first page. Is there anyone know how to make it fast. Im very frustrating generating it...<br/>Thanks a lot!!!!

Hello friendsi have this problem in asp because of the sql statementi want to retrive data from database acording to the cookies nothe cookie name is record bu i do not know how to put the cookie within sql sataement can i do the sataement like this ?select mees, e_name from imp_loc where loc_me...

I'm using MySQL(5.0.24) with PHP.<br/>I would like to calucalte size of of my DB for 300 000 user.<br/>How should I do that, what is a procedure for calculating it?<br/>Thanks!

In the past I used SQL SERVER 2000, and there were 2 very important tools: Enterprise Manager, and query analyzer (among many others). But after installing SQL Server 2005 Developer Edition I figured out, that only these options are available: Configuration Manager Error & usage reporting Surface a...

Hello everybody<br/>I program in C# language.<br/>How to backup/restore database named "myDB" of SQL Server 2000/2005.<br/>If possible please give full code.<br/>By by and thaks