Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements. 369 more words
Tags » SQL Server
Temp table and Table Variable both are created in TempDB and not in Memory
Syntax for creating Temp Table is exactly same as creating Physical Table… 326 more words
Sometimes we would need data display in single value as csv (comma separated values) rather than rows, i.e.
40 more words
--select COLUMN_NAME from TABLE_NAME