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
script parses but errors when run
-
- 4StarLounger
- Posts: 504
- Joined: 23 Jul 2010, 18:36
- Location: Westlake, OHIO
script parses but errors when run
Who will you Inspire today?
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: script parses but errors when run
Does it make a difference if you use single quotes instead of double quotes?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 504
- Joined: 23 Jul 2010, 18:36
- Location: Westlake, OHIO