SQL Server

Beware of adding columns to stored procedure results

Since INSERT INTO...EXEC requires the use of a CREATE TABLE statement with an explicit column list, adding a column to the stored procedure called by the EXEC portion will break the calling procedure. Who knew?

Syndicate content