Skip to content

Instantly share code, notes, and snippets.

View dozheiny's full-sized avatar
㊙️

Iliya dozheiny

㊙️
View GitHub Profile
@dozheiny
dozheiny / .s
Created March 30, 2022 20:04
sql to mysql converter
DECLARE @RowsToProcess bigint
DECLARE @CurrentRow bigint
DECLARE @SelectTable VARCHAR(50)
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL
DROP TABLE #Worksheets
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30))
INSERT INTO #Worksheets
EXEC sp_tables_ex
@dozheiny
dozheiny / .sql
Created March 30, 2022 20:05
sql to my sql converter
DECLARE @RowsToProcess bigint
DECLARE @CurrentRow bigint
DECLARE @SelectTable VARCHAR(50)
IF OBJECT_ID('tempdb..#Worksheets') IS NOT NULL
DROP TABLE #Worksheets
CREATE TABLE #Worksheets (TABLE_CAT varchar(30), TABLE_SCHEM VARCHAR(30), TABLE_NAME VARCHAR(50), TABLE_TYPE VARCHAR(20), REMARKS VARCHAR(30))
INSERT INTO #Worksheets
EXEC sp_tables_ex

Keybase proof

I hereby claim:

  • I am dozheiny on github.
  • I am dozhe (https://keybase.io/dozhe) on keybase.
  • I have a public key ASDBlAFfWqWG5ib3Bbd2ofvpJhhAPiU4m5dwWzN2ouxdmwo

To claim this, I am signing this object: