How can we help you today? How can we help you today?
atolmeijer
Activity overview Badges (0) Posts (1) Comments (2)

Activity overview

Latest activity by atolmeijer

B 2009 / comments
  1. Community
  2. Redgate Monitor
  3. Win a limited edition SQL Monitor t-shirt and a Redgate goodie bag!
B 2009
0 votes
Formatting in CASE WHEN expression removes dot if schemaname is present and dot followed by space
  1. Community
  2. SQL Prompt
The following code dows not format properly, even not in SQL Prompt 10.0.01:USE tempdbGOCREATE SCHEMA red;GOCREATE TABLE red.Gate( ColumnA INT )GOSELECT CASE WHEN Rg. ColumnA = 1            THEN 1 ...
2 followers 3 comments 0 votes
@version 'Microsoft SQL Server 2014 (SP2-GDR) (KB4057120) - 12.0.5214.6 (X64)   Jan  9 2018 15:03:12   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) ', SSMS v17.8.1: [image] / comments
  1. Community
  2. SQL Prompt
  3. CAST columnname with square brackets and no space after AS
@version 'Microsoft SQL Server 2014 (SP2-GDR) (KB4057120) - 12.0.5214.6 (X64)   Jan  9 2018 15:03:12   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build...
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2