To know database changes ---
SELECT *
FROM
    sys.dm_db_index_usage_stats AS usage_stats
INNER JOIN
sys.tables AS tables ON tables.object_id = usage_stats.object_id
WHERE
    database_id = DB_ID() AND
    tables.name in (select name from sys.tables)

Comments

Post a Comment

Popular posts from this blog

Unit of Work

https://docs.microsoft.com/en-us/aspnet/mvc/overview/older-versions/getting-started-with-ef-5-using-mvc-4/implementing-the-repository-and-unit-of-work-patterns-in-an-asp-net-mvc-application#implement-a-generic-repository-and-a-unit-of-work-class
Read more
i ve to display data in commas in sql :- Returning a Comma CREATE FUNCTION dbo.fn_GetTherapistName(@AppCode int) RETURNS VARCHAR(1000) AS BEGIN    DECLARE @StudentList varchar(1000)    --SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(m.TherapistId AS VARCHAR(15))    --FROM multipleTherapy m    --WHERE m.AppCode = @AppCode SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(dbo.staff_Master.firstname AS VARCHAR(100)) FROM         dbo.multipleTherapy INNER JOIN                       dbo.staff_Master ON dbo.multipleTherapy.TherapistId = dbo.staff_Master.empcode WHERE     (dbo.multipleTherapy.AppCode = @AppCode)    RETURN @StudentList END
Read more