set identity_insert aaa on

insert into mytab(id, name) values (1,'fred')

insert into mytab(id, name) values (2,'sam')

insert into mytab(id,name) select custid, name from customer

set identity_insert aaa off

1) You need to specify the column...

I had an experience where the performance was much worse with a UDF. I was summarizing values in a table with several million rows and was using a UDF in...