use test

select Server.DB.dbo.testTable1.*

into Server2.test2.dbo.testTable1

from testTable1

go

The Server2 must be alinked server.

BTW, Dont do that. I am talking about select into. Bad SQL practice.

Use

INSERT INTO Table1(Col1,col2...)

SELECT col1,Col2 FROM Table2

If it is a...

Personally, I feel you are very biased..

This book was written prematurely to get to market fast. Very sloppy and some of the examples, I couldnt even get to work...

I feel...

I am assuming the message in english is "Database not found or you have no access to it".

Check whether the user connecting to the server is defined on the server...

Did you try and build your query as a dynamic SQL. Then Excute it...

Much Appreciated. I will try it out and Report....

Michael.

I use XML to pass multiple records to a Stored Procedure. Since it is not possible to pass a table variable to a SP, XML is the perfect solution since...

By the way, the explanation does not stand for string data.

The following also produces the same checksum...

SELECT CHECKSUM('aa'),

CHECKSUM('bQ')

IN SHORT......DO NOT USE for the purpose intended......

It would...

That is what I would call 'False Advertising'.....I am planning to change my process to use a Hashing algorithm via HASHBYTES.

Thanks for the info....

This is the syntax for updating with a JOIN. Pretend it is a SELECT statement. Then instead of the SELECT clause, you specify UPDATE alias, SET Columns......

You can JOIN to a temporary result set which must be named. In this case I called it LIST. You can call it anything you like. The data may be...

UPDATE UPD

SET Question Answer = 3

FROM TableName UPD

JOIN (SELECT CustomerID

FROM TableName

WHERE QuestionNAme = 'Question 1'

...

I only had success with parameters passed to SQL Execute Task when I pass the value (?) to a stored proc....

I assume you defined the parameter correctly.

Also, you pass ?...

Should be :

If OBJECT_ID('TABLENAME','U') IS NOT NULL PRINT 'Table exists..'

SQLServer is right about 2000 being a leap year and 1900 NOT.

Centuries must be divisible by 400 to be considred a leap year...

I thought we sorted this out back in...

Feels like Monday. The commit is before the End Try...