- 博客(3)
- 收藏
- 关注
原创 asp连接字符
conn.Open "DSN=test;UID=;PWD=;"conn.Open"driver={SQL Server};server=.;uid=;pwd=;database=Northwind"
2006-10-31 16:34:00 888
原创 删除部分重复的记录,保留重复记录的第一条.
方法:select identity(int,1,1) as autoID, * into Tmp from aaselect min(autoID) as autoID into Tmp2 from Tmp group by bselect * from Tmp where autoID in(select autoID from tmp2)
2006-10-31 15:51:00 1086
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人