April 11th, 2006 03:50 PM
Can you reexplain. You does not start after 24hrs. What are you doing, how big is the database?
April 11th, 2006 03:45 PM
Can you explain more. Do you mean you want to store a file or you want to create a data object in SQL from a stored set?
April 11th, 2006 03:44 PM
What reporting tool are you talking about first?
April 11th, 2006 03:43 PM
Try creating a variable setting the vairbale equal to your string and passing in the variable to the execute. Have seen builing a string throw issues before.
strSQL = "EXEC...
April 11th, 2006 03:38 PM
I have installed SQL 2000 on 2K Pro but I believe it was Developer Edition of SQL not others. Unfortunately I no longer use Win 2K Pro.
April 30th, 2005 08:21 PM
I assume you store the password encrypted in the database from your question. As long as you are using the same encryption method and keys then doing a straight copy thru code should do the trick....
April 30th, 2005 08:19 PM
1) My understanding is the Oracl client is not free it has to be licensed with your server (cal).
2) Don't know sorry.
3) Refer to 1.
April 30th, 2005 08:17 PM
Read this from SQL BOL and try to chang from using timestamp to rowversion so when they change the funtion in the future it will not impact you.
April 30th, 2005 08:14 PM
First what database are you using and can you describe the individual tables and what fields you will bring back from each?
April 30th, 2005 08:11 PM
Or if you prefer that if either condition is met as opposed to both use
SELECT G, H
WHERE F IS NOT NULL OR A = 10
April 30th, 2005 08:09 PM
First off let's see what yo are after. Can you post an example of the table data and what yu expect the results to be. Also, you are using the older ansi join syntax method which most databases have...
March 18th, 2005 12:32 PM
First off names of tables should be plural no matter what else you do with them as they represent more than one object.
But as for your question it depends on the type of database system you are...
December 4th, 2003 07:51 AM
INSERT INTO MyTable(ExperimentID, Threshold, Energy) VALUES(@newID, Select Threshold, Energy from OldTable where ExperimentID = @oldID)
December 4th, 2003 07:43 AM
Are all the records primary key 6 in length and if not do you pad in the other table? Also what is the error you are getting?
December 4th, 2003 06:55 AM
Are your data sources on the same server or coming from various locations. If the same then create a view on the server and save soem time and the temp table resource can be eliminated.
December 3rd, 2003 07:08 AM
SQL sorting does use memory and tempdb space to sort the data. Just happens on the server and SQL may already have the memory allocated. Large disconnected recordsets are not usually a good idea...
December 3rd, 2003 07:06 AM
You can only
use the concatinated method as long as the submitted data length will not exceed 8000 bytes (char/varchar type limit).
If this is for inserts only then use ADO to create your...