LeauematchesList_id 仅仅只有一条记录? 那好象看不出什么问题。如果是多个那就要: delete Team where Team_id = @Team_id and Team_name = @Team_name and LeagueMatchesList_id in (SELECT LeagueMatchesList_id FROM LeagueMatchesList WHERE LeagueMatchesList_name = @LeagueMatchesList_Name)
那好象看不出什么问题。如果是多个那就要:
delete Team where Team_id = @Team_id and Team_name = @Team_name and LeagueMatchesList_id in (SELECT LeagueMatchesList_id FROM LeagueMatchesList WHERE LeagueMatchesList_name = @LeagueMatchesList_Name)
是准一的可以:
delete @leagueMatchesList_id varchar(40)
SELECT @leagueMatchesList_id =LeagueMatchesList_id FROM LeagueMatchesList WHERE LeagueMatchesList_name = @LeagueMatchesList_Name