Contents tagged with TSQL
-
Prevent Object Create in Master Database in SQL Server
USE masterGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER DDL_PreventObjectCreationInMasterDBON DATABASEFOR CREATE_TABLE, CREATE_VIEW, CREATE_PROCEDURE,CREATE_FUNCTIONASBEGIN-- SET … more
-
Querying SQL Server Agent Job History Data
https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/
-
SQL Server Get Job Instance Id with TSQL
https://www.sqlservercentral.com/forums/topic/job-instance-id
-
SQL Server: TSQL Select Into with Identity
SELECT IDENTITY(INT,1,1) AS ID,* INTO NewTable FROM ExistingTable more
-
SQL Server Memory Consumption by Object
https://www.sqlserverscience.com/performance/memory-consumption-by-object/ more
-
SQL: How an OR Short Circuits
https://sqlstudies.com/2019/06/17/its-interesting-how-an-or-short-circuits/ more
-
SQL and NULL Mistakes
https://www.red-gate.com/hub/product-learning/sql-prompt/the-null-mistake-and-other-sql-null-heresies more
-
Does the case expression short circuit
https://sqlstudies.com/2019/06/13/does-the-case-statement-short-circuit/ more
-
SQL Server: Get Operating System Information with TSQL
SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version FROM sys.dm_os_windows_info
exec master..xp_cmdshell 'systeminfo'
SELECT @@version
exec xp_msver more
-
Connect Python to SQL
https://datascienceplus.com/connect-python-to-sql/ more