With sqlserver it doesn't work as with msaccess !

declare @myvar int

set @myvar = 15

select ... from myobject where thecolumn=@myvar

With odbc this would mean you define a commandobject,

type=storedprocedure

commandtext='select ... from myobject...

Can you test what happens if you alter the colums to nvarchar(max)?

This datatype is prefered in sql2005.

TheSQLGuru (2/1/2008)

---

I posted about this topic on the SQL Server MVP private forum. I will follow-up if anyone there comes up with anything. I specifically asked Iztik Ben-Gan...

As always when "big brothers" are watching ... shivers in the spine :Whistling:

I've also tested at 32-bit Dev Edtn SP2 CU5 on 2-way XP sp2.

Same issue. :crying:

You could off course include a

NET USE ... user:yyy pasword:yyy

don't forget to clean up after teh copy !

NET HELP USE provides more info

The tests I performed were using SSMS2005.

At the client I also did install sp2 + CU5 !

(client installs are forgotten for updates way to much)

I've tested your scripts at SQL2005 DE sp2 CU5

and SQL2000 PE SP4

with no problem at all.

these are results:

SQL2000 PE sp4

(1 row(s) affected)

col1 col2

-----------...

if you want to use xp_cmdshell, you'll have to open it at sqlserver instance level ! (which I do not advise !)

We use a SQLAgent job to perform the backups.

The...

Oh certainly a huge yes regarding SP-release :exclamationmark:

Why, because IMHO a SP is considered to be a stable release, tested well by the manufacturer. Certainly worth a general test and...

There are the resulte of the test I performed :

(sql2005 dev edtn SP2 CU5)

set nocount on

-- is "Ad Hoc Distributed Queries" enabled ? if not, enable it

declare @SQLConfigOption varchar(256)...

I'm very sorry to have to tell you that it fails with partitioned objects on SQL2005.

I've tested it on an x64 EE SP2 CU2 4-socket-dualcore 16Gb

I have added the...

Phil, Chris,

Indeed no discussion regarding the use of target variables.

The point is, will its content be correct during the setbased work

if the variable is used more then once in...

Very good article, nice testcode. :w00t::cool:

There may be some testing needed regarding parallelism,

maybe for now just add a OPTION(MAXDOP 1).

The only remarks I would add to the conclusion is...

Just replace the @var with the column name in the select clause.

I tend to test with @-variables so there is no residue left behind afterwards.

Glad you figured it out 😉

IMO Bulk Insert (check BOL) is what might serve you better.

e.g.

BULK INSERT mydb.myschema.myobject

from '\\UNC_path\myobjectdata.txt'

WITH

( FIELDTERMINATOR = ''

--,CODEPAGE =...