mukarramjavid · March 24, 2023 07:14
diff --git a/create_json_from_sql_server_table.sql b/create_json_from_sql_server_table.sql
 SELECT '"' + COLUMN_NAME + '":'+
 		CASE WHEN DATA_TYPE='NVARCHAR' THEN '"'+'VARCHAR(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') ' + 
 		CASE WHEN IS_NULLABLE = 'NO' THEN 'NOT NULL' ELSE 'NULL'END+'",' ELSE '"'+DATA_TYPE+'(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') '  + 
 		CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE 'NULL'END+'",'
 		END  AS JsonFormat 
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_NAME = N'[table_name]'
	SELECT '"' + COLUMN_NAME + '":'+
	CASE WHEN DATA_TYPE='NVARCHAR' THEN '"'+'VARCHAR(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') ' +
	CASE WHEN IS_NULLABLE = 'NO' THEN 'NOT NULL' ELSE 'NULL'END+'",' ELSE '"'+DATA_TYPE+'(' + CAST(ISNULL(CHARACTER_MAXIMUM_LENGTH, 0) AS nvarchar(50))+') ' +
	CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE 'NULL'END+'",'
	END AS JsonFormat
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = N'[table_name]'