Formatting code
Posted: Fri 10 Oct 2014 12:22
Hello
I format the code
But I want:
It's about tablature in "in" and "case". Is it possible
Maybe... is it possible:
I format the code
Code: Select all
select
1 as name
,N'test test test test test test ' + cast('111' as nvarchar(10)) + N'test test test test test test test test' + case
when 1 = 0
then 'Test'
else N'No test'
end as [Alias]
from
[dbo].[Table1] [t]
where
column1 in (
select
2
from
Table2
)
Code: Select all
select
1 as name
,N'test test test test test test ' + cast('111' as nvarchar(10)) + N'test test test test test test test test' + case
when 1 = 0
then 'Test'
else N'No test'
end as [Alias]
from
[dbo].[Table1] [t]
where
column1 in (
select
2
from
Table2
)Maybe... is it possible:
Code: Select all
select
1 as name
,N'test test test test test test '
+ cast('111' as nvarchar(10))
+ N'test test test test test test test test'
+ case
when 1 = 0
then 'Test'
else N'No test'
end
as [Alias]
from
[dbo].[Table1] [t]
where
column1 in (
select
2
from
Table2
)