2010-04-15 (first published: 2010-03-28)
7,770 reads
SP_who3
RE: BCP/BULK INSERT using fixed length file
To whoever will read on this topic: Despite claims from numerous sources that bcp and BULK INSERT can use format files to import fixed width columns, this does not seem to be so unless there is no return at the end of each line. For example, if I specify a single column import of a […]
2003-07-14
1 reads
RE: Presentations/SQL queries
There are a million different ways of doing this for a million different programming languages/rendering engines. The advantage of a pre-packed solution (ie business objects) is that they typically have a application interface so you don't have to "code" to get the output you want. There is nothing "magical" in any of these packages that […]
2003-07-11
1 reads
RE: Launcing DTS packages from Stored Procedures
frere, xp_cmdshell is one way. Alternatively look at this article, it shows you step by step how to use OLE within your SP to handle calls to DTS packages: quote: The most common method used to execute DTS packages from within T-SQL scripts or stored procedures, is via xp_cmdshell and dtsrun. Whilst this works, and […]
2003-07-10
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers