begin if @F=@B insert into ... else begin if @F=@C insert into ... else insert into ... end end
create PROCEDURE [dbo].[K_means_2] as declare @B float,@C float,@D float,@F float; begin if @F=@B insert into new_table values(1,2) else if @F=@Cinsert into new_table values (3,5); else @F=@D insert into new_table values (8,5); end go
create PROCEDURE [dbo].[K_means_2] as begin declare @B float,@C float,@D float,@F float;
if @F=@B insert into new_table values(1,2) else begin if @F=@C insert into new_table values (3,5) else if @F=@D insert into new_table values (8,5) end end
CREATE PROCEDURE [dbo].[K_means_2] AS DECLARE @B FLOAT , @C FLOAT , @D FLOAT , @F FLOAT SET @b = 0 SET @c = 0 SET @d = 0 SET @f = 0 BEGIN IF @F = @B INSERT INTO new_table VALUES ( 1, 2 ) ELSE IF @F = @C INSERT INTO new_table VALUES ( 3, 5 ) ; ELSE IF @F = @D INSERT INTO new_table VALUES ( 8, 5 ) ; END go
if @F=@B
insert into ...
else
begin
if @F=@C
insert into ...
else
insert into ...
end
end
as
declare @B float,@C float,@D float,@F float;
begin
if @F=@B
insert into new_table values(1,2)
else if @F=@Cinsert into new_table values (3,5);
else @F=@D
insert into new_table values (8,5);
end
go
as
begin
declare @B float,@C float,@D float,@F float;
if @F=@B
insert into new_table values(1,2)
else
begin
if @F=@C
insert into new_table values (3,5)
else
if @F=@D
insert into new_table values (8,5)
end
end
AS
DECLARE @B FLOAT ,
@C FLOAT ,
@D FLOAT ,
@F FLOAT
SET @b = 0
SET @c = 0
SET @d = 0
SET @f = 0
BEGIN
IF @F = @B
INSERT INTO new_table
VALUES ( 1, 2 )
ELSE
IF @F = @C
INSERT INTO new_table
VALUES ( 3, 5 ) ;
ELSE
IF @F = @D
INSERT INTO new_table
VALUES ( 8, 5 ) ;
END
go