alter procedure p
as
begin

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp

create table #tmp(id int)

insert into #tmp
values(1,1,1)

select * from #tmp
where p.i.i.i.i.i.i.i = 1

end;

USE [DevsEF]

GO

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp
GO
create table #tmp(id int)

SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[p]
as
begin

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp

create table #tmp(i1 int, i2 int, i3 int)

insert into #tmp
values(1,1,1)


end;

сообщение: 213, уровень: 16, состояние: 1, процедура: p, строка: 10 [строка начала пакета: 10]
Column name or number of supplied values does not match table definition.

Время выполнения: 2021-02-09T21:53:42.9649379+02:00