invalid object name

[ng1426]

Hiii

I have created a database named db2

after that i created 4 tables -
1.Friends and used insert,select etc commands

2 then product_master and used insert,select ,uodate etc commands
similarly employees table and t4 table

my problem is that after inserting the records in the last table t4 when i accessed the table Friends there is an error


Msg 208, Level 16, State 1, Line 1
Invalid object name 't4'.

what to do????

help

[jkmyoung]

How are you trying to access this table? Can you access the other tables, or is t4 the only problem table?

[ng1426]

its like if i m using the query select * from employees m getting the result bt on the other hand if m using select * from t4 m getting this error

[ng1426]

only prblm is with t4 table

[jkmyoung]

Please show the code where you're creating the table. Are you getting confirmation that the table is actually created?

[ng1426]

create table Product_table(p_group varchar(20),name varchar(20),selling_price varchar(20))
insert into Product_table values('4','Britania','60')
insert into product_table values('1','head and shoulder','149')
insert into product_table values('1','Kissan','92')
select * from product_table
select * into product from product_table where 1=2
select * from product
alter table product alter column selling_price int
select * from product
insert into product (p_group,name,selling_price) select p_group,name,selling_price from product_table where p_group=1
update product set selling_price='selling_price+(5/100*selling_price)' where p_group=1
and the error is
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'selling_price+(5/100*selling_price)' to data type int.


how to resolve it

help?

[ng1426]

jkmyoung thanx for replying...dat prblm has been solved..

now m facing another prblm.i have pasted it please go through it...

[jkmyoung]

Use Cast or convert the varchar to an int, eg similar examples:

SELECT CAST(YourVarchar AS INT) FROM Product_Table
SELECT CONVERT(INT, YourVarchar) FROM Product_Table