-
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?
-
The data is there. You're just doing something wrong.
In QA, run this: SELECT Count(*) FROM your_table_here
-
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....:sick: