field <long text>

I have a table with the column type [ntext].
I store in this column the contains of an xml file.
When I run the select for this table on "sqlserver enterprise manager", the
value of this column is <long text>.
how can I see the exact contains of this column ?
I have to use another tools ?
thanks
ft> I have a table with the column type [ntext].
> I store in this column the contains of an xml file.
> When I run the select for this table on "sqlserver enterprise manager",
the
> value of this column is <long text>.
> how can I see the exact contains of this column ?
Use Query Analyzer. Enterprise Manager is primarily for system management,
not data viewing/manipulation.
http://www.aspfaq.com/2455

field <long text>

I have a table with the column type [ntext].
I store in this column the contains of an xml file.
When I run the select for this table on "sqlserver enterprise manager", the
value of this column is <long text>.
how can I see the exact contains of this column ?
I have to use another tools ?
thanks
ft
> I have a table with the column type [ntext].
> I store in this column the contains of an xml file.
> When I run the select for this table on "sqlserver enterprise manager",
the
> value of this column is <long text>.
> how can I see the exact contains of this column ?
Use Query Analyzer. Enterprise Manager is primarily for system management,
not data viewing/manipulation.
http://www.aspfaq.com/2455

field <long text>

I have a table with the column type [ntext].
I store in this column the contains of an xml file.
When I run the select for this table on "sqlserver enterprise manager", the
value of this column is <long text>.
how can I see the exact contains of this column ?
I have to use another tools ?
thanks
ft> I have a table with the column type [ntext].
> I store in this column the contains of an xml file.
> When I run the select for this table on "sqlserver enterprise manager",
the
> value of this column is <long text>.
> how can I see the exact contains of this column ?
Use Query Analyzer. Enterprise Manager is primarily for system management,
not data viewing/manipulation.
http://www.aspfaq.com/2455

Few Questions

Hi,

I have few questions about SQL Server, let me mention here..

How to generate XML File from SQL Server? Is there anyway can we generate directly from Query?

What are Temporary tables (Regular & Global) and where do we need them in Real Time?

What are BCP Statements? where do we need them?

How to pass XML Document to Proc, and insert the data, any example?

Types of Triggers?

Shink data, what is that?

What T-Read, Uncommitted read?

What is Replication ?

Thanks
Seshu

hey this is not few... hahaha

How to generate XML File from SQL Server? Is there anyway can we generate directly from Query?

you can use the for XML clause

example :

select * from employees for xml auto

What are Temporary tables (Regular & Global) and where do we need them in Real Time?

these are temporary table and are use to store data that still needs to be processed or

processed information that are too large to be return via a regular variable. temporary tables

performs like a regular table except that they are automatically destroyed when there are no more

connection referencing it. Regular temp tables as ( represent by tablename #temp, single pound sign) as oppose to

global temptable (which are named ##temp, using double pound sign) are visible only to the connection

that created it while Global temp tables are visible to any connection

What are BCP Statements? where do we need them?

bulk copy program is a Dos based interface for loading multiple records from files(CSV,stc) using bcp formats

How to pass XML Document to Proc, and insert the data, any example?

in 2005 XML datatype can be used as parameters in table definition and as variables. you can insert an XML or fragment of XML to an XML columns. You can see my blogs for some examples

Types of Triggers?

insert, update, delete, instead of, DDL triggers

Shink data, what is that?

This is used to compress the data and release unused spaces use by the database. you can also use Shrinkfile to individually shrink the database

What T-Read, Uncommitted read?

looks like this topic belongs to serialization and locking. this is how sql server is going to read the data

What is Replication ?

replication is copying and synchronizing data to another server

Your homework is quite long hahaha.

Fetching XML data from Oracle CLOB data field

I have one Oracle Table space which hav one CLOB type table field -- this field have XML data. Now What I doing with:
I am fecting this data to MS SQL 2000 DB. I'd created one MEMO field for XML data. Data is comming properly into MS sql 2000 DB.
Now I would to seprate XML field into another table in MS SQL TABe
Example
XML name,city,age,price field will copy to SQL field name,city..
is this possiable iwith MS SQL.
Arvind
Yes. You can use the OpenXML functionality to shred it (see books Online for
information). One caveat: You need to pass the document to T-SQL via a
stored proc using an NTEXT typed parameter if the data is larger than 8kB.
In SQL Server 2000 you can only do so by calling the stored proc from the
client/midtier and not within the server.
Best regards
Michael
"Arvind Saxena" <ArvindSaxena@.discussions.microsoft.com> wrote in message
news:5CAA29ED-8FD8-4D1C-BE53-58A31892C51E@.microsoft.com...
>I have one Oracle Table space which hav one CLOB type table field -- this
>field have XML data. Now What I doing with:
> I am fecting this data to MS SQL 2000 DB. I'd created one MEMO field for
> XML data. Data is comming properly into MS sql 2000 DB.
> Now I would to seprate XML field into another table in MS SQL TABe
> Example
> XML name,city,age,price field will copy to SQL field name,city..
> is this possiable iwith MS SQL.
> --
> Arvind
|||HI Michael,
Coould you please give one example so I can user OPEN XML. I'd already setup SQL package to get data from Oracle to SQL table. After that I would like to split XML data from SQL TEMP table to another SQL table.
Arvind
"Michael Rys [MSFT]" wrote:

> Yes. You can use the OpenXML functionality to shred it (see books Online for
> information). One caveat: You need to pass the document to T-SQL via a
> stored proc using an NTEXT typed parameter if the data is larger than 8kB.
> In SQL Server 2000 you can only do so by calling the stored proc from the
> client/midtier and not within the server.
> Best regards
> Michael
> "Arvind Saxena" <ArvindSaxena@.discussions.microsoft.com> wrote in message
> news:5CAA29ED-8FD8-4D1C-BE53-58A31892C51E@.microsoft.com...
>
>
|||If you have the data inside a SQL table, then you unfortunately cannot
easily pass it through to sp_xml_preparedocument due to no support for
variables of type TEXT/NTEXT. So you either have to get the data out to
OLEDB/ADO/ADO.net and call back into the database using a stored proc or get
the data from the Oracle database passed into the stored proc directly.
There are some dynamic SQL workarounds as well (see http://www.sqlxml.org).
Best regards
Michael
"Arvind Saxena" <ArvindSaxena@.discussions.microsoft.com> wrote in message
news:26E3A058-FD44-4C21-B756-AAFB606EC040@.microsoft.com...[vbcol=seagreen]
> HI Michael,
> Coould you please give one example so I can user OPEN XML. I'd already
> setup SQL package to get data from Oracle to SQL table. After that I
> would like to split XML data from SQL TEMP table to another SQL table.
>
> --
> Arvind
>
> "Michael Rys [MSFT]" wrote:
|||How DO I pased XML data from oracle to MS SQL thru store proc.
My Oracle Table space have 5 field and 1 clob filed for XML.
--
Arvind
"Michael Rys [MSFT]" wrote:

> If you have the data inside a SQL table, then you unfortunately cannot
> easily pass it through to sp_xml_preparedocument due to no support for
> variables of type TEXT/NTEXT. So you either have to get the data out to
> OLEDB/ADO/ADO.net and call back into the database using a stored proc or get
> the data from the Oracle database passed into the stored proc directly.
> There are some dynamic SQL workarounds as well (see http://www.sqlxml.org).
> Best regards
> Michael
> "Arvind Saxena" <ArvindSaxena@.discussions.microsoft.com> wrote in message
> news:26E3A058-FD44-4C21-B756-AAFB606EC040@.microsoft.com...
>
>
|||You would write a midtier program (for example using the Oracle OLEDB
provider) and retrieve the information and pass it through ADO to a stored
proc where you have a parameter per field and an NTEXT parameter for the
XML.
Best regards
Michael
"Arvind Saxena" <ArvindSaxena@.discussions.microsoft.com> wrote in message
news:2F32C6BE-BD3E-4F29-AE93-66DA5CEC914A@.microsoft.com...[vbcol=seagreen]
> How DO I pased XML data from oracle to MS SQL thru store proc.
> My Oracle Table space have 5 field and 1 clob filed for XML.
>
> --
> --
> Arvind
>
> "Michael Rys [MSFT]" wrote:

Feature request

Some of our users who may be running packages are not so adept at editing XML configuration files. It'd be nice if we could instead either:
1. Have an interface to modify the XML dtsConfig files
or 2. Have another option that would prompt via dialog box for the configuration options when the DTS package is run.
On #1, anyone know of any existing programs that would be useful (something that would ignore the markup and just edit the variables)?
Thanks for the request, Jonathan. It's on our list of things to consider for the next version, we just didn't have the time to get it into SQL Server 2005.

regards,
ash

fax PDF

We have a process that takes XML files and split them into pdf's. These
files then based upon a field in a table need to be faxed. The fax info is
stored in a SQL table. The process needs to insert into the pdf control
characters for faxing. Then this newly created file needs to be picked up by
RightFax to be sent out.
Any suggestions on how this can be done.That process is implement within SQL Server?
Do you need to implement faxing inside SQL as well?
I would suggest writing a custom application outside sql in C# , VB.NET, C++
or whatever language.
Is rightFax a COM based product? If it is you could use sp_OACreate to
create OLE object and pass in pdf file path. But that would be asking for
trouble, like I said you're better off with your own solution.
"Hoosbruin" <Hoosbruin@.Kconline.com> wrote in message
news:X5OdnTd-zqDx2KLfRVn-ug@.kconline.com...
> We have a process that takes XML files and split them into pdf's. These
> files then based upon a field in a table need to be faxed. The fax info is
> stored in a SQL table. The process needs to insert into the pdf control
> characters for faxing. Then this newly created file needs to be picked up
by
> RightFax to be sent out.
>
> Any suggestions on how this can be done.
>sql

Fastest way to move XML document into and back out of CLR function

Fastest way to move XML document into and back out of CLR function
In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass
an xml data type variable into a C# CLR function and retrieve it back out of
the C# CLR function when the C# CLR function is done modifying it?
I tried this but get deployment error becuase SQLServer2005/CLR dotn support
System.Xml.XmlDocument:
public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction]
public static int InsertSomeNode(System.Xml.XmlDocument pDoc)
{
//
return 1;
}
};
thorws error:
Error 1 Column, parameter, or variable #1: Cannot find data type
XmlDocument. InsertSomeNodeHi
the SQL XML datatype is a SqlXml type in the System.Data.SqlTypes namespace.
There is no .NET equivalent see
http://msdn2.microsoft.com/en-us/library/ms131092.aspx
John
"DR" wrote:
> Fastest way to move XML document into and back out of CLR function
> In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass
> an xml data type variable into a C# CLR function and retrieve it back out of
> the C# CLR function when the C# CLR function is done modifying it?
> I tried this but get deployment error becuase SQLServer2005/CLR dotn support
> System.Xml.XmlDocument:
> public partial class UserDefinedFunctions
> {
> [Microsoft.SqlServer.Server.SqlFunction]
> public static int InsertSomeNode(System.Xml.XmlDocument pDoc)
> {
> //
> return 1;
> }
> };
> thorws error:
> Error 1 Column, parameter, or variable #1: Cannot find data type
> XmlDocument. InsertSomeNode
>
>