Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Insert Statement not working

Posted on 2012-03-25
2
Medium Priority
?
256 Views
Last Modified: 2012-03-25
Hi

The image below shows an insert statement that I am trying to do in SQL Server 2008,
with the related table structure on the left. I thought that it would have worked but I am getting the error shown

1
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 14

Accepted Solution

by:
nishant joshi earned 2000 total points
ID: 37763066
Hi murbro,
SQL string starts and end with single code (') not like other languages like JAVA,C#.etc.

Correct it.it will work.

Regards,
nishant
0
 

Author Closing Comment

by:Murray Brown
ID: 37763096
Thanks very much
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question