troubleshooting Question

Understanding SQL SP's

Avatar of smoschkau
smoschkau asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
12 Comments1 Solution249 ViewsLast Modified:
I have a create table procedure that runs three SP's to populate it- and I am having trouble getting them to work-

I added four more columns to the table and the first SP errors out

Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

Do I need all of the coumns in each SP??
If so can I default the columns to null until there data can update properly??
Null as phys_low,
Null as phys_high,
Null as Los_low,
Null as Los_high

Can someone help me answer this??



Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros