在一次向table1插入记录时,SQL server被人重启了,所以我的记录没有被插入到表中我觉得当时已经是成功插入数据的了,
我也是瞎猜的.
我也是瞎猜的.
解决方案 »
- 语句select ntid from tb_newstype where ntpid={0}中ntpid={0}中括号有什么作用
- 着急啊!插入数据如何提高效率
- SQL语句如何写,大虾帮帮忙啊
- 数据库有的表倒不出来
- 超难触发器设计问题!
- sql server 2005 如何自动备份数据库,要求时间间隔是 “每年”,在维护向导里面只有最多每月备份一次,求教高手
- 看不见是什么啊???还有就是想问下 前面SQL都是处理速度方面很正常的~~但是有时就边的很慢 这个是什么原因?
- 各位大虾,Internet上SQL Server之间如何传输数据!
- VFP输入汉字死机
- 怎么复制一个已有的数据库成为另一个不同名字的数据库
- 如何导入数据库?大家帮忙!
- 请教如何如何如下查询?
但table1表中查找a1=‘H000012039’的值,没有找到!???
dbcc checktable('table1')看看有什么提示
drop table [dbo].[smi_htsh1]
GOCREATE TABLE [dbo].[smi_htsh1] (
[y_heth] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[kehid] [char] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[y_xd_date] [datetime] NOT NULL ,
[ht_mailf1] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_mailf2] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_jine_z] [money] NOT NULL ,
[ht_jine_zd] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[lyh_k] [bit] NOT NULL ,
[lyh_g] [bit] NOT NULL ,
[lyh_q] [bit] NOT NULL ,
[k_feil] [bit] NOT NULL ,
[k_jiagt] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_tzh] [bit] NOT NULL ,
[ht_tzh_n] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[k_ruanp] [bit] NOT NULL ,
[k_email] [bit] NOT NULL ,
[ht_k_qit] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[lb_pub] [bit] NOT NULL ,
[lb_zhenb] [bit] NOT NULL ,
[ht_b_qit] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_zt] [bit] NOT NULL ,
[ht_shh] [bit] NOT NULL ,
[ht_j_qit] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_fuk] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_daib_n] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_daib_d] [datetime] NOT NULL ,
[ht_dzh] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_maif_n] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_fax] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ht_tel] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[beizh] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dd_lb] [int] NOT NULL ,
[user_name] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[user_date] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GOALTER TABLE [dbo].[smi_htsh1] ADD
CONSTRAINT [DF_smi_htsh1_kehid] DEFAULT ('') FOR [kehid],
CONSTRAINT [DF_smi_htsh1_ht_mailf1] DEFAULT ('') FOR [ht_mailf1],
CONSTRAINT [DF_smi_htsh1_ht_mailf2] DEFAULT ('') FOR [ht_mailf2],
CONSTRAINT [DF_smi_htsh1_ht_jine_z] DEFAULT (0) FOR [ht_jine_z],
CONSTRAINT [DF_smi_htsh1_ht_jine_zd] DEFAULT ('') FOR [ht_jine_zd],
CONSTRAINT [DF_smi_htsh1_lyh_k] DEFAULT (0) FOR [lyh_k],
CONSTRAINT [DF_smi_htsh1_lyh_g] DEFAULT (0) FOR [lyh_g],
CONSTRAINT [DF_smi_htsh1_lyh_q] DEFAULT (0) FOR [lyh_q],
CONSTRAINT [DF_smi_htsh1_k_feil] DEFAULT (0) FOR [k_feil],
CONSTRAINT [DF_smi_htsh1_k_jiagt] DEFAULT ('') FOR [k_jiagt],
CONSTRAINT [DF_smi_htsh1_ht_tzh] DEFAULT (0) FOR [ht_tzh],
CONSTRAINT [DF_smi_htsh1_ht_tzh_n] DEFAULT ('') FOR [ht_tzh_n],
CONSTRAINT [DF_smi_htsh1_k_ruanp] DEFAULT (0) FOR [k_ruanp],
CONSTRAINT [DF_smi_htsh1_k_email] DEFAULT (0) FOR [k_email],
CONSTRAINT [DF_smi_htsh1_ht_k_qit] DEFAULT ('') FOR [ht_k_qit],
CONSTRAINT [DF_smi_htsh1_lb_pub] DEFAULT (0) FOR [lb_pub],
CONSTRAINT [DF_smi_htsh1_lb_zhenb] DEFAULT (0) FOR [lb_zhenb],
CONSTRAINT [DF_smi_htsh1_ht_b_qit] DEFAULT ('') FOR [ht_b_qit],
CONSTRAINT [DF_smi_htsh1_ht_zt] DEFAULT (0) FOR [ht_zt],
CONSTRAINT [DF_smi_htsh1_ht_shh] DEFAULT (0) FOR [ht_shh],
CONSTRAINT [DF_smi_htsh1_ht_j_qit] DEFAULT ('') FOR [ht_j_qit],
CONSTRAINT [DF_smi_htsh1_ht_fuk] DEFAULT ('') FOR [ht_fuk],
CONSTRAINT [DF_smi_htsh1_ht_daib_n] DEFAULT ('') FOR [ht_daib_n],
CONSTRAINT [DF_smi_htsh1_ht_daib_d] DEFAULT ('') FOR [ht_daib_d],
CONSTRAINT [DF_smi_htsh1_ht_dzh] DEFAULT ('') FOR [ht_dzh],
CONSTRAINT [DF_smi_htsh1_ht_maif_n] DEFAULT ('') FOR [ht_maif_n],
CONSTRAINT [DF_smi_htsh1_ht_fax] DEFAULT ('') FOR [ht_fax],
CONSTRAINT [DF_smi_htsh1_ht_tel] DEFAULT ('') FOR [ht_tel],
CONSTRAINT [DF_smi_htsh1_beizh] DEFAULT ('') FOR [beizh],
CONSTRAINT [DF_smi_htsh1_dd_lb] DEFAULT (1) FOR [dd_lb],
CONSTRAINT [DF_smi_htsh1_user_name] DEFAULT ('') FOR [user_name],
CONSTRAINT [DF_smi_htsh1_user_date] DEFAULT ('') FOR [user_date],
CONSTRAINT [PK_smi_htsh1] PRIMARY KEY NONCLUSTERED
(
[y_heth]
) ON [PRIMARY]
GO