Aleksey aleksb86

🎯

Focusing

aleksb86 / Add_columns_to_table.sql

Created June 16, 2017 10:35

Script for adding columns to any table (or other than ALTER mass executions).

	--Скрипт для добавления столбцов
	--в таблицу. IN - список схем и таблиц в строковом виде.

	use DWH_ODS_dev
	GO

	--------------------
	declare @t table (sch varchar(50), tabname varchar(50))
	declare @sch varchar(50) = ''
	declare @tabname varchar(50) = ''

aleksb86 / python_logger_example.py

Last active February 7, 2017 09:18

Python simple logging snippet

	import logging


	# Set logger with logfile (*.log) in same directory as current
	# executing file.
	logger = set_logger('{}.log'.format(os.path.abspath(__file__)))

	# Write error event with traceback information:
	try:
	1 / 0