{"id":506,"date":"2008-04-16T10:30:29","date_gmt":"2008-04-16T09:30:29","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=506"},"modified":"2008-04-16T10:30:29","modified_gmt":"2008-04-16T09:30:29","slug":"solutions-for-common-t-sql-problems","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/04\/16\/solutions-for-common-t-sql-problems\/","title":{"rendered":"Solutions for Common T-SQL Problems"},"content":{"rendered":"<p>Eg\u00e9sz j\u00f3 dolgok vannak <a href=\"http:\/\/code.msdn.microsoft.com\/SQLExamples\">benne<\/a>, \u00e9s gondolom majd b\u0151v\u00edtik m\u00e9g. A <a href=\"http:\/\/code.msdn.microsoft.com\/SQLExamples\/Wiki\/View.aspx?title=NumbersTable&#038;referringTitle=Home\">sz\u00e1mokat tartalmaz\u00f3 t\u00e1bla<\/a> haszn\u00e1lat\u00e1t p\u00e9ld\u00e1ul sokan nem ismerik, pedig hasznos tr\u00fckk\u00f6kre ad lehet\u0151s\u00e9get.<\/p>\n<p>Tetszik ahogy el\u0151\u00e1ll\u00edtj\u00e1k, legt\u00f6bben valami ciklussal pr\u00f3b\u00e1lkozn\u00e1nak, de itt nem:<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT TOP 2147483647 IDENTITY(INT,0,1) AS N\r\nINTO Numbers\r\nFROM sysobjects a, sysobjects b, sysobjects c, sysobjects d, sysobjects e\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Eg\u00e9sz j\u00f3 dolgok vannak benne, \u00e9s gondolom majd b\u0151v\u00edtik m\u00e9g. A sz\u00e1mokat tartalmaz\u00f3 t\u00e1bla haszn\u00e1lat\u00e1t p\u00e9ld\u00e1ul sokan nem ismerik, pedig hasznos tr\u00fckk\u00f6kre&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21,58],"tags":[],"class_list":["post-506","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=506"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}