|
-
Jul 6th, 2004, 11:21 AM
#1
Thread Starter
Frenzied Member
Any SQL Guys
I'm using ADO.NET and VB.NET to write some data out to a SQL Server Table. basically I am stepping through a DataTable and Inserting each row into a SQL Server Table. Well when I am done, and look at the table in SQL Server, the number of Rows it says it has is wrong (short a couple hundred), but when I export from that table into Excel, I have the right number of rows. Has anybody heard of this being a SQL Server bug?
Sean
Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
-
Jul 6th, 2004, 11:36 AM
#2
Frenzied Member
The data is there. You're just doing something wrong.
In QA, run this: SELECT Count(*) FROM your_table_here
~Peter
-
Jul 6th, 2004, 11:45 AM
#3
Thread Starter
Frenzied Member
I'm not doing a select, I am just double clicking on the table to bring up the properties window, and it says Rows: 32334. Which is incorrect. So I then export it to Excel, and check and there are 32589 rows, which is correct. Unless I am incorrectly double clicking....
Sean
Some days when I think about the next 30 years or so of my life I am going to spend writing code, I happily contemplate stepping off a curb in front of a fast moving bus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote