No announcements
Found 2195357 threads
-
0 VotesCorrect syntax for an UPDATE statement
Executing an Update SQL statement is sufficient, but you need to place the variables outside the quotes: Sub SortText2() Dim SearchKW As String, ReplaceKW As ...Answered | 5 Replies | 322 Views | Created by ColinMRatcliffe - Wednesday, March 8, 2017 9:10 PM | Last reply by .theDBguy - Friday, March 10, 2017 7:09 PM
-
0 Votes
Delete Statement syntax
With the proprietary DELETE FROM and UPDATE FROM syntaxes in SQL Server you can use the alias defined in the FROM clause as the target for DELETE and UPDATE clauses.Answered | 3 Replies | 875 Views | Created by Suhi100 - Saturday, November 29, 2014 10:00 PM | Last reply by Uri Dimant - Sunday, November 30, 2014 9:11 AM -
0 Votes
Syntax Error in INSERT statement
Now I haven't done sql statements or access in awhile.Answered | 3 Replies | 3235 Views | Created by tvb2727 - Wednesday, June 4, 2008 3:44 AM | Last reply by tvb2727 - Wednesday, June 4, 2008 2:17 PM -
0 Votes
Incorrect syntax near ',' on Create statement table statement
When I try to run the below statement I get Incorrect syntax error that is at the bottom.Answered | 1 Replies | 3223 Views | Created by baustin612 - Thursday, February 4, 2016 7:59 PM | Last reply by Sam Zha - Friday, February 5, 2016 7:14 AM -
2 Votes
what is a syntax error
1)An error that occurs when a program cannot understand the command that has been entered.Answered | 4 Replies | 2790 Views | Created by nyata2d - Friday, December 30, 2011 6:53 PM | Last reply by Jo Swa(K.P.Elayaraja)-MCP - Saturday, December 31, 2011 6:17 AM -
2 Votes
Syntax Error in INSERT INTO statement
Hi While writing insert statement from application you have to put it into Single Quotation Marks as below example.Answered | 2 Replies | 1225 Views | Created by Mubbashir Shakil - Tuesday, February 18, 2014 5:55 AM | Last reply by Ashish Pandey - Tuesday, February 18, 2014 6:55 AM -
0 Votes
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
Hello everyone, I need help with J#, I'm getting "SQL syntax error".Answered | 2 Replies | 13576 Views | Created by Nik_OS - Sunday, October 28, 2007 7:35 AM | Last reply by Hieronymus Caarls - Tuesday, November 25, 2008 8:17 AM -
2 Votes
problem with CASE Statement Syntax
If process type = 'Manual' Then CASE STATEMENT A ELSE CASE STATEMENT B End ...Answered | 8 Replies | 2715 Views | Created by R_i-c_h - Tuesday, November 6, 2012 3:40 PM | Last reply by R_i-c_h - Tuesday, November 6, 2012 5:22 PM -
1 Votes
Select Statement Syntax
It has what you need to create the SQLCommand and Parameters.Answered | 10 Replies | 2065 Views | Created by EladRez - Monday, September 24, 2012 4:10 AM | Last reply by Cor Ligthert - Tuesday, September 25, 2012 5:42 AM -
0 Votes
Merge statement syntax for not matched not working
If I put the INTO back it gives me a Msg 156, Level 15, State1, Line 1 Incorrect syntax near the keyword 'INTO'Answered | 9 Replies | 1792 Views | Created by kindnesshelps - Thursday, January 23, 2014 9:56 PM | Last reply by Shridhar J Joshi - Wednesday, January 29, 2014 9:09 AM -
3 Votes
syntax error in update statement
But can you explain whats the error in my code and how did putting cb.QuotePrefix="[" cb.QuoteSuffix="]" solved it.Answered | 6 Replies | 1575 Views | Created by PolarTeddy - Thursday, September 26, 2013 3:06 PM | Last reply by Paul P Clement IV - Friday, September 27, 2013 7:48 PM -
0 Votes
Syntax error
Please dont use reserved keywords as your table name this is not a good practice and this is why you got syntax error Please mark this reply as answer if it solved your ...Answered | 4 Replies | 941 Views | Created by DavidsonOtobo - Thursday, July 16, 2015 8:56 PM | Last reply by Shanky_621 - Friday, July 17, 2015 4:54 AM -
1 Votes
Syntax Error
So from a syntax point of view it works fine, but generally ppl add Recovery for clarity.Answered | 9 Replies | 1064 Views | Created by AIM28256 - Wednesday, August 6, 2014 2:00 PM | Last reply by Ahsan Kabir - Thursday, August 7, 2014 8:47 AM -
0 Votes
CASE statement syntax
@DVR_Prasad : I need to add logic to the case statement something like this in below but not sure of the syntax SET @FLAG = CASE WHEN @STATUS = ...Answered | 6 Replies | 2931 Views | Created by S Prashant - Thursday, July 21, 2011 6:17 AM | Last reply by Manoj Pandey (manub22) - Thursday, July 21, 2011 6:37 AM -
0 Votes
Basic statement but getting an Error "Incorrect syntax near the keyword 'select'
That's not valid T-SQL, that's more PL/SQL (Oracle) or MySQL syntax; use the T-SQL statement provided by Stan.Answered | 4 Replies | 5405 Views | Created by MaddyAtWork - Monday, June 6, 2016 8:45 PM | Last reply by MaddyAtWork - Tuesday, June 7, 2016 5:30 PM -
0 Votes
Syntax error
", chkActivate.Checked) Try cmd.ExecuteNonQuery() lblAlarmtime.Text = "" chkActivate.Checked ...Answered | 6 Replies | 365 Views | Created by -TwisTedfaTe- - Monday, September 12, 2016 7:17 AM | Last reply by Cor Ligthert - Monday, September 12, 2016 4:29 PM -
2 Votes
syntax error '{' ?!!
Ignoring the question of why you want an integer value that has no relation to the floating point value, you can break up your code into manageable declarations and ...Answered | 8 Replies | 2446 Views | Created by Yuri.B - Friday, September 6, 2013 8:05 PM | Last reply by Brian Muth - Friday, September 13, 2013 6:49 PM -
1 Votes
Syntax error in INSERT INTO statement.
Hello, As we can not reproduce the error you will need to tell us what the error was.Answered | 4 Replies | 575 Views | Created by Mukesh Kumar Saroy - Monday, September 21, 2015 11:21 AM | Last reply by Paul P Clement IV - Wednesday, September 23, 2015 2:15 PM -
1 Votes
BCP statement syntax incorrect
Hi i did as you said but i am still getting the same error 1.Answered | 7 Replies | 8886 Views | Created by BeeBrian - Monday, September 27, 2010 3:43 PM | Last reply by BeeBrian - Wednesday, September 29, 2010 8:31 AM -
2 Votes
Syntax error in insert into statement
Hello I'm having a problem with adding a new row into my database and saving it to the database - i'vve looked all over the internet and haven't found a ...Answered | 3 Replies | 2291 Views | Created by Visual_Mind - Thursday, July 21, 2011 9:51 PM | Last reply by Paul P Clement IV - Friday, July 22, 2011 12:59 PM
No announcements
