The better option would be to have your database object definitions in your code store, so you can grab them and run them in the new server.

Why the extra step of replacing the concatenated CR and LF?  Doesn't replacing the individual CHARs suffice?  That's how I've done it, and I'd like to know if there is...

I'm confused.  What data is added, given that the temp table #songs never had anything in it?

Don't forget to use floating-point math, not integer math, when you're dividing by 5280.

For example, 660 feet is 1/8 of a mile.

SELECT 660/5280
SELECT 660/5280.0

The result of the...

• This reply was modified 5 years, 3 months ago by  GaryV.
• This reply was modified 5 years, 3 months ago by  GaryV.

If you want to MERGE into table TRANSDETAIL, then that would be the TARGET.

Is the CTE meant to be the source of data that your MERGE is using?  Then it...

• This reply was modified 5 years, 3 months ago by  GaryV.

I got the "right" answer because I recognized the concept of the question - that if we do not supply an ELSE in a CASE statement, anything that fails the...

In your select statement, you'd replace

, A = B

with

, CASE .... END

that was given above.

The Cast converts the constants 1 or 0 which are integer values to bit data types. ...

Mine was on an import, yours an export.  I missed that before.

I had this problem just last week. The additional error message was "External table is not in the expected format."

I fixed it by opening the Excel file and then saving...

You checked whether the "WHERE EXISTS" would return any data.

Instead, check what will be deleted by changing "DELETE" into "SELECT *".

A VIN could be repeated after 30 years.  That's because the Year character repeats on a 30-year cycle, using 0-9 and 20 alphabetic characters (excluding those that look like numbers,...

A good question.

In the explanation:

So although we deleted the row with i = 104 (while IDENTITY_INSERT is still ON) it does not reuse this value nor...

You can code something like this for SELECT

SELECT 
     @a = 1,
     @b = 2,
     @C =...

Remember some key differences when using SET or SELECT:

• SET can only assign a single value to a variable.  If the expression being assigned returns multiple values (for...