![]() ON acex (StartTime) INCLUDE (ID,TextData)įor every expert, there is an equal and opposite expert. ![]() You can convert SOR file in a few seconds. ![]() 2 How long does it take to convert SOR file This converter works fast. It will now allow you to convert your SOR file. IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N 'tracex'))īEGIN TRANSACTION BULK INSERT acexįROM N 'c:\TallyMan_Traces\trace_20110915094500_20110915103059.txt' WITH (FIELDTERMINATOR = '|', FIRSTROW = 1)īEGIN SELECT = 'PK Violation' END ELSE IF = 1222īEGIN SELECT = 'Lock timeout expired' END ELSE IF = 1205īEGIN SELECT = 'Deadlock' END ELSE IF = 2601īEGIN SELECT = 'Insert Duplicate Key Error' END ELSE BEGIN SELECT = 'Unhandled Error' END IF > 0 ROLLBACK TRANSACTION SELECT Err = ErrMsg = CATCHīEGIN CREATE NONCLUSTERED INDEX IDX_StartTime First, you need to add a file for conversion: drag & drop your SOR file or click inside the white area for choose a file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |