|
Sorry for any in-convenience, J4amieC!
I am catching-up with SQL Server soon.
regards,
George
|
|
|
|
|
|
Good stuff, thanks Hamid!
regards,
George
|
|
|
|
|
I m creating a application it record information per min 4*32 set of record.
So which database i can use. I am planning to MYSQL. is it any other best database is there
Note: I need a mass storage.
Thanks in advance.
|
|
|
|
|
The Oracle can be good selection
but why this mass of record??!!
Human knowledge belongs to the world
|
|
|
|
|
My program like that it store one second 4*32. A machine send that much set of record.
|
|
|
|
|
Do you mean that yo will store 128 records per minute. If so, that isn't so much, but if the amount rises, I think the first bottleneck will be the program storing those records and the possible network between the program and the database. Most of the databases canhandle that amount easily as long as the commands can be delivered to them fast enough.
One consideration is also that do you insert every record separately or can you make insertions as a batch. For example SQL Server client in .Net framework has SqlBulkCopy class which might be useful. Also SqlDataAdapter can handle batches. I'm not sure what's the sitatuation with MySQL client.
|
|
|
|
|
Dear Team,
I have an requirement in windows applications, that i have to execute 3 oracle procedures parllely in an single click event.
is there is any way of doing this. Like
1) using the multi threading concept.
2) can we pass three procedures at a time in commandtext
or any alternative way of doing this or any link related to it.
Thanx in advance .
modified on Tuesday, January 13, 2009 1:48 AM
|
|
|
|
|
You could use threading using BackgroundWorker class. I think that would be the easisest way. You can't pass several commands simultaneously with an OracleCommand.
|
|
|
|
|
thanks a lot mika ..
i will try for it ...
|
|
|
|
|
You're welcome
|
|
|
|
|
HI Mika
i tried to run the procedure using the backgroundworking class. but for time being instead of oracle procedure for testing i have just used simple select statments.
i am just pasting here the code
System.ComponentModel.BackgroundWorker worker = new System.ComponentModel.BackgroundWorker();
private static string ConnectString = "connectionstring";// this is not the actual connection
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
DataSet ds3 = new DataSet();
private void button1_Click(object sender, EventArgs e)
{
worker.DoWork += new System.ComponentModel.DoWorkEventHandler(SomeLongRunningTask);
worker.RunWorkerAsync();
OracleConnection con = new OracleConnection(ConnectString);
OracleCommand command = new OracleCommand(" select * from CIHOLDDETAILS", con);
OracleDataAdapter da = new OracleDataAdapter(command);
da.Fill(ds);
}
// private delegate void DoWorkDelegate();
private void SomeLongRunningTask(object sender, System.ComponentModel.DoWorkEventArgs e)
{
//using (OracleConnection cn = new OracleConnection(ConnectString))
//{
OracleConnection cn = new OracleConnection(ConnectString);
OracleCommand cmd = new OracleCommand(" select * from CIINSPECTIONREPORTS", cn);
OracleDataAdapter orda = new OracleDataAdapter(cmd);
orda.Fill(ds2);
// DoWorkDelegate worker2 = new DoWorkDelegate(loaddata);
//}
}
private void worker_RunWorkerCompleted(object sender, System.ComponentModel.RunWorkerCompletedEventHandler e)
{
loaddata();
}
private void loaddata()
{
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
dt = ds.Tables[0].Copy();
dt2 = ds2.Tables[0].Copy();
ds3.Tables.Add(dt);
ds3.Tables.Add(dt2);
dataGridView1.DataSource = ds3;
}
here RunWorkerCompleted is not firing i have done this code using this link
http://www.knowdotnet.com/articles/backgroundworker.html
please help me whats the problem here.
thanx in advance
modified on Friday, January 16, 2009 4:29 AM
|
|
|
|
|
As far as I can see you haven't wired the event. Try adding the following to the button click before you call RunWorkerAsync :
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
|
|
|
|
|
|
Does anyone know of a good tool to generate database documentation from database schemas and extended properties for SQL Server? I have been looking at DBDesc http://www.dbdesc.com. Any other suggestions?
|
|
|
|
|
|
How do I convert an MsAccess Database into a MySQL Database and is their a free Utility to do so?
|
|
|
|
|
A quick internet search threw up this[^]
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I did exactly this and made the new database follow standards closer then it did in access however I wrote a conversion program without about 10,000 lines of code.
I would think that you could use a utility like this but you might not get the end result that you are looking for.
Humble Programmer
|
|
|
|
|
Hi,
I am having a problem with the below statements
when I give as below I am not getting any records.
declare @list char(100)
set @list = '''wc1'',''wc2'''
select * from iv30300 where trxloctn in (@list)
When I directly give the list I am getting the result.
declare @list char(100)
set @list = '''wc1'',''wc2'''
select * from iv30300 where trxloctn in ('wc1','wc2')
I am working on sql server 2005 version.
I am not able to find out the error.
|
|
|
|
|
AFAIK you cannot use variable to define an in-list with comma separated values. The contents of the variable is interpreted as a single value, not a value list.
Also you wouldn't need the quotation marks inside the string.
For example the following would work:
declare @value1 varchar(100)
declare @value2 varchar(100)
set @value1 = 'wc1'
set @value2 = 'wc2'
select * from iv30300 where trxloctn in (@value1, @value2)
Perhaps you could modify the in-list to a subquery.
|
|
|
|
|
There's an not error, you just can't do it the first way, the in clause doesn't take a variable like that.
|
|
|
|
|
Use XML
DECLARE @CSV XML
SET @CSV = '<key><id>1</id><id>2</id><id>3</id></key>'
SELECT
ParamValues.id.value('.','VARCHAR(100)')
FROM
@CSV.nodes('/key/id') AS ParamValues(id)
Run that and you should get three rows with values 1,2 & 3.
Join that to your query or use in the WHERE clause
Don't forget to parse the XML before presenting it to SQL in case there are any nasties on the input
|
|
|
|
|
Put the values into a table variable and join to it; in our projects we have a udf that parses a comma-separated string and returns a table variable of the data, it's not too hard to make one. Do that and then join to the table variable.
Keep It Simple Stupid! (KISS)
|
|
|
|
|
Hi ,
I need to create a tool to copy SQl server database into a mysql database.Could you please help me to get an idea of this ?.Do I need to use transaction?.How to avoid foreigh key conflicts ?
with warm regards.
|
|
|
|