or even simpler, in one command (according to the first post):

Insert into table2

select table1.*

from table1 left join table2

on table1.DateSubmission = table2.DateSubmission

where table2.DateSubmission is null

Work around this problem can be to have SQL task as you have but inside SQL to raise error in one case, something like:

if (select count(*)...) > 0 raiserror('message', 16,...

Check if SQL can access this directory from both nodes.

It's not just a problem of database, program, script,... This is organizational problem. The best you can do is to analyze data and produce report by departments with all irregular...

Talking about date and time data types it's also interesting to mention new function SWITCHOFFSET which returns a datetimeoffset that is changed from the stored offset to a new time...

Storage size for new date and time data types are (in bytes):

date 3

time 3-5

datetime2 6-8

datetimeoffset 8-10

In addition to Gail script I'll suggest to check whether a content is a valid numeric type. For example, you can add in inner query where clause (WHERE ISNUMERIC(SaleAmount)=1)

In general I will agree with John and Jeff. But sometimes it's not just like that.

For example, having images on file system is good solution but then backup becomes...

To be honest to you I'm using this script for pdf files and I haven't test it for jpg. I'll do some test tomorrow if it's not too late to...

Hi, I'm using bcp to queryout images from database and T-SQL code looks something like this:

DECLARE c1 CURSOR FOR

SELECT (KeyField)

FROM (Table)

WHERE ...

OPEN c1

FETCH NEXT FROM c1

INTO...

Second approach is to extract words from user entry and insert into temporary table so after that you can join it with your noise and key tables.

declare @UserEntry nvarchar(4000)

declare @Position...

One way to isolate records from table Noise matching pattern is something like:

SELECT Word

from Noise

WHERE 'user entry' like '%' + Word + '%'

This result set you can put into cursor...

Long time ago I created this script in order to delete all records from current database and I think it can be start point for what you need.

declare @Order int

declare...

Backup source database and restore it on destination server using with move option.

If you are going to make a script than you'd write T-SQL commands for every table like this:

-- Server2 is the other server linked on Server1 with proper security

-- table1...