The error is self-explanatory – you cannot issue a CREATE PROCEDURE
statement unless it’s the only statement in the batch.
In SSMS the GO
keyword splits the statement into separate batches, so you need to add one after the statement before the CREATE PROCEDURE
:
create table josecustomer( name varchar(50), address varchar(300), ssnid int, balance bigint, accountnumber bigint ) insert into josecustomer values('Aman','Canada',10000,5000,100000000) insert into josecustomer values('Shubham','USA',10001,6000,200000000) insert into josecustomer values('Himanshu','Australia',10002,2000,300000000) insert into josecustomer values('Jose','India',10003,3000,400000000) insert into josecustomer values('Albert','Brazil',10004,4000,500000000) insert into josecustomer values('Peterson','Germany',10005,7000,600000000) insert into josecustomer values('Adam','Honkong',10006,8000,700000000) insert into josecustomer values('William','Paris',10007,9000,800000000) select * from josecustomer Go --Add a Go here create proc sp_joseview as begin select * from josecustomer end go create proc sp_updatejose (@accountno bigint,@newbalance bigint) as begin update josecustomer set balance=@newbalance where accountnumber=@accountno end go