SELECT sid = CONVERT(varbinary(85), sid), status = CONVERT(smallint,
8 + CASE WHEN (xstatus & 2) = 0 THEN 1 ELSE 2 END),
createdate = CONVERT(datetime, xdate1), updatedate = CONVERT(datetime, xdate2),
accdate = CONVERT(datetime, xdate1), totcpu = CONVERT(int, 0), totio = CONVERT(int,
0), spacelimit = CONVERT(int, 0), timelimit = CONVERT(int, 0),
resultlimit = CONVERT(int, 0), name = CONVERT(sysname, name),
dbname = CONVERT(sysname, db_name(dbid)), password = CONVERT(sysname,
password), language = CONVERT(sysname, language), denylogin = CONVERT(int,
CASE WHEN (xstatus & 1) = 1 THEN 1 ELSE 0 END), hasaccess = CONVERT(int,
CASE WHEN (xstatus & 2) = 2 THEN 1 ELSE 0 END), isntname = CONVERT(int,
CASE WHEN (xstatus & 4) = 4 THEN 1 ELSE 0 END), isntgroup = CONVERT(int,
CASE WHEN (xstatus & 12) = 4 THEN 1 ELSE 0 END), isntuser = CONVERT(int,
CASE WHEN (xstatus & 12) = 12 THEN 1 ELSE 0 END), sysadmin = CONVERT(int,
CASE WHEN (xstatus & 16) = 16 THEN 1 ELSE 0 END), securityadmin = CONVERT(int,
CASE WHEN (xstatus & 32) = 32 THEN 1 ELSE 0 END), serveradmin = CONVERT(int,
CASE WHEN (xstatus & 64) = 64 THEN 1 ELSE 0 END), setupadmin = CONVERT(int,
CASE WHEN (xstatus & 128) = 128 THEN 1 ELSE 0 END),
processadmin = CONVERT(int, CASE WHEN (xstatus & 256)
= 256 THEN 1 ELSE 0 END), diskadmin = CONVERT(int, CASE WHEN (xstatus & 512)
= 512 THEN 1 ELSE 0 END), dbcreator = CONVERT(int, CASE WHEN (xstatus & 1024)
= 1024 THEN 1 ELSE 0 END), bulkadmin = CONVERT(int,
CASE WHEN (xstatus & 4096) = 4096 THEN 1 ELSE 0 END),
loginname = CONVERT(sysname, name)
FROM sysxlogins
WHERE srvid IS NULL
问题:WHEN (xstatus & 2) = 0 THEN 1 ELSE 2中的xstatus & 2什么意思,最好说说convert怎么用
8 + CASE WHEN (xstatus & 2) = 0 THEN 1 ELSE 2 END),
createdate = CONVERT(datetime, xdate1), updatedate = CONVERT(datetime, xdate2),
accdate = CONVERT(datetime, xdate1), totcpu = CONVERT(int, 0), totio = CONVERT(int,
0), spacelimit = CONVERT(int, 0), timelimit = CONVERT(int, 0),
resultlimit = CONVERT(int, 0), name = CONVERT(sysname, name),
dbname = CONVERT(sysname, db_name(dbid)), password = CONVERT(sysname,
password), language = CONVERT(sysname, language), denylogin = CONVERT(int,
CASE WHEN (xstatus & 1) = 1 THEN 1 ELSE 0 END), hasaccess = CONVERT(int,
CASE WHEN (xstatus & 2) = 2 THEN 1 ELSE 0 END), isntname = CONVERT(int,
CASE WHEN (xstatus & 4) = 4 THEN 1 ELSE 0 END), isntgroup = CONVERT(int,
CASE WHEN (xstatus & 12) = 4 THEN 1 ELSE 0 END), isntuser = CONVERT(int,
CASE WHEN (xstatus & 12) = 12 THEN 1 ELSE 0 END), sysadmin = CONVERT(int,
CASE WHEN (xstatus & 16) = 16 THEN 1 ELSE 0 END), securityadmin = CONVERT(int,
CASE WHEN (xstatus & 32) = 32 THEN 1 ELSE 0 END), serveradmin = CONVERT(int,
CASE WHEN (xstatus & 64) = 64 THEN 1 ELSE 0 END), setupadmin = CONVERT(int,
CASE WHEN (xstatus & 128) = 128 THEN 1 ELSE 0 END),
processadmin = CONVERT(int, CASE WHEN (xstatus & 256)
= 256 THEN 1 ELSE 0 END), diskadmin = CONVERT(int, CASE WHEN (xstatus & 512)
= 512 THEN 1 ELSE 0 END), dbcreator = CONVERT(int, CASE WHEN (xstatus & 1024)
= 1024 THEN 1 ELSE 0 END), bulkadmin = CONVERT(int,
CASE WHEN (xstatus & 4096) = 4096 THEN 1 ELSE 0 END),
loginname = CONVERT(sysname, name)
FROM sysxlogins
WHERE srvid IS NULL
问题:WHEN (xstatus & 2) = 0 THEN 1 ELSE 2中的xstatus & 2什么意思,最好说说convert怎么用
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货