{"id":2444,"date":"2013-02-20T12:36:04","date_gmt":"2013-02-20T12:36:04","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2444"},"modified":"2013-02-20T12:36:04","modified_gmt":"2013-02-20T12:36:04","slug":"%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e8%a1%a8%e5%8f%98%e9%87%8f","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/02\/20\/%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e8%a1%a8%e5%8f%98%e9%87%8f\/","title":{"rendered":"\u5b58\u50a8\u8fc7\u7a0b\u8868\u53d8\u91cf"},"content":{"rendered":"

2008\u5f00\u59cb\u5b58\u9519\u8fc7\u7a0b\u53ef\u4ee5\u5e26\u8868\u53c2\u6570\uff0c\u4e0d\u8fc7\u9650\u5236\u53ea\u8bfb\u3002<\/p>\n

\n\tCREATE TYPE [dbo].[MyTable] AS TABLE<\/code><\/span><\/span><\/div>\n
\n\t02.<\/code>(<\/code><\/span><\/span><\/div>\n
\n\t03.<\/code>[id] [int],<\/code><\/span><\/span><\/div>\n
\n\t04.<\/code>[value] [nvarchar](128)<\/code><\/span><\/span><\/div>\n
\n\t05.<\/code>)<\/code><\/span><\/span><\/div>\n
\n\t06.<\/code>GO<\/code><\/span><\/span><\/div>\n
\n\t07.<\/code> <\/span><\/span><\/div>\n
\n\t08.<\/code>CREATE PROCEDURE [dbo].[Capitalize]<\/code><\/span><\/span><\/div>\n
\n\t09.<\/code>(<\/code><\/span><\/span><\/div>\n
\n\t10.<\/code>@myTable [dbo].[MyTable] READONLY<\/code><\/span><\/span><\/div>\n
\n\t11.<\/code>)<\/code><\/span><\/span><\/div>\n
\n\t12.<\/code>AS<\/code><\/span><\/span><\/div>\n
\n\t13.<\/code>BEGIN<\/code><\/span><\/span><\/div>\n
\n\t14.<\/code>DECLARE @myOutput [dbo].[MyTable]<\/code><\/span><\/span><\/div>\n
\n\t15.<\/code> <\/span><\/span><\/div>\n
\n\t16.<\/code>INSERT INTO @myOutput([id], [value])<\/code><\/span><\/span><\/div>\n
\n\t17.<\/code>SELECT [id], UPPER([value]) FROM @myTable<\/code><\/span><\/span><\/div>\n
\n\t18.<\/code> <\/span><\/span><\/div>\n
\n\t19.<\/code>SELECT [id], [value] FROM @myOutput<\/code><\/span><\/span><\/div>\n
\n\t20.<\/code>END<\/code><\/span><\/span><\/div>\n
\n\t21.<\/code>GO<\/code><\/span><\/span><\/div>\n
\n\t22.<\/code> <\/span><\/span><\/div>\n
\n\t23.<\/code>DECLARE @myTable [dbo].[MyTable]<\/code><\/span><\/span><\/div>\n
\n\t24.<\/code>DECLARE @myOutput [dbo].[MyTable]<\/code><\/span><\/span><\/div>\n
\n\t25.<\/code> <\/span><\/span><\/div>\n
\n\t26.<\/code>INSERT INTO @myTable([id], [value])<\/code><\/span><\/span><\/div>\n
\n\t27.<\/code>VALUES<\/code><\/span><\/span><\/div>\n
\n\t28.<\/code>(1, 'one'),<\/code><\/span><\/span><\/div>\n
\n\t29.<\/code>(2, 'two'),<\/code><\/span><\/span><\/div>\n
\n\t30.<\/code>(3, 'three')<\/code><\/span><\/span><\/div>\n
\n\t31.<\/code> <\/span><\/span><\/div>\n
\n\t32.<\/code>INSERT INTO @myOutput([id], [value])<\/code><\/span><\/span><\/div>\n
\n\t33.<\/code>EXEC [dbo].[Capitalize] @myTable<\/code><\/span><\/span><\/div>\n
\n\t34.<\/code> <\/span><\/span><\/div>\n
\n\t35.<\/code>SELECT * from @myOutput<\/code><\/span><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

2008\u5f00\u59cb\u5b58\u9519\u8fc7\u7a0b\u53ef\u4ee5\u5e26\u8868\u53c2\u6570\uff0c\u4e0d\u8fc7\u9650\u5236\u53ea\u8bfb\u3002 CREATE TYPE [dbo].[MyTable] AS […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2444","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2444"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2444\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}