数据库的一般操作

1.根据bak还原数据库

use master restore database DSERP from disk='F:\xxx.BAK'

2.查询表的列命

select s.name from syscolumns s where s.id = object_id('表名') order by s.colid

3. 根据列名查所有包含该列的表

select tab.name
from syscolumns as col 
inner join sysobjects as tab on col.id=tab.id
where col.name='列名称'