Json 转sqlserver创建表脚本 JSONtoSQLGenerator

flon

于 2022-07-04 19:40:19 发布

阅读量829

点赞数

文章标签： sqlserver 数据库 sql json

本文链接：https://blog.csdn.net/flon/article/details/125607354

版权

这段代码接收JSON输入字符串，自动生成SQL Server的CREATE TABLE语句，帮助将序列化数据转换为数据库模式。它不完美，但作为处理新JSON文件的起点非常有用。有关更多信息，请参阅相关博客文章。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/*
This code takes a JSON input string and automatically generates
SQL Server CREATE TABLE statements to make it easier
to convert serialized data into a database schema.

It is not perfect, but should provide a decent starting point when starting
to work with new JSON files.

A blog post with more information can be found at https://bertwagner.com/2018/05/22/converting-json-to-sql-server-create-table-statements/
*/
SET NOCOUNT ON;

DECLARE
   @JsonData nvarchar(max) = '
       {
           "Id" : 1,
           "IsActive":true,
           "Ratio": 1.25,
           "ActivityArray":[true,false,true],
           "People" : ["Jim","Joan","John","Jeff"],
           "Places" : [{"State":"Connecticut", "Capitol":"Hartford", "IsExpensive":true},{"State":"Ohio","Capitol":"Columbus","MajorCities":["Cleveland","Cincinnati"]}],
           "Thing" : { "Type":"Foo", "Value" : "Bar" },
           "Created_At":"2018-04-18T21:25:48Z"

最低0.47元/天解锁文章