Sometimes a table has all the fields you need and sometimes it doesn’t. I sometimes need to create flag fields or summary fields to hold additional information. So here are the methods I use.<\/p>\n
Add a 1 char flag field Add several columns using alter Summary field Concatenated field Syntax may vary slightly depending on database.<\/p>\n","protected":false},"excerpt":{"rendered":" Sometimes a table has all the fields you need and sometimes it doesn’t. I sometimes need to create flag fields or summary fields to hold additional information. So here are the methods I use. Add a 1 char flag field … Continue reading
\nselect *, ' ' as myflag from table...<\/code>
\n
\nAdd a column with more than one character or a data type
\nselect *, cast('' as varchar(10)) as mytextfield, cast('' as datetime) as mydatefield from table...<\/code><\/p>\n
\nSelect * into #mytemptable from table...
\nAlter table #mytemptable
\nAdd ( col1 varchar(10) null,
\ncol2 datetime null,
\ncol3 int null,
\ncol4 char(1) null
\n)<\/code><\/p>\n
\nselect units, price, unitsxprice as extended price from table...<\/code><\/p>\n
\nselect firstname+\" \"+lastname as name from table...<\/code><\/p>\n