r1d3rzz

SELECT
    s.Name AS SchemaName,
    t.Name AS TableName,
    p.rows AS NumRows,
    CAST(ROUND((SUM(a.total_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Total_MB,
    CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB,
    CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) AS Unused_MB
FROM
    sys.tables t
    JOIN sys.indexes i ON t.OBJECT_ID = i.object_id

r1d3rzz

PRINCIPAL_AMOUNT*(INTEREST_RATE/100)/INT_BASIS*TERM

r1d3rzz

SELECT 
    s.session_id,
    s.login_name,
    s.host_name,
    s.status,
    s.last_request_start_time,
    s.last_request_end_time,
    r.cpu_time,
    r.total_elapsed_time,
    r.reads,

r1d3rzz

SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), CURRENT_TIMESTAMP), event_time) AS event_time_afterconvert,
	getdate() 'Current_system_time'
	,statement --for reason
	,*
FROM fn_get_audit_file('D:\code\SSMS\Audit\*', DEFAULT, DEFAULT) WHERE action_id = 'LGIF' -- LGIF mean Login Fail

r1d3rzz

$.extend(true, $.fn.dataTable.defaults, {
    processing: true,
    responsive: true,
    mark: true,
    order: [[0, "desc"]],
    iDisplayLength: 5,
    aLengthMenu: [[5, 10, 25, 50, -1], [5, 10, 25, 50, "All"]],
    layout: {
        topStart: {
            buttons: [

r1d3rzz

DTExec.exe /file "D:\filepath" /de "something" 

r1d3rzz

use HRMS
go

update Employees set Department_Branch_Id = Departments.Department_Id
from Departments
WHERE Departments.Name = Employees.DepartmentName

r1d3rzz

// Assuming employee.PermanentEndDate is DateTime? (nullable DateTime)
if (employee.PermanentEndDate.HasValue)
{
    var empPermanentEndDate = employee.PermanentEndDate.Value.Date; // Use .Date to ignore the time part
    var today = DateTime.Today;
    var previousDay = DateTime.Today.AddDays(-1);

    if (empPermanentEndDate == previousDay && previousDay == today)
    {
        // Do something if empPermanentEndDate is the same as yesterday and today

r1d3rzz

BULK INSERT [dbo].[Designations]
FROM 'C:\Users\User\Desktop\Designation.csv'
WITH (
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n',
    FIRSTROW = 2
);

r1d3rzz

DECLARE @CurrentDate DATE = GETDATE();
DECLARE @FirstDayOfPreviousMonth DATE;
DECLARE @LastDayOfPreviousMonth DATE;

-- Calculate the first day of the previous month
SET @FirstDayOfPreviousMonth = DATEADD(MONTH, DATEDIFF(MONTH, 0, @CurrentDate) - 1, 0);

-- Calculate the last day of the previous month
SET @LastDayOfPreviousMonth = EOMONTH(DATEADD(MONTH, -1, @CurrentDate));