Quick question: Exporting data

Hi,

What data format can MS SQL Server 2000 export??

WingWing (wing328@.yahoo.com) writes:
> What data format can MS SQL Server 2000 export??

With BCP you can get many formats, either by use of simple command-
line options or a format file. By using DTS you can probably get a
few more. You can also get data in XML if you like.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

quick question about replication in SQL2000 standard

This is a multi-part message in MIME format.
--=_NextPart_000_0036_01C51FFD.3E5FF470
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Can we configure the SQL 2000 database replication between two SQL = server installed on win2k standalone servers(workgroup)? or must the = servers be member server in the same domain?
regards,
Frank
--=_NextPart_000_0036_01C51FFD.3E5FF470
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,

Can we configure the SQL 2000 database = replication between two SQL server installed on win2k standalone servers(workgroup)? = or must the servers be member server in the same domain?

regards,
Frank


--=_NextPart_000_0036_01C51FFD.3E5FF470--You can, but you will need to be running in Mixed-Mode Authentication and
you will have to use SQL Server Logins.
Another option is to use Local Windows accounts, which you will have to
create on both servers, garauntee the same SIDs, names, and passwords, and
always keep these synchronized. This is a more complex strategy but can
work.
Sincerely,
Anthony Thomas
"Frank" <signup0702@.sina.com> wrote in message
news:uNQpao7HFHA.3196@.TK2MSFTNGP15.phx.gbl...
Hi,
Can we configure the SQL 2000 database replication between two SQL server
installed on win2k standalone servers(workgroup)? or must the servers be
member server in the same domain?
regards,
Frank

Quick Dumb Question

Quick Dumb Question
I was wondering if there was a way to revel what format a query returns
per column.
I am running into the situation where I am pulling data from a huge
list, and occasionally I get the error "Implicit conversion from data
type sql_variant to varchar is not allowed. Use the CONVERT function to
run this query." When inserting it into a table. When I run the
command without the insert it return all the information without the
error. So now I need to go hunt what column has the incorrect format
and what format to change it to or need to run CONVERT on that
particular item in the query
Hope that made sense.SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Your Table'
Should give you a listing of the columns in a table, and their datatypes.
"Matthew" wrote:

> Quick Dumb Question
> I was wondering if there was a way to revel what format a query returns
> per column.
> I am running into the situation where I am pulling data from a huge
> list, and occasionally I get the error "Implicit conversion from data
> type sql_variant to varchar is not allowed. Use the CONVERT function to
> run this query." When inserting it into a table. When I run the
> command without the insert it return all the information without the
> error. So now I need to go hunt what column has the incorrect format
> and what format to change it to or need to run CONVERT on that
> particular item in the query
> Hope that made sense.
>

quick date conversion - not hard!

im trying to convert my column of data type datetime. this is an example of what the data looks like:

2007-01-24 10:01:29.710

i want to format it as so

200701241001

ive tried this so far i think im sort of on the right track

RIGHT('000000000000' + CONVERT(varchar(20), CONVERT(int, sr.ResponseDate)),12) AS FinalDate

but its not outputting exactly what i want

thanks
andreas

Quote:

Originally Posted by andreas2410

im trying to convert my column of data type datetime. this is an example of what the data looks like:

2007-01-24 10:01:29.710

i want to format it as so

200701241001

ive tried this so far i think im sort of on the right track

RIGHT('000000000000' + CONVERT(varchar(20), CONVERT(int, sr.ResponseDate)),12) AS FinalDate

but its not outputting exactly what i want

thanks
andreas

im also thinking that i will need when i try convert

to put it into the style code either

code 20 or 120 yyyy-mm-dd hh:mi:ss(24h)

so thats 24 hour which is what i need and then rip the separators

or in code 126 below so theres no spaces, but i dont think thats 24 hr representation

code 126 yyyy-mm-dd Thh:mm:ss.mmm(no spaces)