我是SQL Server的新手,所以请原谅我可能愚蠢的问题。
我有一个数据库,我需要生成随机id,我通过使用newid()
insert into Teams (team_code, team_name, team_short)
values (newid(),test,test)
但问题是team_code
需要在花括号里,我不知道怎么做。
你有什么建议吗?
谢谢^
可以内联进行强制类型转换:
INSERT INTO Teams (team_code, team_name, team_short)
VALUES ('{' + CAST(NEWID() AS VARCHAR(255)) + '}',test,test)
尝试这样做,因为newid() direct not set大括号
DECLARE @ID varchar(max);
SET @ID = newid();
select @ID
insert into Teams (team_code,team_name,team_short) values ('{'+@ID+'}',test,test)
AND try as
insert into Teams (team_code, team_name, team_short) values ('{'+Convert( VARCHAR(max),NEWID())+'}',test,test)
所以你想添加一个前导{和尾随}到创建的唯一标识符字符串?这是SQL Server,对吧?然后用+连接字符串,如下所示:
insert into Teams (team_code, team_name, team_short)
values ('{' + newid() + '}', test, test);