Home Forums SQL Server 2008 SQL Server 2008 - General Should I rely on the table definition to implement logic in a stored proc? RE: Should I rely on the table definition to implement logic in a stored proc?

  • March 22, 2013 at 10:25 am

    #1599865

    Lynn...since D is not present in the parent table, none of A, B, D should be inserted even though A and B are present in the parent table.

    The overarching question I have is if I can rely on table definition to drive my logic in the stored proc. I can see the pros and cons, but I wanted to see how other people's experiences are like.