| Author |
Topic |
|
louiedogg418
Starting Member
28 Posts |
 Posted - 2011-04-15 : 13:30:32
|
| this is my codeinsert into Employee(Emp_id,first_name, Last_name, Phys_add, City, State, Area_code, Tel_num, Emp_EEO, Hire_date, Sal, Sex, Age,Job_id) values(1,'Glenn','Edelman','175 Bishop Lane','La Jolla','California','619','555-0199','Sales Workers','10/7/2003','21500.00','M','64','4'),(2,'Eric', 'McMullen','763 Church Street', 'Lemon Grove', 'California','619', '555-0135', 'Sales Workers', '11/1/2002', '13500.00', 'M', '20','3'),(3,'Raj','Slentz','123 Torrey Drive','North Clairmont','California','619','555-0123','Officials and Managers','6/1/2000','48000.00','M','34','2'),(4,'Erin','Broun','2045 Parkway Apt 2B','Encinitas','California','760','555-0100','Sales Workers','3/12/2003','10530.00','F','24','3'),(5,'Donald','Carpenter','927 Second Street','Encinitas','California','760','555-0154','Office/Clerical','11/1/2003','15000.00','M','18','9'),(6,'David','Esquivez','10983 North Coast Hwy Apt 902','Encinitas','California','619','555-0108','Operatves','7/25/2003','18500.00','M','25','8'),(7,'Nancy','Sharp','10793 Montecino Road','Romona','California','858','555-0135','Sales Workers','7/12/2003','21000.00','F','24','4'),(8,'Juanita','McNamara','923 Parkway','Loway','California','619','555-0200','Office/Clercial','10/29/1999','25500.00','F','32','1')but i keep getting Msg 207, Level 16, State 1, Line 1Invalid column name 'Job_id'.Msg 207, Level 16, State 1, Line 1Invalid column name 'Job_id'.What the hells is going on!? it looks fine to me? here is the table create code create table Employee(Emp_id int primary key,First_name char (25), Last_name char (50),Phys_add char(75),City char (25),State char (20),Area_code char (3),Tel_num char (8),Emp_EEO char (25),Hire_date char (15),Sal dec (15,2),Sex char (1),Age char (3),Job_id int)Create table Job_Title (Job_id int primary key,Emp_EEO char (50),Job_title char (50),Job_dis char(256),Exempt_stat char (10)) |
|
|
louiedogg418
Starting Member
28 Posts |
Posted - 2011-04-15 : 13:33:02
|
| here is job_title codeinsert into Job_Title(Job_id,Emp_EEO, Job_title, Job_dis,Exempt_stat)values(1,'Office/Clercial','Accounting','Maintains Accoutning Records','Non-Exempt'),(2,'Officials/Managers','Assistant Manager','Assists store manager in daily operations of store','Exempt'),(3,'Sales Workers','Baggers','Places customer orders in bags','Non-Exempt'),(4,'Sales Workers','Cashier','Operates cash register','Non-Exempt'),(5,'Technician','Computer Support Specialist','provides technical assistance and training to systemusers','Non-exempt'),(6,'Officials/Managers','Dir. of Finance/Acc','Directs Finances and accounting','Exempt'),(7,'Craft Workers','Asst. bakery/pastry','prepares food items','Non-exempt'),(8, 'Oppertative','Asst. Butcher','prepares food items','Non-Exempt'),(9, 'Office/Clercial','Stocker','Stores, prices and restocks merchandise','Non-Exepmt') |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-04-15 : 13:38:46
|
| Hmmm, it works for me! No errors when I ran it.JimEveryday I learn something that somebody else already knew |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-15 : 13:42:20
|
Is it sql server 2008?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
louiedogg418
Starting Member
28 Posts |
Posted - 2011-04-15 : 14:12:13
|
| yea it is sql server 2008.... thats odd, i keep getting the error...Im going to just delete the database and start a new one... this happened to me before.... I just did a windows update, wonder if that has any thing to do with it? |
|
|
|
louiedogg418
Starting Member
28 Posts |
Posted - 2011-04-15 : 14:23:55
|
| now it works... seriously dont understand why creating a whole new database and deleting the old but just copying the code would fix this? |
|
|
|
|
|
|
Error 102 but everything looks right?!