![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
bearfirstblog
Just Do it Now
展开
-
Quickly find all tables/views that have a specific column name
Drop Proc FindAllColumns GO Create Proc FindAllColumns @ColName VarChar(255) AS Select SO.Name From SysColumns SC Inner Join SysObjects SO on SO.ID = SC.ID Where SC.name = @ColName原创 2006-07-03 10:56:00 · 2083 阅读 · 0 评论 -
Deleting Duplicate Rows
--**************************************-- -- Name: Deleting Duplicate Rows-- Description:The Purpose of this code -- is to delete the duplicate values occuri-- ng in a table.转载 2006-07-03 11:06:00 · 2151 阅读 · 0 评论