Viewing 15 posts - 4,276 through 4,290 (of 13,876 total)
July 13, 2018 at 12:15 pm
OPENQUERY takes only a single 'query' parameter, with a maximum length of 8,000, so splitting up the input as you are doing is not going to work (because you are...
July 13, 2018 at 12:12 pm
July 13, 2018 at 11:39 am
I'm running SSIS on 2012. I have over 3 million rows in the source flat...
July 13, 2018 at 10:39 am
Can you create a stored proc on the linked server and then call it with the necessary parameters?
July 13, 2018 at 10:36 am
July 13, 2018 at 8:05 am
This is all very well documented. If you can understand the query below, I do not understand why you would have a problem understanding the documentation.
MERGE...
July 13, 2018 at 5:15 am
Budd - Thursday, July 12, 2018 2:15 PMI thought that NVARCHAR(MAX) was limited to a 4000 character limit, and VARCHAR(MAX) was 8000.
If...
July 12, 2018 at 2:32 pm
AAAaaaaalez les Bleues...
July 12, 2018 at 2:08 pm
July 12, 2018 at 12:54 pm
July 12, 2018 at 10:48 am
Instead of
Alter table [invoice.invoice]
try
Alter table invoice.invoice
Those square brackets around the schema.table might be the issue.
July 12, 2018 at 8:57 am
What is the result of running the GRANT statement on its own?
July 12, 2018 at 8:07 am
July 12, 2018 at 5:48 am
if not exists (select 1 from TableA)
return;
Should exit the proc at that point, if zero rows are found.
July 11, 2018 at 6:56 am
Viewing 15 posts - 4,276 through 4,290 (of 13,876 total)