Wednesday 20 November 2019

Get the list of created and / or modified on a operations in sql server

/////////////////////


SELECT * FROM sys.procedures WHERE create_date > '20191110'  ---Particular for the procedure

SELECT * FROM sys.tables WHERE create_date > '20191110'  ------Particularfor the table

SELECT * FROM sys.views WHERE create_date > '20181110'   ------Particular for the View

SELECT * FROM sys.table_types                       -    ----- Particular for the table type

---Get All operated type

SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE CREATED > '20191010' 

---Get All operated type

SELECT * FROM sys.objects WHERE DATEDIFF(D,modify_date, GETDATE()) < 7  



/////////////////////////////////

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...