Competition: What’s your favorite Redgate tool? Enter now.

Issues with "INTO" keyword in 7.3.0.450

1mc1mc Posts: 2
edited August 25, 2016 9:02AM in SQL Prompt
When I am applying the styling on the following code:
SELECT name,
	   object_id,
	   principal_id,
	   schema_id,
	   parent_object_id,
	   type,
	   type_desc,
	   create_date,
	   modify_date INTO #tmp FROM sys.objects ORDER BY name

And the result is:
SELECT
    name,
    object_id,
    principal_id,
    schema_id,
    parent_object_id,
    type,
    type_desc,
    create_date,
    modify_date INTO #tmp
FROM
    sys.objects
ORDER BY
    name

But I was excepting the following:
SELECT
    name,
    object_id,
    principal_id,
    schema_id,
    parent_object_id,
    type,
    type_desc,
    create_date,
    modify_date 
INTO 
	#tmp
FROM
    sys.objects
ORDER BY
    name

How can I do this?

Comments

Sign In or Register to comment.