|
Hi, I currently faced a problem on inserting decimal value from vb .net into SQLCE which declared as money data type. ANyone know how to solve this??
Thanks in advance!
|
|
|
|
|
How can I use DTS to migrate some tables and views from SQL server to a new access database?
I want to be able to do this programmatically, so that the windows application user can create an access database from an existing SQL server.
Thanks,
Martin
|
|
|
|
|
Search for "creating package dts" or see the samples in SQL Server manual. Or google for it. I found this[^] and this.[^]. Is this help?
<italic>Work hard, Work effectively.
|
|
|
|
|
|
Hi,
I was wondering if any one had some ideas or good places to look for help on a alphnumeric counter.
The count I want to put into place is one that starts at 'AAA000' and continues with 'AAA001' and so on. So when the number hits 999, the next record will have a id of 'AAB000'
Please let me know if you have any ideas or a good site to visit.
Thanks.
|
|
|
|
|
Can any body have idea about minimum and maximum values for the following factors for
sql server2000 if i want to monitor sql server2000
Total Memory - KB
SQL Cache Memory - KB
Lock Memory - KB
Optimizer Memory - KB
Connection Memory - KB
Granted WorkSpace Memory - KB
Memory Grants Pending -
Memory Grants Success -
Buffer Hit Ratio -
Page LookUps/Min -
Page Reads/Min -
Page Writes/Min -
Total Pages -
Database Pages -
Free Pages -
Please help me
T.I.A
Shashank
|
|
|
|
|
Hi,
I want to import data to the SQL server from one table to another.
My question is "Should the 2 tables be of same design structure"?
The table to were i need to copy the datas has extra fields.
Pls help
Ram
|
|
|
|
|
If your destination table has extra fields, you can define a constant value, or they need a default value.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Anonymous wrote:
"Should the 2 tables be of same design structure"?
No, you can define the transformation, which field to copy and the desination
field.
<italic>Work hard, Work effectively.
|
|
|
|
|
Does anyone know of a programmatic way of finding which server(s) may be running, so a new client installation can be provided with a drop-down list of where the data may be held? There will be a defined instance in each case, so all servers to be found will be of the form "machinename\myinstance" - I just need to find possible values for 'machinename'. (pretty much like the facility in Enterprise Manager for finding a new server registration).
We are using C# (.NET 2003) but I can translate from other methods if required.
|
|
|
|
|
|
Many thanks Luis. This looks perfect.
And it seems I need to keep up with the times, Google is getting good for this sort of thing.
|
|
|
|
|
You're welcome. I'm glad I could help!
Google is really awesome. I've seen that 95% in less than 2 minutes I find what I'm looking for. And here in CP you can find many articles about almost everything!
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Is there a limit on reading resultsets with thousands of row?????????
|
|
|
|
|
|
Hi Guys & Gals, I am a beginner and used these commands to insert user input from a textbox to MS Access database. Whenever the submit button is clicked, the database Autonumber increases but the "Name" field is blank. Really need help guys. Thanks in advance.
Me.OleDbInsertCommand2.Parameters.Add(New System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarWChar, 50, "Name"))
Me.OleDbInsertCommand2.CommandText = "INSERT INTO Name (Name) VALUES ('" & InputName.Text & "')" <<<<<<<<< declaration of the INSERT command
Me.OleDbInsertCommand2.Connection = Me.OleDbConnection1
.
.
.
.
PrivateSub Submit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit.Click
Try
OleDbConnection1.Open()
OleDbInsertCommand2.ExecuteNonQuery() <<<<<
|
|
|
|
|
Why are you adding a parameter (name) to the command object if you don't intend to use it? Yopur commandtext just concatenates the value into the insert string, which does not reference the parameter.
Things are likely to get pretty confused however, since you have a table named 'name', which contains a column named 'name', and your parameter is called 'name'.
My suspicion is that since the parameter name matches the field name, things are really bolloxed up and the provider endes up looking for the value in the name parameter, but it still has a null value, which is what is used.
I would comment out the parameter addition, and see if that fixes things. I would also consider getting a wee bit more creative with the names, making them different enough so I wouldn't get lost.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
Hello friends!!
I observe that sometimes my queries took 2 0r 3 sec and sometimes it took 1.30 min or 2 mins
that might be problem due to some other user access same table or view??
already i optimised my query but still it took sometimes little bit long time!
if soem other user access the same table then is there any process to lock the table or waiting option ????
please help me out!!!
T.I.A
Shashank
|
|
|
|
|
if another user opens the table for exclusive use before you do, it will be locked until he closes it. IIRC The default locking scheme depends on the version of access in use, and connection string defaults' Some can be modified by the connection string or connection properties see this[^] for more information
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
Hi everyone
Is there a quicker and more efficient way of importing data programmatically from a table in database A into a table in database B using a C# windows application?
At the moment I open the connection to database A and read the data form the table into a dataReader object. Then I open the connection to database B, loop through the datareader and insert the data into the table in database B.
Thanks.
Kobus
|
|
|
|
|
I am writing a C# windows app with a MS Access database.
What I would like is to have a query that will delete a specified number rows from the data table that match a criteria. Note I do not want to delete all the rows that match the criteria justa specified amount.
For example my table contains 50 rows of which 30 match the criteria but I want to delete 15 of them, any 15 will do.
|
|
|
|
|
Delete top 15 * from mytable where...
if there are fewer than 15 will delete them all.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
Hi!
I'm facing an error when i'm testing my program. The error is: If i query, insert ... a big sum of data forward and backward from my SQL Server to my app continuous, a little later, my app can't do any query to SQL Server anymore (even a simplest query string : select * from ...).
I don't know why it is happened? Anyone can help me please! I'm too anxious! I don't want my app just can process with a little data
Thanks!
(I'm sorry if my English is too bad )
|
|
|
|
|
You didn't mention what language your application was written in.
Are you remembering to close your connection to the database when you are finished with it.
If you are using a .NET language such as C# or VB.NET are you callng Dispose on your connection object?
Michael
CP Blog [^] Development Blog [^]
|
|
|
|
|
Yes, i did remember close the connection when i am finished but i don't understand the dispose() you recommended here. When i want to query or insert database, i often code it like this:
conn.open();
comm.ExecuteNonQuery();
conn.close();
Am i missing something ?
My application was written in C#.
Thanks your reply
|
|
|
|