SQL Server version of MYSQL insert into

Question

I have the following query running on a MySQL, but it fails when I run it on a SQL Server database. How should it look to please SQL Server?

INSERT INTO first_table (pk, data)
VALUES ((SELECT value
           FROM second_table
          WHERE key = 'key'),
          'other-data');

Answer 1

INSERT INTO first_table (pk, data)
SELECT value, 'other-data'
FROM second_table
WHERE key = 'key'

Answer 2

Something like this

INSERT INTO first_table (pk, data) 
SELECT  value ,
        'other-data'
FROM    second_table 
WHERE key = 'key'

Have a look at INSERT

Load data using the SELECT and EXECUTE options

Answer 3

You could use a subquery to retrieve the PK:

INSERT INTO first_table (pk, data)
SELECT
    (SELECT value FROM second_table WHERE key = 'key')
,   'other-data'

Answer 4

Try this:

INSERT INTO first_table (pk, data)
SELECT value, 'other-data'
FROM second_table
WHERE key = 'key';

Answer 5

INSERT INTO first_table (pk, data)
SELECT value, 'other-data'
FROM second_table
WHERE key = 'key'