Creating SQL query with line breaks in a single string

Question

In the SQL Server Management Studio I create a new query and then I run the following code:

select dbName.dbo.ScalarFunction()
union
select dbName2.dbo.ScalarFunction()

Then I try to do the same thing from my C# program. However I am having trouble to translate the above to one Query string. I have tried the following, but without any success:

string QueryString = @"select dbName.dbo.ScalarFunction() /r/n union /r/n select dbName2.dbo.ScalarFunction()"

and

string QueryString = @"select dbName.dbo.ScalarFunction(); union; select dbName2.dbo.ScalarFunction();"

and

string QueryString = @"select dbName.dbo.ScalarFunction(); union select dbName2.dbo.ScalarFunction();"

I am very new to SQL so if anyone could help me with the correct syntax I would be very happy! Thanks in advance!

I don't think you have to have a break line when you make union query. — provençal le breton
– provençal le breton, Commented Jul 10, 2013 at 15:11
"without any success": please state what happens. A runtime error message? — ToolmakerSteve
– ToolmakerSteve, Commented Jul 10, 2013 at 15:11
I did not recieve any error messages. However I only recieved the data from the first select and the rest was just ignored — Robin
– Robin, Commented Jul 10, 2013 at 15:12
Forget about the breakline. Do not include /r/n in your string. — provençal le breton
– provençal le breton, Commented Jul 10, 2013 at 15:14
.. and don't put in ";"s. What's inside the quotes should be what SQL expects, don't try to turn it into C#-like statements. — ToolmakerSteve
– ToolmakerSteve, Commented Jul 10, 2013 at 15:16

Jon G · Accepted Answer · 2013-07-10 15:12:38Z

7

If you're using a verbatim string (i.e. defined with the @ sign before the opening quotes) then you can just press the return key in the middle of the definition, for example:

string QueryString = @"select dbName.dbo.ScalarFunction()
union
select dbName2.dbo.ScalarFunction()";

answered Jul 10, 2013 at 15:12

Jon G

4,17424 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jonesopolis · Accepted Answer · 2013-07-10 15:11:55Z

5

i dont think you need to worry about the newline

@"select dbName.dbo.ScalarFunction() union select dbName2.dbo.ScalarFunction()"

answered Jul 10, 2013 at 15:11

Jonesopolis

25.4k12 gold badges72 silver badges115 bronze badges

1 Comment

Robin Over a year ago

This solution was the most obvious one from the beginning, but it didn't work in the SSMS, so I discarded it without testing it in my own program first. Silly me. Anyways, thanks for the help!

Iridio · Accepted Answer · 2013-07-10 15:10:43Z

5

The carriage return should be \r\n and not /r/n

You can also use Environment.NewLine

Anyway, as stated in other answers, you should not worry about line breaks in SQL

answered Jul 10, 2013 at 15:10

Iridio

9,2814 gold badges51 silver badges71 bronze badges

2 Comments

ToolmakerSteve Over a year ago

Good job, spotting that mistake.

Robin Over a year ago

Fair enough. Still not the required result... :/

Collectives™ on Stack Overflow

Creating SQL query with line breaks in a single string

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related