Comments
Sort by recent activity
It happens when a select statement is enclosed in parenthesis such as a derived table or a subquery:
select
SubQueryColumn = (
select count (*) from dbo . MyTable
)
select
MyCount
from
(
select count (*) as MyCount from dbo . AnyTable
) as MyDerivedTable / comments
It happens when a select statement is enclosed in parenthesis such as a derived table or a subquery:
select
SubQueryColumn = (
select count (*) from dbo . MyTable
)
select
MyCount
from
(
select cou...
tanya wrote:
...Also, can you tell us if the issue happens only on particular editors? And do you have SQL Refactor installed in your machine?...
This was on SSMS '05. I don't have SQL Refactor. / comments
tanya wrote:
...Also, can you tell us if the issue happens only on particular editors? And do you have SQL Refactor installed in your machine?...
This was on SSMS '05. I don't have SQL Refactor.
Tanya, Were you able to reproduce this? / comments
Tanya, Were you able to reproduce this?
When formatting my code, it ends up with spaces around delimiter dots, for example: Select * from dbo . MyTable instead of dbo.MyTable. I didn't even know that you could put spaces around dots like that, but I don’t particularly like it. Is this a bug or a feature? / comments
When formatting my code, it ends up with spaces around delimiter dots, for example: Select * from dbo . MyTable instead of dbo.MyTable. I didn't even know that you could put spaces around dots like...
How about this?
select convert(nvarchar(8),dateadd(mm, datediff(mm, 0, getdate()), 0), 112) -- first day of month / comments
How about this?
select convert(nvarchar(8),dateadd(mm, datediff(mm, 0, getdate()), 0), 112) -- first day of month