Type: Posts; User: antares686
Search took 0.02 seconds.
I have a JPG file embedded in a Web Component DLL written in C#. I am trying to figure out how to render this as an HtmlImage at runtime on th page the component is added to. Looking to render as th...
April 11th, 2006, 04:50 PM
Can you reexplain. You does not start after 24hrs. What are you doing, how big is the database?
April 11th, 2006, 04: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, 04:44 PM
What reporting tool are you talking about first?
April 11th, 2006, 04: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, 04: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.
Another way to do is like so
EXEC test..sp_help 'tt'
Potentially you could but it would be neither pratical and may cause a number of issues when you try to query the data.
Actually should be
SELECT * FROM Patients where ADD_MONTHS(DOB,12*18)>=SYSDATE
Updated deosn't exist.
Updates use both the inserted and deleted names inserted is the entire row as it will look after the update completes. deleted is the snapshot of before.
INNER JOIN means that any data that is matched in the ON clause has to be matched btween both tables. So say one tabl has Bob, Jeb, and Fred and the other has Bill, Bob and Fred and you join on first...
Can you post a snippet of hat code section so I can understand exactly what you are doing?
Yes using a case wrapped by sum will make it work.
select table1.column1, table1.column2, (case table1.column5 when 10 then '10'
when 11 then '11' end) as result, table1.column6, sum(case when...
April 30th, 2005, 09: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, 09: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, 09: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, 09: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, 09: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, 09: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, 01: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, 08:51 AM
INSERT INTO MyTable(ExperimentID, Threshold, Energy) VALUES(@newID, Select Threshold, Energy from OldTable where ExperimentID = @oldID)
December 4th, 2003, 08: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, 07: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, 08: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, 08: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...
Click Here to Expand Forum to Full Width