RamsLessonsLearnt

Thursday, April 4, 2013

Compile time validation in Stored Procedure


A Stored Procedure will validate a table schema only if its present. If say a table exists and we mention an invalid column name the SP will throw error when we compile it.
But if the table itself is not present then the SP will not throw error during compilation but will throw error only during run time!
Posted by Ramachandran at 8:50 AM
Labels: SQL Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Ramachandran
A Software Professional who loves to write
View my complete profile

Blog Archive

  • ►  2021 (4)
    • ►  December (1)
    • ►  October (2)
    • ►  August (1)
  • ►  2016 (2)
    • ►  July (1)
    • ►  June (1)
  • ▼  2013 (4)
    • ▼  April (4)
      • is string IEnumerable?
      • Drop and Create Script Issue with SQL Server 2012
      • View Dependency does not work with Views
      • Compile time validation in Stored Procedure
  • ►  2012 (1)
    • ►  December (1)
  • ►  2011 (3)
    • ►  July (1)
    • ►  February (2)
  • ►  2010 (8)
    • ►  November (1)
    • ►  September (1)
    • ►  June (1)
    • ►  April (4)
    • ►  February (1)
  • ►  2009 (13)
    • ►  September (5)
    • ►  July (4)
    • ►  April (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2008 (24)
    • ►  December (7)
    • ►  October (3)
    • ►  July (3)
    • ►  June (1)
    • ►  May (1)
    • ►  April (3)
    • ►  February (3)
    • ►  January (3)
  • ►  2007 (31)
    • ►  December (4)
    • ►  November (12)
    • ►  October (1)
    • ►  September (8)
    • ►  July (6)
Simple theme. Powered by Blogger.