SytelineMaster

When deploying an UET customization in Syteline 7 & 8, there is SP can be used to script out the UET. Just do exec ExportUETClassSP ‘classname’ Some server don’t this SP installed.  I just keep a copy here for in case set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[ExportUETClassSP] ( @PClassName Infobar ) […]

It is very often that you need to get current date/time in your development. T-SQL To get today date without time as string variable use following script: Select CONVERT( CHAR(8), GetDate(), 112) To get datetime variable of today date without time use following script: Select CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME) VB System.DateTime.Now.ToString(“yyyyMMddhhmmss”) Now() […]