tag:blogger.com,1999:blog-2288923101279501593.post6574396291030200691..comments2023-07-03T21:41:44.529+08:00Comments on 賈氏柏的屋簷下: 在 SQL 上使用 JSONjasper-hsiahttp://www.blogger.com/profile/01800228219721508515noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2288923101279501593.post-51275823866418262762022-02-09T14:45:36.551+08:002022-02-09T14:45:36.551+08:00是一個 Table 的資料型態
CREATE TYPE [dbo].[pjsonData] AS T...是一個 Table 的資料型態<br />CREATE TYPE [dbo].[pjsonData] AS TABLE(<br /> [id] [int] NOT NULL,<br /> [parent] [int] NOT NULL,<br /> [name] [nvarchar](100) NOT NULL,<br /> [kind] [nvarchar](10) NOT NULL,<br /> [value] [nvarchar](max) NOT NULL<br />)<br />GO<br />jasper-hsiahttps://www.blogger.com/profile/01800228219721508515noreply@blogger.comtag:blogger.com,1999:blog-2288923101279501593.post-44524343663908088952020-08-13T15:18:39.610+08:002020-08-13T15:18:39.610+08:00請問一下 pJsonData 這部份是什麼呢?請問一下 pJsonData 這部份是什麼呢?Pochenghttps://www.blogger.com/profile/15428703498575446897noreply@blogger.com