Posts

Showing posts from 2022

Null Value

 nullValueFromType(Types::String)  

Constant

 How to use constant const     str name 1  ="Syam" Table     table1; select *from  table1  where  table1 .name= name1

SQL Single user mode recovery

      USE [master];   DECLARE @kill varchar(8000) = ''; SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';' --select *   FROM sys.dm_exec_sessions WHERE database_id = db_id('AXDB')   EXEC(@kill);   ALTER DATABASE AXDB SET MULTI_USER WITH ROLLBACK IMMEDIATE;

Return statement

 true if the validation succeeded; otherwise, false

Config key enable

SQL Enable update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE' Disable update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE' X++ if(isConfigurationkeyEnabled(configurationKeyNum(ConfigkeyName))) { }

Sql clear data entities clear

 Sql clear data entities delete from DMFEntity where TARGETENTITY  like '%modelname%' //flx delete from DMFTARGETXML where ENTITY  like '%modelname%' //flx

Label compile

  Label compile K:\AosService\PackagesLocalDirectory\bin\labelc.exe -metadata="K:\AosService\PackagesLocalDirectory" -output="K:\AosService\PackagesLocalDirectory\FlexProperty\Resources" -modelmodule="ModelName"