No announcements
Found 1720960 threads
-
1 Votes
Syntax error in UPDATE statement
Hello, I would suggest taking time to learn SQL and better methods to setup SQL statements in your code.Answered | 5 Replies | 2127 Views | Created by Joenel - Saturday, February 16, 2013 4:58 AM | Last reply by Cor Ligthert - Saturday, February 16, 2013 12:09 PM -
1 Votes
Update Statement syntax error
And a space is missing, but that I wrote already in the never replied threadAnswered | 2 Replies | 421 Views | Created by Mir Ahmad Raza Nadem - Friday, September 12, 2014 7:24 AM | Last reply by Cor Ligthert - Friday, September 12, 2014 10:02 AM -
0 Votes
Update Statement Run Error
If I do not add cast to my update I get an error of - the data type text and varchar are incompatible in the equal to operator.Answered | 10 Replies | 746 Views | Created by HotWildWetSlides - Thursday, October 1, 2015 11:55 PM | Last reply by Jingyang Li - Friday, October 2, 2015 6:44 PM -
0 Votes
Update Set statement error
Your error is in the SQL transact, put for instance a space behind @confirmRamZ, (before the double quote)Success CorAnswered | 2 Replies | 462 Views | Created by Mir Ahmad Raza Nadem - Sunday, September 7, 2014 6:44 PM | Last reply by Chris Dunaway - Monday, September 8, 2014 9:47 PM -
1 Votes
Syntax error in UPDATE statement
There could be a difference in SQL syntax parsing, although I have yet to see your SQL update statement.Answered | 17 Replies | 5034 Views | Created by jbhII - Thursday, September 1, 2011 4:19 PM | Last reply by Paul P Clement IV - Friday, September 16, 2011 1:28 PM -
0 Votes
Syntax error in UPDATE statement.
You can use Enmanuel's example (that should be @CustomerID in the SQL statement) or use question marks as parameter placeholders (as in the UPDATE example SQL statement).Answered | 29 Replies | 4908 Views | Created by StOPpER's - Monday, October 18, 2010 3:40 PM | Last reply by StOPpER's - Tuesday, October 26, 2010 2:44 AM -
2 Votes
Syntax error in UPDATE statement
Also try the next variant: Dim UpdateQuery = "UPDATE Employee SET FirstName=@FirstName, LastName=@LastName, Position= @Position, Salary=@Salary ...Answered | 6 Replies | 555 Views | Created by TYPE O-NEGATIVE - Tuesday, May 5, 2015 12:10 AM | Last reply by Magnus (MM8) - Tuesday, May 5, 2015 10:24 AM -
0 Votes
Error in Update Statement
I also noticed a missing single quote in your statement.Answered | 3 Replies | 4315 Views | Created by adurs - Saturday, February 27, 2010 8:18 PM | Last reply by Naomi N - Sunday, February 28, 2010 4:25 AM -
0 Votes
Syntax error in UPDATE statement.
I found where i did the mistake...now this is working cmd = New OleDBCommand("UPDATE `user` SET `Password` ...Answered | 4 Replies | 501 Views | Created by Atif143 - Friday, August 8, 2014 11:51 AM | Last reply by Atif143 - Friday, August 8, 2014 2:41 PM -
0 Votes
Syntax error in update statement
Thanx a lot for helping me Dan Sir... it will be very helpful to write parameterized query, i'll try it ...but as Sir Paul P Clement adviced i made changes and i have solved the error...the ...Answered | 5 Replies | 4006 Views | Created by Abhijeet01 - Monday, November 28, 2011 2:58 PM | Last reply by Allen_MSDN - Wednesday, November 30, 2011 2:17 AM -
6 Votes
update statement with 512 error
If I used the select max, then the records returned updated with the wrong patient_id.Answered | 8 Replies | 1991 Views | Created by Sally Lue - Friday, August 2, 2013 11:14 PM | Last reply by Olaf Helper - Monday, August 5, 2013 7:09 PM -
0 Votes
Strange update statement error
As Hugo mentioned, the error you listed is not possible from an UPDATE statement alone.Answered | 8 Replies | 3621 Views | Created by hollykilpatrick - Tuesday, December 15, 2009 1:16 PM | Last reply by Naomi N - Tuesday, December 15, 2009 2:30 PM -
2 Votes
UPDATE Statement
;WITH mycte AS (SELECT SS.DateID, dt.ID FROM dbo.STG_SPACE ss LEFT JOIN dbo.DIM_TIME dt ON DT.PK_Date = ...Answered | 3 Replies | 1266 Views | Created by thinkingeye - Monday, January 28, 2013 6:45 PM | Last reply by Jingyang Li - Monday, January 28, 2013 10:21 PM -
0 Votes
update statement pulling up errors :(
Hi, i am trying to change the appointment time for a given appointment however it keeps pulling up errors such as 'time must be set to on or off' and 'unknown command where ...Answered | 2 Replies | 986 Views | Created by Tommy LeFart - Monday, May 13, 2013 6:43 PM | Last reply by Rahul Kumar (Rahul Vairagi) - Monday, May 13, 2013 7:09 PM -
1 Votes
update statement
HI naomi yup period_ID will get value once is updated it is new cloumn in existing table which being updated it is null now select statement depend how many rows i am ...Answered | 12 Replies | 5096 Views | Created by banty1 - Monday, May 23, 2011 1:01 PM | Last reply by Naomi N - Monday, May 23, 2011 6:30 PM -
0 Votes
Update with an If Statement
You can also use CASE statement.Answered | 3 Replies | 6923 Views | Created by Andy0927 - Thursday, August 12, 2010 2:53 PM | Last reply by Atif-ullah Sheikh - Friday, August 13, 2010 8:02 AM -
2 Votes
Update statement fails?
Your post made me look into other parts of my code, and I think I found the error.Answered | 4 Replies | 3909 Views | Created by Tore572 - Sunday, January 2, 2011 4:11 PM | Last reply by Tore572 - Sunday, January 2, 2011 11:34 PM -
0 Votes
CASE statement in a JOIN\UPDATE statement
You can combine these two using a CASE statement as shown below.Answered | 1 Replies | 1382 Views | Created by edm2 - Thursday, September 19, 2013 1:58 AM | Last reply by cruellogic - Thursday, September 19, 2013 3:07 AM -
0 Votes
Turn SELECT statement into UPDATE statement
I have always found SQL Server's UPDATE ..Answered | 6 Replies | 1591 Views | Created by IndigoMontoya - Sunday, February 17, 2013 9:52 PM | Last reply by IndigoMontoya - Monday, February 18, 2013 3:32 AM -
0 Votes
update statement
Can you try Update Management_Attendee SET [attendee1] = @attendee1 where ManagementID = 24 and attendee='tester' Are you looking to update min id or the ...Answered | 1 Replies | 881 Views | Created by emaak - Wednesday, September 10, 2014 3:25 PM | Last reply by Prashanth Jayaram - Wednesday, September 10, 2014 3:29 PM - Items 1 to 20 of 1720960 Next ›
No announcements