No announcements
Found 1098103 threads
-
10 Votesc# sql INSERT INTO syntax error
The code I provided was an example of the methodology to use but as I haven't seen the SQL table you're using I can't be sure the command was correct.Answered | 10 Replies | 6120 Views | Created by gidiszanton - Friday, May 11, 2012 2:00 PM | Last reply by Nick_Sandel - Monday, May 14, 2012 8:13 AM
-
1 Votes
insert into sql db using c#
E.g. something like: string commandText = "INSERT INTO [Record] ( [Name], [Marks]) VALUES (@Name, @Marks);"; using (SqlConnection connection = new ...Answered | 3 Replies | 8440 Views | Created by mkool92 - Monday, February 25, 2013 8:23 AM | Last reply by Stefan Hoffmann - Monday, February 25, 2013 9:33 AM -
0 Votes
Insert Into Syntax Error?
"The OLE DB .NET Provider does not support named parameters for passing parameters to an SQL statement or a stored procedure called by an OleDbCommand when ...Answered | 2 Replies | 3722 Views | Created by MaryPoppins - Friday, June 27, 2008 7:05 PM | Last reply by c_jensen - Friday, June 27, 2008 10:16 PM -
1 Votes
Error in syntax INSERT INTO
But adding a DELETE or INSERT will not be accepted by Jet/ACE.Answered | 12 Replies | 3731 Views | Created by l3elivE - Friday, August 3, 2012 5:47 PM | Last reply by BonnieB - Sunday, August 5, 2012 3:30 PM -
0 Votes
Insert Into Statement Syntax error
The error message says Run-time Error '3134': Syntax error into Insert Into Statement.Answered | 2 Replies | 5028 Views | Created by Christnia Glabas - Monday, August 9, 2010 6:22 PM | Last reply by Christnia Glabas - Monday, August 9, 2010 6:33 PM -
0 Votes
how To Insert Video File In DB Sql server
Hi, Here I got a reference for inserting vdo files into SQL DB.Answered | 5 Replies | 8653 Views | Created by KhaLeeL ZoURoB - Monday, October 25, 2010 7:16 PM | Last reply by .Net Qwery - Tuesday, November 29, 2011 3:50 PM -
1 Votes
Syntax error in INSERT INTO statement.
The fact is that the command builder if a key word is inserted as a field it creates an insert command that contains this key word ("Date" for this ...Answered | 6 Replies | 2295 Views | Created by Nikolaos Hatzistelios - Thursday, September 13, 2012 5:44 PM | Last reply by Bob1201 - Friday, December 18, 2015 2:56 AM -
0 Votes
Syntax for insert into within sp
Why to use dynamic sql to do this?Answered | 3 Replies | 4225 Views | Created by Frans Mientjes - Sunday, November 8, 2009 9:19 PM | Last reply by Frans Mientjes - Sunday, November 8, 2009 10:24 PM -
3 Votes
Syntax error in INSERT INTO statement.
Building SQL statements in this way is a SQL injection vulnerabilty.Answered | 2 Replies | 794 Views | Created by ManaliAcharya - Friday, December 11, 2015 6:00 AM | Last reply by Paul P Clement IV - Friday, December 11, 2015 1:37 PM -
4 Votes
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement
So, you must enclose it in square brackets: OleDbCommand cmd = new OleDbCommand("INSERT INTO Registration_Details (FirstName, LastName, UserName, [Password], Country, ...Answered | 4 Replies | 16368 Views | Created by KHtet - Monday, February 20, 2012 6:49 PM | Last reply by MayankN - Sunday, October 13, 2013 7:29 AM -
0 Votes
INSERT INTO syntax
I'd suggest it would be better to spcify the colums Insert Into Table1 (col1, col2, col3) Select col1, col2, col3 ...Answered | 5 Replies | 1466 Views | Created by Ryan_XH - Thursday, February 14, 2013 3:02 PM | Last reply by Rui Travassos - Thursday, February 14, 2013 3:14 PM -
0 Votes
Why do I get a Syntax errror with the following command for an OLE DB destination Insert into ....
However for each loadnumber/row I need find all units that are linked to that load number and insert 1 row per unit into 1 target table ( so for 1 row comming out of the ...Answered | 4 Replies | 5083 Views | Created by Alexis M Coles - Thursday, June 10, 2010 5:02 PM | Last reply by Charles Wang - MSFT - Monday, June 14, 2010 10:14 AM -
0 Votes
Syntax Error in INSERT INTO Statement (Insert Records)
Hi Akemi, Are you trying to insert a record into an Access database table?Answered | 4 Replies | 741 Views | Created by Akemi Chou - Tuesday, July 1, 2014 4:28 PM | Last reply by Caillen - Wednesday, July 2, 2014 6:17 AM -
2 Votes
C# Syntax Error - INSERT INTO statement
Bracket that field name to avoid confusing the db engine.Answered | 10 Replies | 5407 Views | Created by Brandelis - Wednesday, May 13, 2015 11:45 PM | Last reply by Brandelis - Saturday, May 23, 2015 8:46 AM -
0 Votes
Inserting a List<string> into a sql server compact db
But SQL Server Compact is quite limited, it doesn't supports table value parameters or stored procedures (and much more): Differences Between SQL Server Compact ...Answered | 8 Replies | 4053 Views | Created by Joesoft11a - Monday, December 2, 2013 6:00 PM | Last reply by Joesoft11a - Tuesday, December 3, 2013 1:14 AM -
1 Votes
T-SQL: OUTPUT CLAUSE with INSERT/SELECT on IDENTITY -- syntax error
Check the syntax for the output clause in the following ...Answered | 3 Replies | 3728 Views | Created by plditallo - Tuesday, October 9, 2012 3:59 PM | Last reply by plditallo - Tuesday, October 9, 2012 4:48 PM -
1 Votes
Linq to SQL Method syntax
Method syntax vs query syntax?Answered | 4 Replies | 6977 Views | Created by crew54 - Thursday, September 9, 2010 8:48 PM | Last reply by KristoferA - Thursday, September 16, 2010 12:53 AM -
2 Votes
Incorrect syntax for IF EXISTS sql
INSERT has 9 columns but you have 10 parameter markers.Answered | 4 Replies | 1140 Views | Created by JeffKu - Thursday, July 2, 2015 1:20 AM | Last reply by JeffKu - Thursday, July 2, 2015 3:24 PM -
1 Votes
Insert data to db.
Cool tools for Linq-to-SQL and Entity Framework: huagati.com/dbmltools (add-in with new features for the L2S and EF designers in VS2008 and ...Answered | 2 Replies | 4386 Views | Created by kert84 - Sunday, July 4, 2010 10:07 AM | Last reply by kert84 - Monday, July 5, 2010 6:43 AM -
3 Votes
Syntax Error in Insert Into Statement
We would need to see the table column names of your INSERT statement to make sure you are not using any SQL reserved words.Answered | 6 Replies | 2266 Views | Created by sivavi - Wednesday, July 20, 2011 11:59 AM | Last reply by Heslacher - Wednesday, July 20, 2011 1:23 PM - Items 1 to 20 of 1098103 Next ›
No announcements
