见鬼了，T-SQL简单的if else错误。

[duhongbo88]

 declare @TempID int
 declare @dlpl_dailiID int
 
 SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0

  begin
   INSERT INTO ny_daili(
	xxx
	)VALUES(
	@xxx
	)
   Set @dlpl_dailiID = @@IDENTITY
  end


  declare  @i int
  select   @i=1
  while   @i<=49
  
 begin
   INSERT INTO ny_dailipeilv(
    	[dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv]
    	)VALUES(
	    @dlpl_dailiID,'斑级',@i,'41'
    	)
       set   @i=@i+1         
  end

select @dlpl_dailiID

ELSE -----报ELSE附近有错误或ELSE本身错误

select 0

[-狙击手-]

declare @TempID int
 declare @dlpl_dailiID int
 
 SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0
begin
  begin
   INSERT INTO ny_daili(
    xxx
    )VALUES(
    @xxx
    )
   Set @dlpl_dailiID = @@IDENTITY
  end


  declare  @i int
  select   @i=1
  while   @i<=49
  
 begin
   INSERT INTO ny_dailipeilv(
        [dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv]
        )VALUES(
        @dlpl_dailiID,'斑级',@i,'41'
        )
       set   @i=@i+1         
  end

select @dlpl_dailiID
end
ELSE -----报ELSE附近有错误或ELSE本身错误

select 0

[-狙击手-]

declare @TempID int
 declare @dlpl_dailiID int
 
 SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0
begin  ------------------------------------ADD	  begin
	   INSERT INTO ny_daili(
	    xxx
	    )VALUES(
	    @xxx
	    )
	   Set @dlpl_dailiID = @@IDENTITY
	  end
	
	
	  declare  @i int
	  select   @i=1
	  while   @i<=49
	  
	 begin
	   INSERT INTO ny_dailipeilv(
	        [dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv]
	        )VALUES(
	        @dlpl_dailiID,'斑级',@i,'41'
	        )
	       set   @i=@i+1         
	  end
	
	select @dlpl_dailiID
end      ---------------------------------------ADD
ELSE -----报ELSE附近有错误或ELSE本身错误

select 0

[-狙击手-]

declare @TempID int
declare @dlpl_dailiID int

SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0
begin ------------------------------------ADD
begin
INSERT INTO ny_daili(
xxx
)VALUES(
@xxx
)
Set @dlpl_dailiID = @@IDENTITY
end


declare @i int
select @i=1
while @i<=49

begin
INSERT INTO ny_dailipeilv(
[dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv]
)VALUES(
@dlpl_dailiID,'斑级',@i,'41'
)
set @i=@i+1
end

select @dlpl_dailiID
end ---------------------------------------ADD
ELSE -----报ELSE附近有错误或ELSE本身错误

select 0

[lhsxsh]

语法错了吧

[wzy_love_sly]

select @dlpl_dailiID
写在end里

if
begin
语句
end
别断开
else
begin
语句
end

[duhongbo88]

汗,,,,这么简单,郁闷

[pt1314917]

declare @TempID int
declare @dlpl_dailiID int
 
SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0
begin
	INSERT INTO ny_daili(xxx)VALUES(@xxx)
	Set @dlpl_dailiID = @@IDENTITY

	declare  @i int
	select   @i=1
	while   @i<=49
	begin
 		INSERT INTO ny_dailipeilv([dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv])VALUES(@dlpl_dailiID,'斑级',@i,'41' )
 		set   @i=@i+1         
	end
	select @dlpl_dailiID
end
ELSE 
select 0

[dawugui]

declare @TempID int
declare @dlpl_dailiID int
 
SELECT @TempID = count(1) FROM ny_daili WHERE dl_mima=@dl_mima
IF @TempID = 0
begin
  begin
   INSERT INTO ny_daili(
    xxx
    )VALUES(
    @xxx
    )
   Set @dlpl_dailiID = @@IDENTITY
  end

  declare  @i int
  select   @i=1
  while   @i<=49
  
 begin
   INSERT INTO ny_dailipeilv(
        [dlpl_dailiID],[dlpl_leibie],[dlpl_mingcheng],[dlpl_peilv]
        )VALUES(
        @dlpl_dailiID,'斑级',@i,'41'
        )
       set   @i=@i+1         
  end

select @dlpl_dailiID
end
ELSE -----报ELSE附近有错误或ELSE本身错误
begin
  ............
end

select 0