Hit enter to search or ESC to close
Joshua Doodnauth
  • Home
  • About
  • Blog
  • Development
    • Lab
    • Projects
    • Programming
    • Open Source
  • Contact
    Category

    SQL

    DevelopmentHow-toSQL

    Enable saving changes in SQL Server

    I 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 Doodnauth
    Joshua DoodnauthJanuary 29, 2013
    TSQLDevelopmentProgrammingSQL

    SCOPE_IDENTITY not returning value

    Very 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 Doodnauth
    Joshua DoodnauthNovember 22, 2011
    Access to SQL ServerHow-toProgrammingSQL

    Moving Access to SQL Server – Pivots

    While 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 Doodnauth
    Joshua DoodnauthApril 6, 2011
    Access to SQL ServerDevelopmentProgrammingSQL

    Using IIf in TSQL

    Using 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 Doodnauth
    Joshua DoodnauthMarch 9, 2011

    © 2024 Joshua Doodnauth.

    • Home
    • About
    • Blog
    • Development
      • Lab
      • Projects
      • Programming
      • Open Source
    • Contact