script parses but errors when run

User avatar
Timelord
4StarLounger
Posts: 504
Joined: 23 Jul 2010, 18:36
Location: Westlake, OHIO

script parses but errors when run

Post by Timelord »

I have this script
insert into [db].[floor] (id,Floor,loc,ship) values ("15","Floor 12","83","MegaMan")

When I click the Parse (ctrl-F5) button it completes correctly but when I click Execute (F5) I receive error stating
Invalid Column Name 'Floor 12'

Any help appreciated. Not a SQL scripter
Who will you Inspire today?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: script parses but errors when run

Post by HansV »

Does it make a difference if you use single quotes instead of double quotes?
Best wishes,
Hans

User avatar
Timelord
4StarLounger
Posts: 504
Joined: 23 Jul 2010, 18:36
Location: Westlake, OHIO

Re: script parses but errors when run

Post by Timelord »

That was it. Thanks Hans
Who will you Inspire today?