SQLTip

@SQLTipOfTheDay

Присоединился в Январь 2018

121Посты 8читателей 1в читаемых

Вам может понравиться

@FX_LARROCHE

@rauldelcampo_

@ScottSata

@scottpetersen

@DougStanley14

@IBasskung

@cybercopsindia

@MeenaDehri

SQLTip

@SQLTipOfTheDay

16 янв. 2024 г.

#sqltip #powershelltip #dostip #checkport powershell tnc <hostname> -port <num> e.g. tnc winpc1 -port445 "WARNING: TCP Connect to winpc1:445 failed"

SQLTip

@SQLTipOfTheDay

22 июл. 2023 г.

#DOSTip #BatchScript #ErrorLogging set "Var1=abc<def<ghi" echo %Var1% abc<def<ghi @rem-- Redirect output to file, and error messages echo Test1 > logfile.out 2>&1

#sqltip #snowflaketip #loginerrors USE DATABASE SNOWFLAKE; SELECT * FROM ACCOUNT_USAGE.LOGIN_HISTORY WHERE USER_NAME = 'username' AND EVENT_TIMESTAMP > DATEADD('day', -1, CURRENT_DATE) ORDER BY EVENT_TIMESTAMP DESC LIMIT 100;

SQLTip

@SQLTipOfTheDay

28 окт. 2022 г.

#sqltip #snowflaketip #Role #SFJJSON SELECT CURRENT_AVAILABLE_ROLES(); SELECT "SEQ","KEY","PATH","INDEX","VALUE","THIS" FROM TABLE ( FLATTEN (INPUT => PARSE_JSON( CURRENT_AVAILABLE_ROLES() ) ) ) WHERE "VALUE" LIKE '%<dbname>%' ;