DevelopmentHow-toSQL Enable saving changes in SQL ServerI just got a new computer and reinstalled SQL Server Management Studio (both 2008 and 2012), and I was hit with a little annoying data…Joshua DoodnauthJanuary 29, 2013
DevelopmentProgrammingSQL SCOPE_IDENTITY not returning valueVery simple problem, about an hour of my time wasted. So I thought to save others. SCOPE_IDENTITY not returning value I have a stored procedure…Joshua DoodnauthNovember 22, 2011
How-toProgrammingSQL Moving Access to SQL Server – PivotsWhile moving some MS Access Queries to a SQL Server View, I realized that SQL Server handles pivots quite differently than Access. Unfortunately in SQL…Joshua DoodnauthApril 6, 2011
DevelopmentProgrammingSQL Using IIf in TSQLUsing IIF in Access I am currently moving a client from an Access DB to MS SQL Server 2008, and came up to a problem…Joshua DoodnauthMarch 9, 2011