{"provider_name":"Hatena Blog","image_url":null,"categories":["\u958b\u767a","SQL","Memo"],"published":"2008-02-20 00:00:00","author_name":"fyts","blog_title":"\u30a2\u30b8\u30e3\u30a4\u30eb\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u65e5\u5e38","blog_url":"https://fyts.hatenadiary.org/","url":"https://fyts.hatenadiary.org/entry/20080220/syntax","height":"190","description":"SQL \u306e TOP*1 \u3067\u3059\u304c\u3001\u4eca\u307e\u3067\u6587\u6cd5\u3092\u8aa4\u89e3\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u5b9f\u306f\u3001 expression \u306b\u62ec\u5f27\u304c\u5fc5\u8981\u3060\u3063\u305f\u306e\u3067\u3059\u306d\u3002 SELECT TOP (10) * FROM CUSTOMER \u4eca\u307e\u3067\u62ec\u5f27\u3092\u3064\u3051\u305a\u306b\u66f8\u3044\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001 TOP (Transact-SQL) \u306b\u3088\u308b\u3068\u904e\u53bb\u3068\u306e\u4e92\u63db\u6027\u3067\u6b8b\u3055\u308c\u3066\u3044\u308b\u305d\u3046\u3067\u3059\u3002 \u65e7\u30d0\u30fc\u30b8\u30e7\u30f3\u3068\u306e\u4e92\u63db\u6027\u306e\u305f\u3081\u3001SELECT \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3067 TOP \u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f expression \u3092\u304b\u3063\u3053\u3067\u56f2\u307e\u306a\u304f\u3066\u3082\u51e6\u7406\u304c\u884c\u308f\u308c\u307e\u3059\u304c\u3001\u3053\u308c\u306f\u63a8\u5968\u3055\u308c\u307e\u305b\u3093\u3002 SqlParameter \u3067 TOP \u3092\u4f7f\u304a\u3046\u3068\u601d\u3063\u305f\u3068\u304d\u3001\u62ec\u5f27\u3067\u304f\u304f\u3089\u306a\u3044\u3068\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u53d7\u3051\u4ed8\u3051\u3066\u304f\u308c\u306a\u304b\u3063\u2026","version":"1.0","width":"100%","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ffyts.hatenadiary.org%2Fentry%2F20080220%2Fsyntax\" title=\" SQL \u306e TOP (\u4e0a\u4f4d\u4f55\u4ef6\u3092\u53d6\u5f97) \u306b\u306f\u62ec\u5f27\u304c\u5fc5\u8981\u3060\u3063\u305f - \u30a2\u30b8\u30e3\u30a4\u30eb\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u65e5\u5e38\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/fyts/","type":"rich","title":" SQL \u306e TOP (\u4e0a\u4f4d\u4f55\u4ef6\u3092\u53d6\u5f97) \u306b\u306f\u62ec\u5f27\u304c\u5fc5\u8981\u3060\u3063\u305f"}