Joseane Holz

Boa tarde, não consigo resolver o erro deste codigo, insert into tempo select convert (varchar (8), @data, 112) ID , @DATA AS DATA , year (@data) as ano , month (@data) as mes , day (@data) as dia , datepart (weekday, @data) as dia_semana; obrigada