how to view image data

I have an image column in my table in my SQL 2000 database.
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:
> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
> > I have an image column in my table in my SQL 2000 database.
> >
> > I have inserted a row with binary data for the column.
> >
> > Is there a simple way I kind view the data with Enterprise Manager?
> >
> > This is so that I can check that my C++ code that inserted the data is
> > working?
> The ability to view as an image is up to the client application, and EM does
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
> John|||Hi Neil
"neilsolent" wrote:
> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable
> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappchunk.asp
an
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkxvc.asp
John

how to view image data

I have an image column in my table in my SQL 2000 database.
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:

> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/databas...filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
>
> The ability to view as an image is up to the client application, and EM do
es
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/databas...filesystem.html
> John|||Hi Neil
"neilsolent" wrote:

> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable

> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/d.../>
ppchunk.asp
and
http://msdn.microsoft.com/library/d...endchunkxvc.asp
John

How to view field list on the left side of report layout

I want to see all the fields list on the left side of report layout, you can drag a field and put it on the report.

Thank you very much.

Should be available under View - Fields.|||

From the View menu, click 'Datasets' and it will open the box for it. Then you can dock it to the left side of your screen and navigate through your dataset to your fields.

Hope this helps.

Jarret

|||

But under View i don't see Fields item at all, i know i did it in the past. but forgot the steps to get the field list.

Andrew, thank you.

|||Excellent - Thank you Jarret.|||

No problem, glad I could help. Can you mark this one as answered so others can see this solution?

Jarret

How to view error messages

SQL2000.
If somebody needs to view the error logs, do they need sysadmin
rights or can this be performed with another system role?
TIA.There is an undocumented command sp_Readerrorlog which allows you to read
error log through query analyzer but it requires the user to be member of
the securityadmin role.
--
-Vishal
"Stressed" <k@.c.co.uk> wrote in message
news:OHR2dyKQDHA.3192@.tk2msftngp13.phx.gbl...
> SQL2000.
> If somebody needs to view the error logs, do they need sysadmin
> rights or can this be performed with another system role?
> TIA.
>

how to view date dimenstion

plese help
I want to view date dimentions like DD/MM/YY, doen't want to include time.
Thank youSELECT Convert(varchar(10), GetDate(), 105) as date

For more option explore convert() function...sql

how to view data whilst in an uncompleted transaction, from outside the transaction?

Hi everyone, I was hioping to obtain some help with viewing sql data
whilst within a transaction, from OUTSIDE the transaction itself.
For example, if i do the following steps:
1)
-- Do this in Query Analyzer session 1 window
-- Note: there is no commit transaction below
begin transaction
use northwind
update customers
set postalcode = 2000
where customerid = 'BLONP'
2)
-- Do this in Query Analyzer session 2 window
-- This is where I want to view the modified data
-- prior to commiting the transaction
use northwind
select postalcode from customers
where customerid = 'BLONP'
3)
-- Do this in Query Analyzer session 1 window
-- Here I commit the transaction after reviewing
-- (via step 2) that the update statement is
-- producing the results that I want
commit transaction
The problem is that performing step 2 does not work as the transaction
in step 1 is obviously locking the customers table. I have looked into
setting isolation levels, but this doesn't seem to be working. The only
result that I am getting back from step 1 is that one row has been
modified. This is an obvious help as I know that not all rows have been
affected by my update, but tells me very little.
The reason I want to be able to do the 1-2-3 step oricess is sometimes
I need to do a complex update, and wish to review the results of my
update prior to commiting. I don't want to rely on updating "test" data
alone as a gauge to the correctness of my update statement.
Any help on this would be great!
cheers,
peterCan you not just do this all in one query window:?
Start Transaction
Issue modification statements
perform queries to validate the changes
Committ or rollback as desired
<mag1kus@.yahoo.com> wrote in message
news:1143076873.038566.151900@.j33g2000cwa.googlegroups.com...
> Hi everyone, I was hioping to obtain some help with viewing sql data
> whilst within a transaction, from OUTSIDE the transaction itself.
> For example, if i do the following steps:
> 1)
> -- Do this in Query Analyzer session 1 window
> -- Note: there is no commit transaction below
> begin transaction
> use northwind
> update customers
> set postalcode = 2000
> where customerid = 'BLONP'
> 2)
> -- Do this in Query Analyzer session 2 window
> -- This is where I want to view the modified data
> -- prior to commiting the transaction
> use northwind
> select postalcode from customers
> where customerid = 'BLONP'
> 3)
> -- Do this in Query Analyzer session 1 window
> -- Here I commit the transaction after reviewing
> -- (via step 2) that the update statement is
> -- producing the results that I want
> commit transaction
>
> The problem is that performing step 2 does not work as the transaction
> in step 1 is obviously locking the customers table. I have looked into
> setting isolation levels, but this doesn't seem to be working. The only
> result that I am getting back from step 1 is that one row has been
> modified. This is an obvious help as I know that not all rows have been
> affected by my update, but tells me very little.
> The reason I want to be able to do the 1-2-3 step oricess is sometimes
> I need to do a complex update, and wish to review the results of my
> update prior to commiting. I don't want to rely on updating "test" data
> alone as a gauge to the correctness of my update statement.
> Any help on this would be great!
> cheers,
> peter
>

How to view Cube in WEB Browser(IE) like Pivot tables of Excel

hi,Please! Help me.How to view Cube in WEB Browser(IE) like Pivot tables of Excel.
Your help is highly appreciated.

You can use the Save As Web page functionality from Excel and publish the web page on your web server.

You can also embed OWC Pivot table within your html page, setup appropriate connections to your cube to get the functionality.

--Siva

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks, Siva.But How to write code to call cube which i designed with sql server 2005 Analysis Services.Thanks in advanceSatyananda|||

Enclosed is the reply I got from the OWC team. Let me know if this is what you are looking for.

OWC can connect to AS 2005 using the connection string property and either the data member or command text properties.

PivotTable.ConnectionString = “PROVIDER=MSOLAP;Data Source=[Valid Server Name];INITIAL CATALOG=[Valid AS Database Name];”

PivotTable.DataMember = “[Valid Cube Name]”

‘’ Or

‘’ PivotTable.CommandText = “[Valid MDX Statement that OWC can process]”

Notes:

1. There are some limitations to the MDX that can be executed by the OWC PivotTable object. OWC tries to parse the MDX to determine what belongs on what axis. If OWC can not determine what belongs on what axis, it will fail processing the MDX. However OWC has a pretty extensive object model that can be used to build the desired PivotTable.

2. OWC Controls are not “Web Controls” as defined by ASP.NET. OWC controls exist in only one location so things like server side “Code Behind” are not relevant.

3. On a web page, client side VBScript or Jscript/JavaScript can be used to run the object model.

4. Via the object model and event handling OWC provides the ability to add custom context menus and menu actions.

Regards

Siva

This posting is provided "AS IS" with no warranties, and confers no rights.