sql server - SQL exclude a column using SELECT * [except columnA] FROM tableA? - Stack Overflow

sql server - SQL exclude a column using SELECT * [except columnA] FROM tableA? - Stack Overflow

瀏覽:1424
日期:2026-04-23
Yes it's possible (but not recommended). CREATE TABLE contact (contactid int, name varchar(100), dob datetime) INSERT INTO contact SELECT 1, 'Joe', '1974-01-01' DECLARE @columns varchar(8000) SELECT @columns = ISNULL(@columns ......看更多