【sqlserver】常用查询操作

22 阅读1分钟

1. 行列转换

1.1 行转列

SELECT value as item
 FROM STRING_SPLIT('1,2,3,a,b,c', ',')

64f485c18f2d436fa5d6b8c4cff32bf9~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg5Y-255Sv_q75.webp