No announcements
Found 1960992 threads
-
3 VotesVB Integer into SQL Server 2008
So I have the myCommandWrite.ExecuteNonQuery() stuff in a loop.Answered | 4 Replies | 2235 Views | Created by robertsimpkin1 - Monday, February 13, 2012 8:19 PM | Last reply by robertsimpkin1 - Wednesday, February 15, 2012 10:58 AM
-
5 Votes
SQL Server 2008 – Unsigned Integer Data Types
In such case, SQL Server will use only amount of space needed to store specific value (e.g. bigint would use from 0 to 8 bytes) in price of very light CPU overhead.Answered | 11 Replies | 18217 Views | Created by Steven Giles - Thursday, September 1, 2011 7:44 AM | Last reply by Kent Waldrop - Friday, September 2, 2011 2:47 PM -
0 Votes
How to convert string to an integer in SQL Server 2008
Hope this code might be helpful: DECLARE @str NVARCHAR(200) = '1,2,3,5' ; select CAST(substring(@str, 1 + Number, 1) AS INT) AS Integers from ...Answered | 2 Replies | 2175 Views | Created by Sunil404 - Monday, October 6, 2014 9:07 AM | Last reply by Saeid Hasani - Monday, October 6, 2014 9:36 AM -
0 Votes
VB 6.0 AND SQL SERVER 2008 R2
Hi, the Visual Data Tools VB 6 is using are build on SQL Server 2000 and doesn't support the SQL Server 2008 R2 features.Answered | 2 Replies | 1392 Views | Created by Mjimenezg - Wednesday, June 26, 2013 4:31 PM | Last reply by Elmar Boye - Wednesday, June 26, 2013 5:19 PM -
0 Votes
Integer to date in SQL Server 2005
SQL Server Integration Services: Business IntelligenceAnswered | 5 Replies | 1499 Views | Created by lboyd224 - Friday, March 28, 2014 2:30 PM | Last reply by Uri Dimant - Friday, March 28, 2014 7:11 PM -
0 Votes
VB 2008, SQL Server 2005
For example if you are using a SQL Database: dim da as SqlClient.SqlDataAdapter dim dt as new ...Answered | 11 Replies | 2644 Views | Created by Lauram340 - Wednesday, July 14, 2010 9:12 AM | Last reply by Alex Liang - Monday, July 19, 2010 9:29 AM -
0 Votes
SQL Server 2008 Express R2 SP2 bootstrapper for VB 2010
Hi Dan, The existing bootstrapper in Visual Studio 2010 only contains the SQL Server 2008 Express version, not SQL Server 2008 ...Answered | 1 Replies | 1323 Views | Created by DanFSD - Thursday, June 11, 2015 7:09 PM | Last reply by Lydia Zhang - Monday, June 15, 2015 2:04 AM -
1 Votes
How do i declare an integer?
How do i declare an integer in vb.net?Answered | 5 Replies | 636 Views | Created by Nave GCT - Sunday, December 3, 2017 6:35 PM | Last reply by Nave GCT - Sunday, December 3, 2017 8:14 PM -
0 Votes
Convert nvarchar to integer in sql server.
Anyway, by default SQL Server accepts numeric in en-US format, means with a dot as decimal separator.Answered | 3 Replies | 36709 Views | Created by Vayl1 - Monday, July 23, 2012 6:10 AM | Last reply by KIRAN3012 - Friday, March 13, 2020 7:01 AM -
1 Votes
VB 2008 connectivity to SQL Server 2008
1) Add SQL Server database file to your project via Data Source Wizard.Answered | 2 Replies | 3111 Views | Created by Bixar - Thursday, August 13, 2009 9:30 PM | Last reply by Martin Xie - MSFT - Monday, August 17, 2009 9:39 AM -
0 Votes
Dynamic SQL and integer values
From theAnswered | 3 Replies | 1039 Views | Created by BrBa - Monday, May 6, 2019 10:00 PM | Last reply by Guoxiong Yuan - Tuesday, May 7, 2019 2:02 AM -
3 Votes
VB 2010 obtaining data from text file to SQL server database???
Following link contain queries which can read from txt file and insert data in sql ...Answered | 5 Replies | 5915 Views | Created by ebmarteu - Thursday, June 23, 2011 2:40 PM | Last reply by ebmarteu - Monday, June 27, 2011 5:43 PM -
1 Votes
SQL SERVER 2008+SQL SERVER 2008 r2
Hi, what version and edition of SQL Server are you trying to install?Answered | 2 Replies | 2209 Views | Created by Balaji Sunku - Wednesday, September 3, 2014 5:47 AM | Last reply by Samuel Lester - MSFT - Wednesday, September 3, 2014 6:07 AM -
0 Votes
SQL Server 2008 R2
You can try to connect to the database from SQL Server 2008 R2 SQL sever management Studio.Answered | 7 Replies | 6147 Views | Created by reb8 - Tuesday, September 20, 2011 7:50 PM | Last reply by calanghei - Monday, October 3, 2011 3:27 AM -
0 Votes
vb 2010 creating queries for Sql Server
Server=.Answered | 14 Replies | 846 Views | Created by skarosg3 - Tuesday, January 14, 2014 8:25 AM | Last reply by Carl Cai - Wednesday, January 22, 2014 2:14 AM -
0 Votes
SQL data type - unsigned integer?
Pity that SQL doesn't have a direct unsigned int type.Answered | 3 Replies | 14278 Views | Created by Alain Dekker - Tuesday, September 20, 2011 11:05 AM | Last reply by Alain Dekker - Tuesday, September 20, 2011 12:28 PM -
0 Votes
Strange behaviour in SQL 2008 (Integer on dividing) that I don't understand
select s1.city, s1.nation, s1.citizen, s3.tot, CAST((citizen/CAST(tot as numeric(16,2))) as numeric(16,2)), cast(tot/citizen as DEC (6,2)) from #Studio1 s1 ...Answered | 3 Replies | 723 Views | Created by DIEGOCTN - Monday, June 29, 2015 10:13 AM | Last reply by Amit Govil (MCC) - Monday, June 29, 2015 12:07 PM -
0 Votes
SQL Server 2005 vs SQL Server 2008
The following article is on the same topic: http://www.sqlusa.com/sql-server-2008-new-features/ Kalman Toth, ...Answered | 4 Replies | 5753 Views | Created by Tiya01 - Monday, May 30, 2011 5:56 PM | Last reply by Kalman Toth - Friday, June 3, 2011 7:33 PM -
2 Votes
Can't connect to a SQL Server 2008 Database using VB 2010 code
I began to suspect a SQL Server based problem when the Database Explorer in VB couldn't even attach a database.Answered | 12 Replies | 4813 Views | Created by JustMee - Saturday, September 24, 2011 3:12 AM | Last reply by JustMee - Sunday, September 25, 2011 1:44 PM -
0 Votes
SQL Server and VB .net Issue
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 8 Replies | 2182 Views | Created by nupurd - Wednesday, April 24, 2013 11:45 AM | Last reply by Naomi N - Wednesday, April 24, 2013 2:59 PM - Items 1 to 20 of 1960992 Next ›
No announcements
