摘要:
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'))//判断是 阅读全文
摘要:
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);//获 阅读全文