{"height":"190","version":"1.0","provider_url":"https://hatena.blog","blog_url":"https://mftech.hatenadiary.org/","title":"Microsoft SQL Server \u65e5\u4ed8\u8a08\u7b97\u306b\u3064\u3044\u3066","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/m/mftech/20100823/20100823105102.jpg","author_name":"mftech","url":"https://mftech.hatenadiary.org/entry/20100818/1282122704","provider_name":"Hatena Blog","width":"100%","published":"2010-08-18 18:11:44","categories":["chujianglei","SQL"],"author_url":"https://blog.hatena.ne.jp/mftech/","blog_title":"\u30c6\u30af\u30e4\u30f3 - \u30de\u30a4\u30f3\u30c9\u30d5\u30ea\u30fc .NET \u30ab\u30d5\u30a7","description":"\u3053\u3093\u306b\u3061\u306f\u3001chujianglei\u3067\u3059\u3002 \u4eca\u56de\u306f\u3001Microsoft SQL Server\u3067\u306e\u65e5\u4ed8\u8a08\u7b97\u3092\u3054\u7d39\u4ecb\u3044\u305f\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u4f5c\u696d\u3067\u306f\u3001\u65e5\u4ed8\u306b\u95a2\u6570\u3059\u308b\u8a08\u7b97\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002 \u521d\u5fc3\u8005\u306b\u306f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u4e0a\u3067\u65e5\u4ed8\u306e\u8a08\u7b97\u306b\u3064\u3044\u3066\u5206\u304b\u3089\u306a\u3044\u3068\u304b\u3001\u6163\u308c\u3066\u306a\u3044\u65b9\u304c\u3044\u308b\u3068\u601d\u3044\u307e\u3059\u3002 \u3053\u3053\u3067\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u4e0a\u3067\u65e5\u4ed8\u306e\u6c42\u3081\u65b9\u3092\u7e8f\u3081\u3066\u898b\u307e\u3057\u305f\u3002\u7686\u3055\u3093\u306b\u304a\u5f79\u306b\u7acb\u3066\u308c\u3070\u5e78\u3044\u3067\u3059\u3002 /* \u6307\u5b9a\u65e5\u306b\u3064\u3044\u3066\u306e\u8a08\u7b97 */ DECLARE @Date DATETIME SET @Date=GETDATE() -- \u6307\u5b9a\u65e5\u306e\u524d\u65e5\u3092\u6c42\u3081\u308b SELECT DATEADD(DAY,-1,@Date) AS '\u524d\u65e5' -- \u6307\u2026","type":"rich","html":""}