对SQL数据库中的表去重,查询出的的结果放在临时表里,如何把这个临时表替换原先数据库未处理过的表
现在我的代码是这样:
private void button1_Click(object sender, EventArgs e)
{
string ConStr = "server=(local);user id=sa;pwd=123;database=DB";
SqlConnection cn = new SqlConnection(ConStr);
SqlDataAdapter dap = new SqlDataAdapter("select distinct Pinst_namechar,Pinst_addrchar,Pinst_phonechar from 事业表", cn);
DataSet ds = new DataSet();
dap.Fill(ds, "qc");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
现在的结果是显示出已经去重过的临时表,如何把它替换掉原先未处理的表(也就是事业表),变为新的事业表
请é®å¨windowsçªä½éåºè¯¥å¦ä½åè¯å¥ï¼å 为è¦æ±åçæ¯å®¢æ·ç«¯ï¼åµåµï¼æä¹åªè½å¨é£éåäºãè¿æ¯å¤è°¢ææäºï¼
追çä½ å°è¯å¨ windowsçªä½é, ä¾æ¬¡æ§è¡ä¸é¢ç4æ¡è¯å¥ã åºè¯¥ä¹æ¯å¯ä»¥çã
å¦æè¦å®å
¨ä¸ç¹çè¯ï¼å°±æ¯åå¨ä¸ä¸ª äºå¡å¤çéé¢ã
è¦é¢å
æä¸ä¸ªç»æä¸æ ·ç表
å¨ windowsçªä½éï¼ä¾æ¬¡æ§è¡ä¸é¢4å¥ SQL è¯å¥ï¼å°±å¥½ã å¦æåçé误äºï¼ è¿å¯ä»¥åæ»ã
DELETE FROM 临æ¶è¡¨;
INSERT INTO 临æ¶è¡¨ select distinct * from äºä¸è¡¨;
DELETE FROM äºä¸è¡¨;
INSERT INTO äºä¸è¡¨ SELECT * FROM 临æ¶è¡¨;
åå¦ä¸æ³æ§è¡å¤ªå¤è¯å¥ï¼åªè¦ä¸æ¡SQLè¯å¥å°±å®äºçè¯ã
ä¸é¢æ¯SQLéé¢ï¼å é¤2æ¡å®å
¨ä¸æ ·çæ°æ®çä¾åï¼ä½ ä¹å¯ä»¥åèåèã
http://hi.baidu.com/wangzhiqing999/blog/item/e90c4012ae8b5d0c962b4357.html