SQL Server 2012 and 2014 supports IIF(cont,true,false) function. Thus for minimal selection you can use it like SELECT IIF(first>second, second, first) the_minimal FROM table While IIF is just a shorthand for writing CASE…WHEN…ELSE, it’s easier to write.
CASE WHEN last_name IS NULL THEN ” ELSE ‘ ‘+last_name END
Actually a new line in a SQL command or script string can be any of CR, LF or CR+LF. To get them all, you need something like this: SELECT REPLACE(REPLACE(@str, CHAR(13), ”), CHAR(10), ”)
DELETE TableA FROM TableA a INNER JOIN TableB b ON b.Bid = a.Bid AND [my filter condition] should work