Search:

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...

Can you reexplain. You does not start after 24hrs. What are you doing, how big is the database?

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?

What reporting tool are you talking about first?

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.

Dim strSQL

strSQL = "EXEC...

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...

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....

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.

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.
...

First what database are you using and can you describe the individual tables and what fields you will bring back from each?

Or if you prefer that if either condition is met as opposed to both use

SELECT G, H
FROM Score_BD
WHERE F IS NOT NULL OR A = 10

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...

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...

CREATE MyProcedure
@newID int,
@oldID int
AS

INSERT INTO MyTable(ExperimentID, Threshold, Energy) VALUES(@newID, Select Threshold, Energy from OldTable where ExperimentID = @oldID)

The key...

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?

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.

If remote...

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...

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...