troubleshooting Question
Understanding SQL SP's
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??
Thanks!
Susie
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??
Thanks!
Susie
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
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.