I would have thought that the following would work

DECLARE @cmd VARCHAR(2048);

SET @cmd = 'bcp "[Staedion Test].[dbo].[myTestNativeData]" out "C:\myTestUniNativeData-N.csv" -N -T -t","';

EXEC master..xp_cmdshell @cmd

In other words, since the dbtable parameter...

I recall an internsive software development project where the under-qualified and inexperienced junior developer proved very valuable.

Firsly, he could complete the simple modules I assigned to him.

But, even more importantly,...

At the moment, your SqlCommand object doesn't know about your SqlParameter object.

You need a line

command.Parameters.add(param);

between your 2 using statements.

But, 'Welsh Corgi' is right to say that you should have at...

I used the SQL Developer Migration tool and it does pretty well.

Migrating table definitions and data was certainly OK.

It certainly attempts to migrate Stored procedures, functions etc and does use...

I must say that the defence of the question/answer by bitbucket and Lynn Pettis is far from convincing.

And I am in the GMT time-zone!

It seems to be you two against...

You're right Pablo, I'm wrong (= I don't reflect reality) :blush:.

Double quotes do work around the reserved words.

Single quotes and square brackets do not work. I must have given up...

Having faced the same problem, I concluded that you just cannot use ORACLE reserved words for column names etc.

Brackets, quotes etc do not help.

Lower/upper case is irrelevant. By default, names...

A small correction ...

declare @ThisDate datetime;

set @ThisDate = getdate();

select

getdate() as CurrentDateTime,

dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) as BeginningOfNextMonth, -- Beginning of...

The technical issues are well thought out but I hope that you won't mind if I point out a couple of key spelling mistakes.

The word is delimiter and not...

Thank you Paul and Doug for your responses.

As Paul said, I was wrong when I stated that schemas do not contain stored procedures.

I suspect tablespaces are irrelevant to my...

Stirring stuff, peter.house, for the humour slot.

Martin

Quite right, Randy (and you don't need the DECLARE statement).

The OP asked about populating a SP variable but, as you say, he could satisfy the requirements without doing so.

But the...

You can replace

set @Activity_Title = (SELECT title FROM other_table WHERE unique_ID = @variable_4_from_CRM)

with

select @Activity_Title = title FROM other_table WHERE unique_ID = @variable_4_from_CRM

Note that if the SELECT statement did return...

metalink.oracle.com seems to be available only if you have an ORACLE support contract.

The great plus point about this SqlServerCentral site is the number of people willingly giving their expertise....

Returning to the original question.

I suspect that there's a level of error-checking performed when a batch of commands are submitted and parsed by SQL Server. This happens before any of...