No announcements
Found 3219554 threads
-
2 VotesHow to write insert query in vb code in msaccess2010
Here is one way to do it: http://www.codeproject.com/Articles/26801/Insert-Update-Delete-Search-Values-in-MS-Access-20 This looks ...Answered | 3 Replies | 1631 Views | Created by WhiteSmile - Wednesday, January 2, 2013 6:50 AM | Last reply by Dummy yoyo - Wednesday, January 16, 2013 6:54 AM
-
0 Votes
How to write sql query to insert values
Typically when you get the static data in a list that can be pasted to SQL with relative ease, it is much quicker to define formula to create sql insert statements without ...Answered | 11 Replies | 4445 Views | Created by Dr.X1987 - Sunday, July 17, 2011 6:11 PM | Last reply by Dr.X1987 - Monday, July 18, 2011 5:12 PM -
0 Votes
how to insert long query
Dim strings(59) As String 'set values of the 60 array elements Dim allStrings As String = String.Join(", ", strings)Answered | 4 Replies | 538 Views | Created by Phularwan - Saturday, February 28, 2015 7:33 AM | Last reply by Blackwood - Saturday, February 28, 2015 2:10 PM -
3 Votes
SQL Query vs VB Query
Hi alltaken, jwavilla has already given a detailed explanation to SQL Query and VB.Answered | 2 Replies | 5910 Views | Created by alltaken - Thursday, April 7, 2011 10:28 PM | Last reply by Kee Poppy - Tuesday, April 12, 2011 6:23 AM -
2 Votes
VB.Net Error in insert query
It turns out, we needed square brackets around a couple of boolean columns in the insert query.Answered | 11 Replies | 3011 Views | Created by Saqib Ilyas - Saturday, July 23, 2011 11:19 AM | Last reply by Saqib Ilyas - Wednesday, July 27, 2011 7:34 PM -
1 Votes
How to write this query string
If you believe that writing bullet proof code is unnecessary, you might want to reconsider your programming ethics.Answered | 12 Replies | 4425 Views | Created by truelyli - Monday, November 16, 2009 6:12 PM | Last reply by truelyli - Friday, November 20, 2009 4:43 PM -
1 Votes
How to write this query please
If you know how, follow ISO-11179 data element naming conventions and formatting rules.Answered | 2 Replies | 2551 Views | Created by midway11 - Friday, October 14, 2011 1:09 AM | Last reply by --CELKO-- - Friday, October 14, 2011 2:27 AM -
1 Votes
How to write a custom class in VB?
I believe cor has got it closer then anyone so far just a few minor changes and you have decent code. :) P.S. cor I always try and help (but sometimes am stubborn).Answered | 5 Replies | 1206 Views | Created by waterharbin - Wednesday, October 24, 2012 8:38 AM | Last reply by waterharbin - Wednesday, October 24, 2012 12:50 PM -
1 Votes
How do i write a SQL Query?
Try the link below for the source code.Answered | 2 Replies | 2843 Views | Created by TheGiant89 - Monday, March 29, 2010 9:02 PM | Last reply by kaymaf - Tuesday, March 30, 2010 1:49 PM -
2 Votes
Vb code to write into Notepad text file
1. about VB code how to output a text file 2. about execute/run Notepad 3.Answered | 5 Replies | 1052 Views | Created by Jtownzen - Saturday, April 8, 2017 9:45 PM | Last reply by Cherry Bu - Monday, April 10, 2017 2:28 AM -
4 Votes
About "Insert Code Block"……
3）When pasting codes, just click the "Insert Code Block……", paste a snippet of codes from VS。Answered | 7 Replies | 8914 Views | Created by ThankfulHeart - Wednesday, March 7, 2012 8:44 AM | Last reply by Naomi N - Wednesday, March 14, 2012 1:10 PM -
1 Votes
how would I write this query
1 and t.Usergroup='All members' then 'Do not return' else t.Usergroup end Satheesh My Blog | How to ask ...Answered | 5 Replies | 1223 Views | Created by airwalker2000 - Friday, February 21, 2014 11:17 AM | Last reply by airwalker2000 - Monday, February 24, 2014 9:21 AM -
2 Votes
Single Query for multiple Insertion.
https://msdn.microsoft.com/en-us/library/5ha4240h(v=vs.110).aspx?Answered | 5 Replies | 571 Views | Created by Habib ur rehman - Wednesday, April 15, 2015 8:07 AM | Last reply by Paul P Clement IV - Tuesday, May 12, 2015 1:04 PM -
0 Votes
Error in writing condition in a query
Please execute below to see if it gives you expected result declare @dte as datetime='2015-04-01' declare @StDt as Datetime = DATEADD(mm,DATEDIFF(mm,0,@dte), 0) declare ...Answered | 4 Replies | 1027 Views | Created by baiju krishnan - Saturday, April 4, 2015 8:50 AM | Last reply by Uri Dimant - Saturday, April 4, 2015 10:08 AM -
0 Votes
How to use an open query to insert data into a table?
Yes, this is how you insert data into SQL - you need to do an INSERT statement as you mentioned above.Answered | 1 Replies | 2944 Views | Created by Lee90s - Sunday, April 29, 2012 9:46 PM | Last reply by Ali Hamdar - Sunday, April 29, 2012 10:34 PM -
1 Votes
how to write query for this scenario
Try below solution, it is NOT best solution but might work: Declare @Questions TABLE (QuestionID INT, QuestionText Varchar(100)) INSERT INTO @Questions VALUES (1, ...Answered | 3 Replies | 1097 Views | Created by Incredible15 - Friday, January 9, 2015 11:54 PM | Last reply by Martina White - Saturday, January 10, 2015 9:18 PM -
0 Votes
How to loop through records in a query and write to Excel?
The looping code, even if corrected, is looping with recordset rs, but the code inside the loop is getting values from MyRecordset.Answered | 6 Replies | 1253 Views | Created by ryguy72 - Wednesday, May 11, 2016 3:45 PM | Last reply by ryguy72 - Wednesday, May 11, 2016 6:21 PM -
1 Votes
How to write query for inventory
For a quick start about running totals visit http://sqlsaga.com/sql-server/how-to-calculate-running-totals-in-sql-server/ Try to go on these ...Answered | 8 Replies | 1411 Views | Created by APetrocci - Friday, February 28, 2014 6:20 PM | Last reply by Fanny Liu - Wednesday, March 5, 2014 3:36 AM -
0 Votes
How to write a String Palindrome code
How could it not compile with Option Strict On when Option Strict On is displayed in the code?Answered | 13 Replies | 3558 Views | Created by Anilgeek - Saturday, May 3, 2014 6:35 AM | Last reply by Andrew Morton - Sunday, May 4, 2014 2:38 PM -
0 Votes
Read/Write text file VB
I downloaded the sample code compiled it and ran it.Answered | 3 Replies | 4473 Views | Created by Anth12 - Monday, December 26, 2011 12:20 PM | Last reply by ScCrow - Thursday, July 19, 2012 8:28 PM - Items 1 to 20 of 3219554 Next ›
No announcements
