数据库
if exists(select * from master.dbo.sysdatabases where name = 'yexinwinners')
begin
drop database yexinwinners
print 'yexinwinners己存在,己被删除'
end
else
begin
create database yexinwinners
数据库中的一张表
sSql="select * from "+ databasename +".dbo.sysobjects where name = '"+sTable_name+"' and type='U'"; //查找系统库中的用户表‘U’代表用户的意思