{"image_url":null,"categories":["DB"],"version":"1.0","blog_title":"QuadraForce\u2019s Blog","title":"SQL Server\u306e\u30b9\u30ad\u30fc\u30de\u304b\u3089\u7c21\u6613\u30c6\u30fc\u30d6\u30eb\u8a2d\u8a08\u66f8\u3092\u4f5c\u6210\u3059\u308bSQL","provider_name":"Hatena Blog","published":"2009-05-19 22:43:20","author_url":"https://blog.hatena.ne.jp/quadraforce/","provider_url":"https://hatena.blog","author_name":"quadraforce","type":"rich","description":"SQL Server\u306e\u30b9\u30ad\u30fc\u30de\u304b\u3089\u7c21\u6613\u30c6\u30fc\u30d6\u30eb\u8a2d\u8a08\u66f8\u3092\u4f5c\u6210\u3059\u308bSQL\u3067\u3059\u3002 Management Studio\u3067\u51fa\u529b\u5bfe\u8c61\u306eDB\u306b\u5bfe\u3057\u3066\u4e0b\u8a18SQL\u3092\u767a\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002 \u3042\u3068\u306f\u3001\u30af\u30a8\u30ea\u7d50\u679c\u3092Excel\u306b\u3067\u3082\u30b3\u30d4\u30da\u3057\u3066\u52a0\u7b46\u3001\u6574\u5f62\u3057\u3066\u304f\u3060\u3055\u3044\u3002 SELECT C.TABLE_NAME AS TableName, C.ORDINAL_POSITION AS OrdinalPosition, CASE WHEN T1.COLUMN_NAME IS NULL THEN 0 ELSE 1 END AS IsPK, C.COLUMN_NAME AS ColumnName, C.DATA_TYPE AS Data\u2026","width":"100%","url":"https://quadraforce.hatenadiary.org/entry/20090519/1242740600","blog_url":"https://quadraforce.hatenadiary.org/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fquadraforce.hatenadiary.org%2Fentry%2F20090519%2F1242740600\" title=\"SQL Server\u306e\u30b9\u30ad\u30fc\u30de\u304b\u3089\u7c21\u6613\u30c6\u30fc\u30d6\u30eb\u8a2d\u8a08\u66f8\u3092\u4f5c\u6210\u3059\u308bSQL - QuadraForce\u2019s Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190"}