oldfish__的博客

sql优化

DECLARE @e DATETIME = '2021-02-05 12:30'SET @e = DATEADD(yy, DATEDIFF(yy, @e, GETDATE()), @e)SELECT @e

sqlsever:Server=localhost;database=dbname;User ID=sa;Password=Password;oracle:Data Source=192.168.0.1:1521/orcl;User ID=sa;Password=Password;mysql:Server=192.168.0.1;port=2790;database=dbname;User ID=sdsad;Password=Password;Charset=utf8;

--当前数据库USE UEEAnesGN--创建角色 HAIS=院感EXEC sp_addrole 'see_HAIS_View'--分配视图权限 GRANT SELECT ON Author_Daily TO see_HAIS_ViewGRANT SELECT ON View_HISOper TO see_HAIS_View--回收权限--DENY SELECT ON Author_Daily TO see_HAIS_View--添加只允许访问指定视图的登陆名 HAIS-用户名