\nOne last SQL syntax post for the evening…\n<\/p>\n
\nWe've all heard about SQL Server 2008 row constructors. They allow syntax like this to work:\n<\/p>\n
\nCREATE TABLE name_table (name varchar(20), age int);
\ngo
\nINSERT INTO name_table VALUES ('Bob', 54), ('Mary', 30), ('Sam', 15), ('Buddy', 9);
\ngo\n<\/p>\n
\nBut how about using them as a table source:\n<\/p>\n
\nSELECT n.name, n.age, tab.species
\nFROM name_table n
\nJOIN
\n(
\n VALUES ('Bob', 'person'), ('Mary', 'person'), ('Sam', 'cat'), ('Buddy', 'cat')
\n) tab (name, species)
\nON n.name = tab.name;\n<\/p>\n
\nYou specify a table alias and name the columns, and its just another (synthesized on the fly) table.<\/p>\n","protected":false},"excerpt":{"rendered":"
One last SQL syntax post for the evening… We've all heard about SQL Server 2008 row constructors. They allow syntax like this to work: CREATE TABLE name_table (name varchar(20), age int); go INSERT INTO name_table VALUES ('Bob', 54), ('Mary', 30), ('Sam', 15), ('Buddy', 9); go But how about using them as a table source: SELECT […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,40],"tags":[],"class_list":["post-730","post","type-post","status-publish","format-standard","hentry","category-sql-server-2008","category-transact-sql"],"yoast_head":"\n