{"id":415,"date":"2023-05-15T14:54:36","date_gmt":"2023-05-15T06:54:36","guid":{"rendered":"https:\/\/www.keioi.cn\/?p=415"},"modified":"2023-05-15T14:54:37","modified_gmt":"2023-05-15T06:54:37","slug":"sql%e5%87%bd%e6%95%b0%e6%88%96%e6%b8%b8%e6%a0%87","status":"publish","type":"post","link":"https:\/\/www.keioi.cn\/archives\/415","title":{"rendered":"SQL\u51fd\u6570\u6216\u6e38\u6807"},"content":{"rendered":"\n

declare @t table (i int identity(1,1) not null , name nvarchar(100),country nvarchar(100) )
declare @na nvarchar(100)
insert @t (name)values(‘\u5927\u4f17’),(‘\u4e30\u7530’),(‘\u65e5\u4ea7’),(‘\u5409\u5229’),(‘\u522b\u514b’),(‘\u672c\u7530’),(‘\u6bd4\u4e9a\u8fea’)<\/p>\n\n\n\n

if exists(select name from @t)
begin
select @na=name from @t
if @na in (‘\u5409\u5229’,’\u6bd4\u4e9a\u8fea’)
print ‘\u56fd\u4ea7’
else
print ‘\u5408\u8d44’
end<\/p>\n\n\n\n

\u5982\u4e0a\uff0c\u8fd9\u4e2a\u53ea\u663e\u793a\u6700\u540e\u4e00\u6761\uff0c\u4e0d\u80fd\u6279\u91cf\u5904\u7406\uff0c<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u7f16\u5199\u51fd\u6570\u5355\u6761\u7ed3\u679c\u5904\u7406\uff0c\u52a0\u5165\u53c2\u6570\u3002<\/strong><\/p>\n\n\n\n

create function funcname<\/p>\n\n\n\n

(<\/p>\n\n\n\n

@arg nvarchar(100) —\u4f20\u5165\u53c2\u6570<\/p>\n\n\n\n

)<\/p>\n\n\n\n

returns nvarchar(100)<\/p>\n\n\n\n

as <\/p>\n\n\n\n

begin<\/p>\n\n\n\n

declare @t table (i int identity(1,1) not null , name nvarchar(100),country nvarchar(100) )
declare @na nvarchar(100)
insert @t (name)values(‘\u5927\u4f17’),(‘\u4e30\u7530’),(‘\u65e5\u4ea7’),(‘\u5409\u5229’),(‘\u522b\u514b’),(‘\u672c\u7530’),(‘\u6bd4\u4e9a\u8fea’)<\/p>\n\n\n\n

if exists(select name from @t)
begin<\/p>\n\n\n\n

declare @c nvarchar(100)
select @na=name from @t where name=@arg
if @na in (‘\u5409\u5229’,’\u6bd4\u4e9a\u8fea’)
set @c=’\u56fd\u4ea7’
else
set @c=’\u5408\u8d44’
end<\/p>\n\n\n\n

return @c<\/p>\n\n\n\n

end<\/p>\n\n\n\n

\u51fd\u6570\u8fd4\u56de\u8868\u503c<\/strong><\/p>\n\n\n\n

create function funcname<\/p>\n\n\n\n

(<\/p>\n\n\n\n

@arg nvarchar(100) —\u4f20\u5165\u53c2\u6570<\/p>\n\n\n\n

)<\/p>\n\n\n\n

returns @t table(<\/p>\n\n\n\n

i int,<\/p>\n\n\n\n

name varchar(100)<\/p>\n\n\n\n

)<\/p>\n\n\n\n

as<\/p>\n\n\n\n

begin<\/p>\n\n\n\n

….<\/p>\n\n\n\n

return<\/p>\n\n\n\n

end<\/p>\n\n\n\n

\u6279\u91cf\u5904\u7406\uff0c\u6e38\u6807<\/strong><\/p>\n\n\n\n

declare @t table (i int identity(1,1) not null , name nvarchar(100),country nvarchar(100) )
declare @na nvarchar(100)
insert @t (name)values(‘\u5927\u4f17’),(‘\u4e30\u7530’),(‘\u65e5\u4ea7’),(‘\u5409\u5229’),(‘\u522b\u514b’),(‘\u672c\u7530’),(‘\u6bd4\u4e9a\u8fea’)
–select * from @t
if exists(select name from @t)
begin
declare curs cursor for
select name from @t
open curs
fetch next from curs into @na
while(@@FETCH_STATUS=0)
begin
if @na in(‘\u5409\u5229’,’\u6bd4\u4e9a\u8fea’)
print @na+’,\u56fd\u4ea7’
–update @t set country=’\u56fd\u4ea7’ where name=@na
else
print @na+’,\u5408\u8d44’
–update @t set country=’\u5408\u8d44’ where name=@na
fetch next from curs into @na
end
close curs
deallocate curs
end<\/p>\n\n\n\n


–select * from @t<\/p>\n\n\n\n

\u5982\u4e0b<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

declare @t table...<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-415","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/comments?post=415"}],"version-history":[{"count":1,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/415\/revisions"}],"predecessor-version":[{"id":420,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/415\/revisions\/420"}],"wp:attachment":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/media?parent=415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/categories?post=415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/tags?post=415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}