摘要:
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDA 阅读全文
摘要:
--清除临时表 use AISXXXXXgodeclare @sql varchar(max) set @sql=''; with t as (select name from sys.tables where create_date<getdate() and (name like 'tm[^_] 阅读全文
摘要:
老K3各种表 在后台数据库ICClassType表中,字段FID<0的是老单,FID>0的是新单。 系统设置 SELECT * FROM T_TableDescription WHERE FDescription LIKE '%入库%' --系统表 SELECT * FROM T_TableDesc 阅读全文
摘要:
SELECT SPID=p.spid, DBName = convert(CHAR(20),d.name), ProgramName = program_name, LoginName = convert(CHAR(20),l.name), HostName = convert(CHAR(20),h 阅读全文
摘要:
exec sp_addrole 'guestview' --GRANT SELECT ON veiw TO [guestview]; GRANT SELECT ON CustomerInfo TO guestview; --exec sp_addlogin 'client','Client@123' 阅读全文