SQL
How to Connect Python to SQL Server using pyodbc
https://datadiaries.dev/connecting-to-microsoft-sql-server-using-sqlalchemy-and-pyodbc
Size all tables in volume
DECLARE @name VARCHAR(128) DECLARE @myList TABLE ([row] int, [id] int,[Name] VARCHAR(128)) ; DECLARE @myResult TABLE ([row] int, [Name] VARCHAR(128), [Value] VARCHAR(128)) ; INSERT INTO @myList ([row], [id], [name]) SELECT row_number() OVER(ORDER BY o.name), o.id, o.name FROM dbo.sysobjects o join sys.all_objects syso on o.id = syso.object_id where o.name like ‘f_uks_%’ and type_desc = ‘USER_TABLE’ DECLARE @total … Read more
Project Status
Create Table CREATE TABLE [dbo].[d_status]( [id] [int] IDENTITY(1,1) NOT NULL, [source_id] [int] NULL, [parent_code] varchar NOT NULL, [linked_id] [int] NULL, [created_date] [datetime] NULL, [modified_date] [datetime] NULL, [authored_by] varchar NULL, [sort_order] [int] NULL, [item_status] [int] NULL, [item_code] varchar NOT NULL, [item_desc] varchar NULL, [item_label] varchar NOT NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (STATISTICS_NORECOMPUTE = … Read more
Access Token
http://man.hubwiz.com/docset/ms_sql.docset/Contents/Resources/Documents/statements/create-database-scoped-credential-transact-sql.html https://connect2id.com/learn/oauth-2