Skip to content

Instantly share code, notes, and snippets.

View Coolicky's full-sized avatar

Piotr Kulicki Coolicky

  • Pearl Technologies
  • Cork, Ireland
  • 23:19 (UTC +01:00)
View GitHub Profile
SELECT db_name() AS db_name,
S.name AS Schema_Name,
T.name AS Table_Name ,
C.name AS Column_Name ,
P.name AS Data_Type ,
C.max_length AS Size ,
CAST(P.precision AS VARCHAR) + '/' + CAST(P.scale AS VARCHAR) AS Precision_Scale
FROM sys.objects AS T
JOIN sys.columns AS C ON T.object_id = C.object_id
JOIN sys.types AS P ON C.system_type_id = P.system_type_id
#update the apt cache
`sudo apt update`
#List docker versions
`sudo apt-cache madison docker-ce`
#copy the required one
#stop docker service
`sudo systemctl stop docker`