Unable to execute SQL Query Error : Msg 2714, Level 16, State 6, Line 2 There is already an object named 'Emp' in the database

user_5361975 0
Viewed 25263

enter image description here

use mydatabase 
create table Emp(EmpNo int primary key,EmpName varchar(max),Salary money)
select * from Emp
insert into Emp values(111,'rama',1000)

Unable to execute SQL Query Error : Msg 2714, Level 16, State 6, Line 2 There is already an object named 'Emp' in the database.

sql-server
3 Answers

This is very simple

  1. first please click on the database name you create example if the name of the data base you create is Bill payment then click on the Bill payment;

  2. then Programmability;

  3. and then press on stored procedure;

  4. then press on the above NEW QUERY.

user_145358470
Related