Viewing 4 posts - 1 through 4 (of 4 total)
just running SELECT @@VERSION does not give you an accurate detailed information, this is a bad practice and laziness.
i just installed ssms v17 and its showing me what i...
July 25, 2017 at 6:52 am
how does this matter whether its in 3 colum or 1 colum, i run this statement,
CASE
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
...
July 25, 2017 at 6:37 am
that is correct, but it doesn't
July 25, 2017 at 6:24 am
MajorVersion ProductLevel Edition ProductVersion
SQL2008 R2 RTM Standard Edition (64-bit) 10.50.1617.0
July 25, 2017 at 6:09 am
Viewing 4 posts - 1 through 4 (of 4 total)