update Company set WTime=convert(nvarchar,DATEPART(hour ,getdate())) + ':' + convert(nvarchar,DATEPART(minute ,getdate())) update Company Set WDate=getdate() update Company set WTime=convert(nvarchar,DATEPART(hour ,getdate())) + ':' + convert(nvarchar,DATEPART(minute ,getdate())) insert into syspermission(UserID,MenuID) select UserID,MenuID From sysuser u, sysmenus m Where (menuid in(select menuid from sysmenus)) and (menuid not in(select menuid from syspermission))