Viewing 15 posts - 466 through 480 (of 529 total)
Export from Query:
bcp "SELECT * FROM master..sysobjects ORDER BY name" queryout NameOfOutputFile.Extension -c -U"<<ValidSQLUsername>>" -P"<<PasswordOfSQLUser>>" -S"<<SERVERNAME>>"
Import: Do a BULK INSERT to a #tbl, process you data and then do INSERT...
May 28, 2003 at 7:56 am
Importing from a TextFile with T-SQL:
BULK INSERT Test.dbo.inter_ExportJob FROM '<<NameOfOutputFile.Extension>>'
Remember that the file has to be reachable from SQL server and be of the required structure. Look in BOL for...
May 28, 2003 at 6:52 am
Use the 'bcp' command line utility.
bcp "[database].[owner].
" out NameOfOutputFile.Extension -c -U"<<ValidSQLUsername>>" -P"<<PasswordOfSQLUser>>" -S"<<SERVERNAME>>"
Regards, Hans
May 28, 2003 at 6:45 am
quote:
Its about the Date() and Now() function in ASP Programming. Which date format will these functions adopt?
May 28, 2003 at 5:32 am
Importation from Excel yields also another kind of problem. Since the data sampling is beeing done with the first 8 rows of data sometimes unwanted results can arise. For example...
May 28, 2003 at 5:21 am
quote:
Can anybody explain why one acct would return the complete resultset but the other account returns only one row?
May 28, 2003 at 3:26 am
Thank you! That was excactly what I wanted to know 🙂
But then I have another issue of discussion. I thought they could be related but maybe not.
Our company upgraded both...
May 27, 2003 at 5:30 am
Antares686:
quote:
But are you asking would it be better to write three SPs with a central one called but each having a unique...
May 27, 2003 at 3:32 am
Thanks for all the pointers!
I would prefer to do everything in the DTS and not having to call from VB everytime I run it. If a script is the way...
May 23, 2003 at 10:15 am
Hello!
Thanks for the response 🙂
I would prefer not to use excel automation inside an SQL task (which I am not sure is working as our server lacks Excel installed). I...
May 23, 2003 at 5:25 am
I believe I have the same problem. We (?) are trying to export to an Excel file with a name that is depending on a query (on an SQL DB)...
May 23, 2003 at 2:29 am
Antares686:
quote:
In this situation where there is a minimal difference in with and without the variable on submit I personally prefer Steve's...
May 22, 2003 at 7:34 am
quote:
I think if you create a stored procedure named abc that calls xp_cmdshell and grant EXECUTE abc rights to the given user,...
May 16, 2003 at 2:57 am
Scout7
quote:
Before I start looking into rebuilding all of my databases in order to change the collation settings, would having this...
May 15, 2003 at 9:45 am
This seems like quite a complex question. It seems like you need someone to program your middle tier and I believe it could take some time to do this. It...
April 6, 2003 at 11:16 am
Viewing 15 posts - 466 through 480 (of 529 total)