No announcements
Found 1098105 threads
-
1 VotesSyntax error in INSERT INTO statement.
According to your description of the problem, the issue you are experiencing is there was an error in your insert into statement.Answered | 4 Replies | 2767 Views | Created by Ediza - Wednesday, August 21, 2013 2:18 AM | Last reply by Herro wong - Thursday, August 22, 2013 4:24 AM
-
4 Votes
Insert into ##tmpTable - syntax issues
Remove FROM and (), just use insert into ##tmpFrag (tblName, idxName, idxType, avgFragPercent) select ...Answered | 7 Replies | 837 Views | Created by Bassrocks27 - Tuesday, February 28, 2017 10:14 PM | Last reply by Bassrocks27 - Monday, March 6, 2017 6:55 PM -
1 Votes
Inserting from a remote db
Related link: I think that with OPENQUERY you have a better chance of the other server doing all of the work on that part of the query.Answered | 5 Replies | 5851 Views | Created by Y a h y a - Saturday, February 26, 2011 7:40 PM | Last reply by Kalman Toth - Thursday, March 3, 2011 8:55 AM -
0 Votes
constraint syntax in sql server
hi all, ADD CONSTRAINT Schema1.CK_TYPE_NAME CHECK( TYPE_NAME <> '' OR TYPE_NAME = 'INPUT' OR TYPE_NAME = 'OUTPUT' ) above query is ...Answered | 9 Replies | 5152 Views | Created by Jey-YoYo - Wednesday, January 4, 2012 10:51 AM | Last reply by Kent Waldrop - Thursday, January 5, 2012 7:22 PM -
1 Votes
Auto Increment Insert in Merge Syntax
> .. the insert part in the store procedure where I need to auto increment the value in the destination table.Answered | 7 Replies | 7057 Views | Created by Priya Bange - Monday, August 4, 2014 10:44 AM | Last reply by --CELKO-- - Monday, August 4, 2014 11:28 PM -
0 Votes
Data Getting Corrupted while inserting into SQL Server DB.
- What version of SQL Server are you using?Answered | 4 Replies | 4820 Views | Created by Naveen11 - Wednesday, April 8, 2009 8:18 PM | Last reply by Naveen11 - Thursday, April 9, 2009 2:33 PM -
1 Votes
the best way of read file and insert to DB
I think you mean that if an ID is duplicated then it never gets inserted into the database (rather than ensuring that it doesn't get inserted twice).Answered | 7 Replies | 4387 Views | Created by sakuraJP - Wednesday, October 27, 2010 3:59 AM | Last reply by Riced - Thursday, October 28, 2010 12:09 PM -
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 | 13699 Views | Created by Nik_OS - Sunday, October 28, 2007 7:35 AM | Last reply by Hieronymus Caarls - Tuesday, November 25, 2008 8:17 AM -
0 Votes
Failure To Insert To Second DB
Because, it get the data from DB B for those are not present in DB A.Answered | 9 Replies | 1374 Views | Created by w.darnellg.g - Tuesday, June 11, 2013 11:31 AM | Last reply by w.darnellg.g - Thursday, June 13, 2013 12:04 AM -
0 Votes
T-SQL Query Syntax error
There is no table T2 mentioned in first part and no Join statement which cause syntax error.Answered | 14 Replies | 2076 Views | Created by PraveenKumar_1999 - Monday, May 23, 2016 5:17 PM | Last reply by SQLNeophyte - Wednesday, May 25, 2016 5:09 AM -
0 Votes
SQL DB Growth
You will have to create a table and once a day insert into current size of all dbs + date of inserting.Answered | 1 Replies | 5441 Views | Created by VijayKSQL - Wednesday, January 5, 2011 10:26 AM | Last reply by Uri Dimant - Wednesday, January 5, 2011 10:43 AM -
0 Votes
Insert from sql
You can check documentation for INSERT to get a better understanding of the syntax:Answered | 4 Replies | 859 Views | Created by RikBrooks - Friday, October 23, 2015 1:45 PM | Last reply by Jingyang Li - Friday, October 23, 2015 3:10 PM -
3 Votes
syntax error
Both DB's are in one server indeed.Answered | 6 Replies | 1302 Views | Created by MVP_88 - Friday, May 30, 2014 8:57 AM | Last reply by MVP_88 - Friday, May 30, 2014 12:26 PM -
1 Votes
SQL Insert Into failing
You cannot use a named parameter with SQL Server OLEDB Provider (SQLOLEDB) and the OLEDB namespace library.Answered | 11 Replies | 850 Views | Created by MW2011 - Friday, January 17, 2014 1:17 PM | Last reply by Paul P Clement IV - Friday, January 17, 2014 6:46 PM -
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 | 1442 Views | Created by Mubbashir Shakil - Tuesday, February 18, 2014 5:55 AM | Last reply by Ashish Pandey - Tuesday, February 18, 2014 6:55 AM -
1 Votes
Syntax error in INSERT INTO statement (Inserting Multiple Records From GridView)
The syntax error is here (underlined): str = @"INSERT INTO Transaction(tranNo, custID, pID, userID, orderNo, sDate) VALUES ('" + ...Answered | 7 Replies | 2710 Views | Created by Akemi Chou - Wednesday, July 2, 2014 1:07 PM | Last reply by Noam B - Thursday, July 3, 2014 10:39 AM -
1 Votes
Syntax error in SQL VBA
Hi, Are you able to post a sample copy of your db for inspection?Answered | 11 Replies | 1068 Views | Created by MarcusKgosi - Thursday, July 27, 2017 1:16 PM | Last reply by .theDBguy - Wednesday, August 2, 2017 2:22 PM -
1 Votes
Update/Insert data from text file to sql server db
For your requirement to update the database, I guess you can check using a simple query if the record already exists, if so, just modify the program and instead firing the insert query, ...Answered | 6 Replies | 12201 Views | Created by Intermediate-User - Tuesday, October 30, 2012 9:50 AM | Last reply by Aarsh (MCTS) - Wednesday, October 31, 2012 2:46 PM -
0 Votes
sql server insert
what are the possible scenarios uder which an insert into sql server from an application server into sql server would not succeed.Answered | 4 Replies | 4349 Views | Created by neophytenik - Monday, July 26, 2010 7:58 PM | Last reply by Honza Novak - Tuesday, July 27, 2010 6:32 AM -
0 Votes
SQL SYNTAX ERROR WITH VB
it says syntax error before ')'.....................can u read the code or check the code?Answered | 7 Replies | 3906 Views | Created by Aorangzeb - Wednesday, June 29, 2011 10:50 AM | Last reply by Heslacher - Thursday, June 30, 2011 6:15 AM
No announcements
