建表时设置双主键的sql语句如下:
"Create Table XX_XXX (\
ID Bigint NOT NULL,\
记录_ID BIGINT NOT NULL,\
other varchar(100) NULL,\
constraint PK_XX_XXX PRIMARY KEY CLUSTERED\
(\
ID,\
记录_ID\
)\
)"
当列名以数字开头时
如 3xx BIGINT, 应该用中括号把它们括起来即[3xx] [BIGINT]
石头园 |
|
||
每日收获 |
Copyright © 2024 石头仔
Powered by .NET 9.0 on Kubernetes |