SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’table_name’ and COLUMN_NAME in (‘column_name’,’column_name2′) OR SELECT ORDINAL_POSITION ,COLUMN_NAME ,DATA_TYPE ,CHARACTER_MAXIMUM_LENGTH ,IS_NULLABLE ,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘youtablename’ ORDER……
If you have a single select parameter but you would like to have the “Select All” option added to it here is how you can……
The problem with case statements is that usually each one takes up a row for itself and then assigns a NULL value for the next……