get newly created Tables LIst
select schema_name(schema_id) as schema_name,
name as table_name,
create_date,
modify_date
from sys.tables
where create_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)
order by create_date desc;
https://dataedo.com/kb/query/sql-server/find-recently-created-tables.
To know SP Names
select name,create_date,modify_date
from sys.procedures
order by modify_date desc
naviagate to part of page in angular
https://stackoverflow.com/questions/40498333/angular2-how-to-navigate-to-certain-section-of-the-page-identified-with-an-id-at
<select class="form-control" id="EmpRating" name="EmpRating" [(ngModel)]="competency.EmpRating" required>
<option class="dropdown-item" disabled selected value="undefined">
Select an Option</option>
<option *ngFor="let R of SkillRatings" [value]="R.SkillRatingID" >
{{ R.Title }}
</option>
</select>
-- =============================================
-- Author : Praveen
-- Create Date :
-- Description : USP_UpdateCountry
-- =============================================
-- Exec [USP_UpdateUser]
CREATE PROCEDURE [dbo].[USP_UpdateUser]
@dtUser [dbo].[UDTT_Users] READONLY,
@dtUserEntities [dbo].[UDTT_UserAccessEntities] READONLY
AS
BEGIN
BEGIN TRANSACTION [UpdateDetails]
BEGIN TRY
COMMIT TRANSACTION [UpdateDetails]
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION [UpdateDetails]
SELECT '0' AS ID, 'false' AS [Status], 'Failed to save' as [Message]
INSERT INTO tbl_Errors(ErrorNumber,ErrorState,ErrorSeverity,ErrorLine,ErrorProcedure,ErrorMessage,ErrorDateTime )
SELECT
ERROR_NUMBER() AS ErrorNumber, ERROR_STATE() AS ErrorState, ERROR_SEVERITY() AS ErrorSeverity
,ERROR_LINE() AS ErrorLine, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_MESSAGE() AS ErrorMessage
,GETDATE()
END CATCH
END
------------------table--------
CREATE TABLE [dbo].[tbl_Errors](
[ErrorID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](100) NULL,
[ErrorNumber] [int] NULL,
[ErrorState] [int] NULL,
[ErrorSeverity] [int] NULL,
[ErrorLine] [int] NULL,
[ErrorProcedure] [nvarchar](max) NULL,
[ErrorMessage] [nvarchar](max) NULL,
[ErrorDateTime] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[ErrorID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
select * from tbl_UserAccessEntities
where DATEPART(yy, ModifiedOn) = 2023
SELECT * FROM tbl_UserAccessEntities WHERE CONVERT(VARCHAR, ModifiedOn , 120) LIKE '2023-02-13%'
To know latest Procedures crated in sql
SELECT * FROM sys.objects WHERE type='p' ORDER BY modify_date DESC
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
SELECT name, crdate, refdate
FROM sysobjects
WHERE type = 'P'
ORDER BY refdate desc
to reset template driven form without data become null in data table.
1.this.workFlowMembers={} as any;
