(eprs.used_storage_percent) AS max_used_storage_percent, MAX(eprs.allocated_storage_percent) AS max_allocated_storage_percent FROM sys.dm_elastic_pool_resource_stats AS eprs CROSS JOIN sys.database_service_obje
In Hilo, we don't expect ConvertBack to be called because we're not performing two-way binding. (In some applications, a field that is bound to a date might allow the user to type a new date value. This two-way binding would require both the Convert and ConvertBack methods to work ...
--, Case when meshtype = 'Raw Infeed Fines' then 'Fines' --when meshtype = 'Raw Infeed Coarse' then 'Course' --when (meshtype IS NULL) then 'Dry1' ELSE 'Dry' --end as meshtype from tons_per_hour where datetime >= dateadd(day, datediff(day, 0, dbo.GetDateCDT(GETDATE()))...
,SUM(CASE WHEN T.t_status IN ('CANCEL/BILL', 'CANCEL/NO BILL') THEN 1 ELSE 0 END) AS Cancel FROM track T WHERE T.t_status IN ('CANCEL REQUEST', 'CANCEL/BILL', 'CANCEL/NO BILL') AND T.t_in >= GETDATE() - 169 AND EXISTS ( SELECT * FROM #orders O WHERE O.o_nu...
It doesn't matter what other version the target server is; I've tried a couple of combination. For the third question SQLmaddy got it wrong. Whatever operation you do with the linked server, you need to say BEGIN DISTRIBUTED TRANSACTION, or else you get the DTC error....
INSERTINTOEmp_AUDIT_TableSELECTi.ID,i.Emp_Name,i.Emp_BirthDatae,i.Emp_Salary,i.Emp_Address,SUSER_SNAME(),getdate()FROMinsertedi END GO If you try to insert a new record to the CompanyEmployees table, it will show you that two rows will be affected, as below: ...
EMPLOYEE_HIRE_DATEDATE, EMPLOYEE_SALARYMONEY, EMPLOYEE_COMMISIONMONEY, EMPLOYEE_DEPARTMENTINT ); GO Now, to simulate the auto-growth event, execute the following query to insert data in the table. 1 2 3 4 5 6 7 8 9 10 11 12 13 ...
Ran into one problem with the queries in that "DATEADD(ms, -1 * dosi.ms_ticks - rb.timestamp, GETDATE()) AS RmDateTime" on my test system resulted in a value of -4402094259 for one of my servers, which is a bigint and incompatible with the DATEADD fun...
WHERE eht.row_value != et.row_value— insert rows that have been added INSERT INTO employee_sync_table ( employee_id, first_name, last_name, row_value, datetime_updated ) SELECT employee_id, first_name, last_name, row_value, datetime_updated = GETDATE() FROM employee_table et WHERE ...
--select @date= datepart(day,GETDATE()) SET @SQL='MYALERTS' SET @SQL = 'print '' '' use MYALERTS ;set nocount on; exec blk_text;exec blk_information;Exec Stats_index' --SET @SQL = 'select * from BLOCKED_PROCESS_REPORT where flag = 0' ...