摘要: andexists(select*fromsysobjects)//判断是否是MSSQLandexists(select*fromtableName)//判断某表是否存在..tableName为表名and1=(select@@VERSION)//MSSQL版本And1=(selectdb_name())//当前数据库名and1=(select@@servername)//本地服务名and1=(selectIS_SRVROLEMEMBER('sysadmin'))//判断是否是系统管理员and1=(SelectIS_MEMBER('db_owner'))//判断是 阅读全文
posted @ 2013-04-16 11:25 zero@ 阅读(16220) 评论(0) 推荐(0) 编辑
摘要: select * from T_user where exists (select * from sysobjects) ;//判断是否存在sysobjects表,默认的select * from T_user where exists (select * from T_user);//判断是否存在XX表select * from T_user where 1=(@@version);//数据库版本号select * from T_user where 1=(user_name());//获取当前用户select * from T_user where 1=(@@servername);//获 阅读全文
posted @ 2013-04-16 11:24 zero@ 阅读(1094) 评论(0) 推荐(0) 编辑