--5:查询用户创建的所有数据库select * from master..sysdatabases D where sid not in(select sid from master..syslogins where name='sa')--或者select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01
SELECT sum(t2) as t2_total from yourtable where val(right(t1,1)))<=4
??? select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01 好像不对哦!我自己建的数据库 为什么还是0x01???--Testcreate database Abxselect * from sysdatabases
select name from sysdatabases
select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01
好像不对哦!我自己建的数据库 为什么还是0x01???--Testcreate database Abxselect * from sysdatabases