SQL Server Express create table
Posted on 2014-03-25
Needed a database to do some joins on lists of servers.
Downloaded MS SQL Server Express 2012.
Got my join statement to work.
Thought I could just put 'Create table' in front of it to turn the
query into a table but I get
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'select'.
So I pulled out the word 'select'
and I get
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'Change_short$'.
I could have sworn I have done this before.
but it looks like they have changed the syntax.
Like whats up with all the dollar signs?
And how do i create tables and views?
Allen in Dallas
+++++++++++++++++++join statement begin+++++++++++++++++++++
Change_short$.Name, Change_short$.[IP Address], ['Srvrs Rtrs Swtches$'].Name AS Expr1, ['Srvrs Rtrs Swtches$'].IP_Address,
['Srvrs Rtrs Swtches$'].Device_type
FROM Change_short$ right JOIN
['Srvrs Rtrs Swtches$'] ON Change_short$.[IP Address] = ['Srvrs Rtrs Swtches$'].IP_Address
+++++++++++++++++++join statement end+++++++++++++++++++++