MS SQL(2000) table export to excel

I′m looking for a script (sql transaction, or function) to export MS
SQL(2000) Table to formated excel sheet (cells width, text format, ...).how about using the DTS
to export that to excel
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Milo?" wrote:

> I′m looking for a script (sql transaction, or function) to export MS
> SQL(2000) Table to formated excel sheet (cells width, text format, ...).|||Milo?,
You also can use BCP command. See Books Online.
Regards,
"Milo?" wrote:

> I′m looking for a script (sql transaction, or function) to export MS
> SQL(2000) Table to formated excel sheet (cells width, text format, ...).|||Thank You Jose,
DTS export ist very easy, for my situation is the best, but it has litlle
problem with text encoding.
Milo?
?Jose G. de Jesus Jr MCP, MCDBA" nap_sal (nap_sala):
> how about using the DTS
> to export that to excel
>
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
> "Milo?" wrote:
>sql

MS SQL Server 2005 Express edition

Hi,
Does MS SQL Server 2005 Express Edition supports full text search?
Is it possible to download and use FTS? or I had to use other SQL Server
versions?
Thanks
No, you have to use SQL Turbo or build an inverted file index and query
that.
I would also advise you to check with your Microsoft contacts what their
plans are for SQL FTS integration with SQL Express.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Grcan YCEL" <gurcan@.workmail.com> wrote in message
news:uQcseWG5FHA.3908@.tk2msftngp13.phx.gbl...
> Hi,
> Does MS SQL Server 2005 Express Edition supports full text search?
> Is it possible to download and use FTS? or I had to use other SQL Server
> versions?
> Thanks
>

MS Sql server 2000 -full text search

I'm trying to evaluate between using MS Sql server based full text search Vs open-source full-text search for our core product. Does anyone know of any previous benchmarks/comparisons between these two approaches? Appreciate any reply.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Anantha,
Unfortunately, no such benchmarks/comparisons exists today and Microsoft has
never released any such benchmarks as well.
However, I have long been kicking around the idea of building a "SQL FTS
Benchmarking Toolkit" along the lines of a TPC Benchmark suite and I
submitted and abstract on it for the 2003 PASS conference. I'm assuming
you're comparing SQL Server 2000 FTS vs. MySQL FTS vs. PostgreSQL with is
TSearch2 or OpenFTS as I have researched all of these products or are you
considering other open-source full-text search products?
However, what you can do is build a sample database with publicly available
text data from the Moby lexicon project built by Grady Ward at
http://www.dcs.shef.ac.uk/research/ilash/Moby/ and then setup up a standard
benchmarking test. Note, this data is freely
available and is in the public domain, per Grady Ward. Additionally,
Microsoft as well as other RDBMS vendors, such as ORACLE and IBM compete in
standard TPC Benchmarking tests in order to determine which database is the
fastest, etc. while using a standard test suite of tools, database schema
and data, using the TPC Benchmark C (http://www.tpc.org/tpcc/detail.asp).
The TPC Benchmark that is closest to a "Full Text Search" TPC Benchmark is
TCP-W (http://www.tpc.org/tpcw/default.asp), but this too is mostly a
transactional web e-Commerce benchmark and not strictly for FTS queries.
Full Text Indexing (FTI) and Full Text Search (FTS) performance go hand in
hand along with the language of the text (Moby has word lists in five of
languages), the size (both row count and the amount of text per row) to
create a matrix of tests that will not only measure the FTI performance, but
will measure FTS queries from multiple clients issuing random FTS queries.
Additional factors, include both hardware and software configurations, for
example: the number, speed of the CPU's as well as the size and type of
L-cache per CPU. Other hardware configurations, includes the amount of RAM,
the number of disk controllers as well as the type of raid disk drives and
where the database files and FT Catalog files are placed. As you can see
this is a non-trivial effort and one I plan on documenting for my book on
this subject.
I continue to work on completing the "SQL FTS Benchmarking Toolkit" and
until it is completed, I'd recommend that you download some of the Moby test
files and develop a test database and tables and load this data into it and
then use the Microsoft provide client tool OSTRESS utility (download at:
http://support.microsoft.com/default...b;en-us;887057) use it to
measure the performance of multiple FTS queries from multiple clients
against your test database for comparisons against other open-source
full-text search for your core product.
Please feel free to contact me if you need additional details.
Regards,
John
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:#$cwriW1EHA.4004@.tk2msftngp13.phx.gbl...
> I'm trying to evaluate between using MS Sql server based full text search
Vs open-source full-text search for our core product. Does anyone know of
any previous benchmarks/comparisons between these two approaches?
Appreciate any reply.
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||John,
Thanks for your help. I'm trying to evaluate MS SQL Server 2000 FTS with open-source product/framework Lucene.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||You're welcome, Anantha,
If you're in comparing the open-source product/framework Lucene with SQL
Server 2000 FTS (both very different implementations of Full Text Search),
you may be interested in DotLucene - The Open Source Search Engine for .NET
at: http://openlucene.net/. Also, keep in mind if you're goal is to do full
text search of documents (MS Word, HTML, etc.) stored outside of SQL Server
tables, you can also use the Windows Indexing Service and setup a Linked
Server (via MSIDXS OLEDB provider) for other data stored in SQL Server.
Regards,
John
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:e1Z8S8Z1EHA.3840@.tk2msftngp13.phx.gbl...
> John,
> Thanks for your help. I'm trying to evaluate MS SQL Server 2000 FTS with
open-source product/framework Lucene.
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
sql

MS SQL Linked Server Issue

This is a multi-part message in MIME format.
--=_NextPart_000_0034_01C86DA3.377E73B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I am have created a linked server in MS SQL 2000 to Sage Line 50v12 = using the ODBC drivers in sage.I am able to view all the tables once I = clicked on the link server link in the SQL enterprise manager. However = when I run the below query I get only one records instead of 28.
SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I got to know that OPENQUERY returns = only a single record. Is there any other function/command that will = enable me to get all the records from a table from a linked server?
Can you let me know I am missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_0034_01C86DA3.377E73B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi All,

I am have created a linked server in = MS SQL 2000 to = Sage Line 50v12 using the ODBC drivers in sage.I am = able to view all the tables once I clicked on the link server link in the SQL = enterprise manager. However when I run the below query I get only one records = instead of 28.

SELECT * FROM OPENQUERY(SageL50, = 'SELECT * from Sales_Ledger')

I am running SQL 2000 server with SP4

From the SQL online documentation I = got to know that OPENQUERY returns only a single record. Is there any other = function/command that will enable me to get all the records from a table from a linked server?

Can you let me know I am = missing here?

Thanks and Regards,
Saurabh
--=_NextPart_000_0034_01C86DA3.377E73B0--This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C86EEC.F996B580
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Any updates on the below query.
Thanks and Regards,
Saurabh
"news" <news@.microsoft.com> wrote in message =news:%23b2csSXbIHA.484@.TK2MSFTNGP06.phx.gbl...
Hi All,
I am have created a linked server in MS SQL 2000 to Sage Line 50v12 =using the ODBC drivers in sage.I am able to view all the tables once I =clicked on the link server link in the SQL enterprise manager. However =when I run the below query I get only one records instead of 28.
SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
I am running SQL 2000 server with SP4
From the SQL online documentation I got to know that OPENQUERY returns =only a single record. Is there any other function/command that will =enable me to get all the records from a table from a linked server?
Can you let me know I am missing here?
Thanks and Regards,
Saurabh
--=_NextPart_000_000F_01C86EEC.F996B580
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Hi,
Any updates on the below =query.
Thanks and Regards,
Saurabh
"news" wrote in message news:%23b2csSXbIHA.4=84@.TK2MSFTNGP06.phx.gbl...
Hi All,

I am have created a linked server =in MS SQL 2000 =to Sage Line 50v12 using the ODBC drivers in =sage.I am able to view all the tables once I clicked on the link server link in =the SQL enterprise manager. However when I run the below query I get only one =records instead of 28.

SELECT * FROM OPENQUERY(SageL50, ='SELECT * from Sales_Ledger')

I am running SQL 2000 server with SP4

From the SQL online documentation I =got to know that OPENQUERY returns only a single record. Is there any other function/command that will enable me to get all the records from a =table from a linked server?

Can you let me know I am =missing here?

Thanks and Regards,
Saurabh

---

--=_NextPart_000_000F_01C86EEC.F996B580--|||Did you try:
SELECT * FROM SageL50.<database>.<owner/schema>.Sales_Ledger
Replace <database> with the database that contains the table you want,
and the <owner/schema> with the owner of the table - generally dbo.
Example:
SELECT * FROM SageL50.db1.dbo.SalesLedger;
Jeff
news wrote:
> Hi,
> Any updates on the below query.
> Thanks and Regards,
> Saurabh
>
> "news" <news@.microsoft.com <mailto:news@.microsoft.com>> wrote in
> message news:%23b2csSXbIHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> I am have created a linked server in MS SQL 2000 to Sage Line
> 50v12 using the ODBC drivers in sage.I am able to view all the
> tables once I clicked on the link server link in the SQL
> enterprise manager. However when I run the below query I get only
> one records instead of 28.
> SELECT * FROM OPENQUERY(SageL50, 'SELECT * from Sales_Ledger')
> I am running SQL 2000 server with SP4
> From the SQL online documentation I got to know that OPENQUERY
> returns only a single record. Is there any other function/command
> that will enable me to get all the records from a table from a
> linked server?
> Can you let me know I am missing here?
> Thanks and Regards,
> Saurabh
>

MS SQL 2000 - SQL Select with XPATH Where Clause

In MS SQL Server 2000, is there an easy way to use an XPATH statement in a
WHERE clause? I have a table with a TEXT column that contains XML. I would
like to query this table and select any rows where the XML data field meets
my XPATH criteria.
I'm attempting to avoid using cursors and sp_xml_preparedocument on each row
of data in the table, but with SQL Server 2000, that may be my only option.
Any help would be appreciated!Bryan (Bryan@.discussions.microsoft.com) writes:
> In MS SQL Server 2000, is there an easy way to use an XPATH statement in
> a WHERE clause?
Yeah, upgrade the instance to SQL 2005. :-)

> I have a table with a TEXT column that contains XML. I
> would like to query this table and select any rows where the XML data
> field meets my XPATH criteria.
> I'm attempting to avoid using cursors and sp_xml_preparedocument on each
> row of data in the table, but with SQL Server 2000, that may be my only
> option.
OPENXML is on the only XML support that SQL 2000 offers. I agree that a
cursor and preparedocument for each is not appealing. The other alternative
would be to bring the data to the client, but is probably even less
appealing.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx