Running a Query Using a Text File for Input

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Roy Carlson » Running a Query Using a Text File for Input

34 posts, Page 4 of 4

«««1 2 3 4

Running a Query Using a Text File for Input

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Friday, January 18, 2008 10:57 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

Very good comprehensive article. I just don't understand why a simple BULK INSERT couldn't be used to populate a temp table...

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #445035

Philippe Cand

Posted Friday, January 18, 2008 1:26 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 14, 2013 11:05 AM
Points: 48, Visits: 268

mojo (1/14/2008)

Does anyone know the Microsoft.Jet.OLEDB.4.0 engine works with 64-bit SQL 2005 server?

See this
http://sqlblogcasts.com/blogs/simons/archive/2006/01/05/SSIS-64-Bit_2C00_-Excel-and-Access.aspx
It has a link to another post where more details are discussed. ;)

BI Guy

Post #445119

barbichaf2000

Posted Tuesday, March 04, 2008 2:29 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2008 2:09 PM
Points: 1, Visits: 6

Hi
I am new to SQL servers and I would like to know how does one script a database and what is scripting. I know how to use the copy tables but I don't want to copy tables only, I would like to copy the entire database.

Thank You

Post #464094

Jay Tucker

Posted Wednesday, June 24, 2009 5:34 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, August 07, 2009 6:38 AM
Points: 19, Visits: 35

Anatol,
I used your method to prepare text input to use in a WHERE clause with an IN ( ) list. If I have a lot more data to input, I would want to use a file for input, but I don't know how to actually use the file that is created in your example. Please explain.

Thanks.

Post #741448

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions