问题描述
大家好，
我在SQL Server 2005中有一个数据库，其中有一个名为StationPositions的表，它有四个键：StationId，Row，Position和Level。
电台2101只有24个职位。但是，从昨天开始，这张桌子正在增长。现在，这个站有56个记录而不是24个。我不知道为什么？这张桌子根本不应该增长。我查看了Database for Insert语句，并没有找到任何这个表。
我查看了插入语句的C＃代码，但没有找到任何以太。
你知道为什么会发生这种情况吗？
谢谢
Hello everyone,
I have a database in SQL Server 2005 with a table called StationPositions which has four keys: StationId, Row, Position, and Level.
Station 2101 has only 24 positions. However, since Yesterday, this table is being growing. now, this Station have 56 records instead of 24. I do not know why? this table should not be growing at all. I look into the Database for Insert Statement and did not find any for this table.
I look into the C # code for an Insert Statement and did not find any ether.
Do you have any idea why this could be happening?
Thank you
推荐答案
http://palletsincorporated.com/Products/products.htm
<pre lang="css">Lgvcs.StationPositions
2101 1 1 1 16401771 2013-05-21 16:36:58.470 2013-05-02 22:18:46.360 507330 260027
2101 2 1 1 16401772 2013-05-21 16:36:58.470 2013-05-02 22:18:46.360 508430 260027
2101 1 1 2 NULL NULL NULL 507330 260027
2101 2 1 2 NULL NULL NULL 508430 260027
2101 1 2 1 16340611 2013-05-18 04:31:11.593 2013-05-18 04:04:25.673 507330 261427
2101 2 2 1 16340612 2013-05-18 04:31:11.610 2013-05-18 04:04:25.687 508430 261427
2101 1 2 2 NULL NULL NULL 507330 261427
2101 2 2 2 NULL NULL NULL 508430 261427
2101 1 3 1 16340649 2013-05-18 04:33:17.703 2013-05-18 03:50:26.673 507330 262827
2101 2 3 1 16340650 2013-05-18 04:33:17.720 2013-05-18 03:50:26.687 508430 262827
2101 1 3 2 NULL NULL NULL 507330 262827
2101 2 3 2 NULL NULL NULL 508430 262827
2101 1 4 1 16340695 2013-05-18 04:38:28.000 2013-05-18 02:49:14.733 507330 264227
2101 2 4 1 16340696 2013-05-18 04:38:28.000 2013-05-18 02:49:14.733 508430 264227</pre>
这篇关于SQL Server中的表正在增长，不应该增长。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！