is FN a synonym for datepart???

its a one-off operation as the case maybe for testing;

so i prefer a solution in the managent studio;

i wrote an c# program that gives me the result, too.

but as mentioned...

yes, it is a ms word document

i tried it with a jpg and it works

but with the word document, it didn't work

by comparing the original doc-file with the created file from bcp,

ther are only 2signs differnet in the beginning of the hearer.

when i delete them the doc-file will be correct.

may i...

by using

bcp "select datei from Adventureworks.Person.Address WHERE

addressid=1 " queryout "c:\TestOut.doc" -T -n -Slocalhost

the file will be created. the file has the same filesize like the original.

But the content is very...

Hi,

i tried the following:

bcp "select datei from Person.Address WHERE

addressid=1 " queryout "c:\TestOut.doc" -T -n -Slocalhost\AdventureWorks

but i got the following error message:

SQLState = 08001, NativeError = -1

Error = [Microsoft][SQL Native...

hi, thank you for your reply:

I tried the following:

Exec master.dbo.xp_cmdshell 'osql -E -S. -Q"select datei from person.address where addressid=1" -o"C:\test.doc" -d"AdventureWorks"'

But when i look into the doc-file: the content is...