Saving Picture in PostgreSql

can ne 1 specify, how to insert a picture into a PostgreSql DB?
pl tell which data type to use and how can i display the picture in my client appi think you might be in the wrong forum
try again.sql

Saving grid results to file

How can you save QA output which have grid results to file ? It seems easy
to save text results to file. I know if i change to display "results to
text", it will solve my problem, but i had accidentally ran it in grid
format and there are multiple select statements and those results are what I
need to save to text file..through file -> save . I guess its not
possible...Goto the tools menu, options, select the results tab & set the value for
Default results target to Results to File...
Anith|||Im aware of this..but once you run the query and the results are now in grid
, how can i save the results then directly to text file before rerunning the
query that have the options you specified or have the option of saving
results to text
Thanks
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%234jHNmQ%23DHA.548@.TK2MSFTNGP11.phx.gbl...
> Goto the tools menu, options, select the results tab & set the value for
> Default results target to Results to File...
> --
> Anith
>|||i select all columns, copy, and then paste into excel.
Hassan wrote:
> Im aware of this..but once you run the query and the results are now in gr
id
> , how can i save the results then directly to text file before rerunning t
he
> query that have the options you specified or have the option of saving
> results to text
> Thanks
> "Anith Sen" <anith@.bizdatasolutions.com> wrote in message
> news:%234jHNmQ%23DHA.548@.TK2MSFTNGP11.phx.gbl...

Saving grid results to file

How can you save QA output which have grid results to file ? It seems easy
to save text results to file. I know if i change to display "results to
text", it will solve my problem, but i had accidentally ran it in grid
format and there are multiple select statements and those results are what I
need to save to text file..through file -> save . I guess its not
possible...Goto the tools menu, options, select the results tab & set the value for
Default results target to Results to File...
--
Anith|||Im aware of this..but once you run the query and the results are now in grid
, how can i save the results then directly to text file before rerunning the
query that have the options you specified or have the option of saving
results to text
Thanks
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%234jHNmQ%23DHA.548@.TK2MSFTNGP11.phx.gbl...
> Goto the tools menu, options, select the results tab & set the value for
> Default results target to Results to File...
> --
> Anith
>|||i select all columns, copy, and then paste into excel.
Hassan wrote:
> Im aware of this..but once you run the query and the results are now in grid
> , how can i save the results then directly to text file before rerunning the
> query that have the options you specified or have the option of saving
> results to text
> Thanks
> "Anith Sen" <anith@.bizdatasolutions.com> wrote in message
> news:%234jHNmQ%23DHA.548@.TK2MSFTNGP11.phx.gbl...
> > Goto the tools menu, options, select the results tab & set the value for
> > Default results target to Results to File...
> >
> > --
> > Anith
> >
> >

Save complete execution plan

i want to know how to use the complete execution plan of query file. I mean, after use the tool display execution query plan, when I try to save it, i just can save one query in a .sqlplan file, but i want to save the complete query plan, not only one query

There is no way to store that, either you can have to use the text based using SHOWPLAN setting. KBA http://msdn2.microsoft.com/en-us/library/ms190646.aspx to save it as XML.

http://msdn2.microsoft.com/en-us/library/ms190402.aspx - will get you more on How to topics.

|||i follow the instructions and now i have this problem

TITLE: Microsoft SQL Server Management Studio

Error loading execution plan XML file E:\Documents and Settings\luur4861\My Documents\SQL Server Management Studio\Projects\Master Project\executionplans1.sqlplan. (SQLEditors)

ADDITIONAL INFORMATION:

There is an error in XML document (2, 1). (System.Xml)

There is an unclosed literal string. Line 2, position 1. (System.Xml)

BUTTONS:

OK

|||
SET SHOWPLAN_XML ON;
GO

select * from dbo.isolatedleptons(24455);

select dbo.threeLeptonCut(24455);

select * from dbo.oppositeLeptons(24455);

select dbo.zVetoCut(24455);

select * from dbo.okjets(24455);

select * from dbo.bJets(24455);

select * from dbo.wJets(24455);

select * from dbo.wPairs(24455);

select * from dbo.topComb(24455);

select dbo.topcut(24455);

select * from dbo.topComb(24455);

select * from dbo.mTopComb(24455);

select * from dbo.leftjets(24455);

select dbo.jetVetoCut(24455);

select dbo.leptoncuts(24455);

select dbo.missEECuts(24455);

select * from Allcuts;

select * from optAllcuts;

select * from expcuts;

GO
SET SHOWPLAN_XML OFF;|||Sow hen you save it to XML and then try and reload you get this error? Can you look int he XML Line 2 Position 1 and see if there is a string thats not closed?

Samples for Calendar Style Reports

newbee! question.
Want to see sample reports that display
the data in calendar format like outlook does.
Example ... all appointments for the next 2 weeks arranged
as a calendar.
Thank you for your help in advance.It depends on which Outlook view. Month? Week? Day? You probably could
get the day view or business week view working using tables as well as a
dataset that included all days and hours, and outer join your appointments
so you could display the entire range of data and leave the non-appointments
blank.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Rakesh" <Rakesh@.discussions.microsoft.com> wrote in message
news:EAEA54D3-82E2-44B4-8AB0-4FEC73A79266@.microsoft.com...
> newbee! question.
> Want to see sample reports that display
> the data in calendar format like outlook does.
> Example ... all appointments for the next 2 weeks arranged
> as a calendar.
> Thank you for your help in advance.
>