SQL 2008 事务操作，变量写哪里

Question

--删除学生信息declare @tran_name varchar(30),@StuId char(10)
select @tran_name = 'students_delete'
@StuId = '2010121009' 
begin tran @tran_namego
delete from dbo.Students where dbo.Students.cStudentsId = @StuId
go
delete from dbo.StudentsSchool where dbo.StudentsSchool.cStudentsId = @StuId
go
delete from dbo.StuSchoolRewardPunish where dbo.StuSchoolRewardPunish.cStudentsId = @StuId
go 
delete from dbo.Stuusers where dbo.Stuusers.cStudentsId = @StuId
go 
delete from dbo.StudentContact where dbo.StudentContact.cStudentsId = @StuId
go 
delete from dbo.ApplyJobInformation where dbo.ApplyJobInformation.cStudentsId = @StuId
go 
delete from dbo.Education where dbo.Education.cStudentsId = @StuId
go 
delete from dbo.IntroduceYourself where dbo.IntroduceYourself.cStudentsId =--删除学生信息declare @tran_name varchar(30),@StuId char(10)
select @tran_name = 'students_delete'
@StuId = '2010121009' 
begin tran @tran_namego
delete from dbo.Students where dbo.Students.cStudentsId = @StuId
go
delete from dbo.StudentsSchool where dbo.StudentsSchool.cStudentsId = @StuId
go
delete from dbo.StuSchoolRewardPunish where dbo.StuSchoolRewardPunish.cStudentsId = @StuId
go 
delete from dbo.Stuusers where dbo.Stuusers.cStudentsId = @StuId
go 
delete from dbo.StudentContact where dbo.StudentContact.cStudentsId = @StuId
go 
delete from dbo.ApplyJobInformation where dbo.ApplyJobInformation.cStudentsId = @StuId
go 
delete from dbo.Education where dbo.Education.cStudentsId = @StuId
go 
delete from dbo.IntroduceYourself where dbo.IntroduceYourself.cStudentsId = @StuId
go
commite tran 'students_delete'go
commite tran 'students_delete'
各位，我要删除--删除学生信息declare @tran_name varchar(30),@StuId char(10)
select @tran_name = 'students_delete'
@StuId = '2010121009' 
begin tran @tran_namego
delete from dbo.Students where dbo.Students.cStudentsId = @StuId
go
delete from dbo.StudentsSchool where dbo.StudentsSchool.cStudentsId = @StuId
go
delete from dbo.StuSchoolRewardPunish where dbo.StuSchoolRewardPunish.cStudentsId = @StuId
go 
delete from dbo.Stuusers where dbo.Stuusers.cStudentsId = @StuId
go 
delete from dbo.StudentContact where dbo.StudentContact.cStudentsId = @StuId
go 
delete from dbo.ApplyJobInformation where dbo.ApplyJobInformation.cStudentsId = @StuId
go 
delete from dbo.Education where dbo.Education.cStudentsId = @StuId
go 
delete from dbo.IntroduceYourself where dbo.IntroduceYourself.cStudentsId = @StuId
go
commite tran 'students_delete'各位， 我要删除 @StuId ＝ 2010121009的所有表中有关的行记录，但是执行的时候老是有 @StuId没有声明，那么声明该写在哪里呢，谢谢，各位高手指点一二

Answer 1

抱歉，我多贴了一遍，其实应该是这样的问题
declare @tran_name varchar(30),@StuId char(10)
select @tran_name = 'students_delete'
@StuId = '2010121009'  
begin tran @tran_namego
delete from dbo.Students where dbo.Students.cStudentsId = @StuId
go
delete from dbo.StudentsSchool where dbo.StudentsSchool.cStudentsId = @StuId
go
delete from dbo.StuSchoolRewardPunish where dbo.StuSchoolRewardPunish.cStudentsId = @StuId
go  
delete from dbo.Stuusers where dbo.Stuusers.cStudentsId = @StuId
go  
delete from dbo.StudentContact where dbo.StudentContact.cStudentsId = @StuId
go  
delete from dbo.ApplyJobInformation where dbo.ApplyJobInformation.cStudentsId = @StuId
go  
delete from dbo.Education where dbo.Education.cStudentsId = @StuId
go  
delete from dbo.IntroduceYourself where dbo.IntroduceYourself.cStudentsId = @StuId
go
commite tran 'students_delete'各位， 我要删除 @StuId ＝ 2010121009的所有表中有关的行记录，但是执行的时候老是有 @StuId没有声明，那么声明该写在哪里呢，谢谢，各位高手指点一二

Answer 2

declare @tran_name varchar(30),@StuId char(10)
select @tran_name = 'students_delete'
@StuId = '2010121009'   
begin tran @tran_namedelete from dbo.Students where dbo.Students.cStudentsId = @StuIddelete from dbo.StudentsSchool where dbo.StudentsSchool.cStudentsId = @StuIddelete from dbo.StuSchoolRewardPunish where dbo.StuSchoolRewardPunish.cStudentsId = @StuId
 
delete from dbo.Stuusers where dbo.Stuusers.cStudentsId = @StuId
 
delete from dbo.StudentContact where dbo.StudentContact.cStudentsId = @StuIddelete from dbo.ApplyJobInformation where dbo.ApplyJobInformation.cStudentsId = @StuIddelete from dbo.Education where dbo.Education.cStudentsId = @StuIddelete from dbo.IntroduceYourself where dbo.IntroduceYourself.cStudentsId = @StuIdcommite tran 'students_delete'

Answer 3

去掉 go这一段放在最后删除delete from dbo.Students where dbo.Students.cStudentsId = @StuId--
变量只在一个批次时有效 go是分批次

Answer 4

GO是表示一个批的结束 如果使用了GO 那么就表示这个批次结束 所以出问题
把GO 去掉就没问题了