{"id":416,"date":"2024-01-15T12:13:36","date_gmt":"2024-01-15T10:13:36","guid":{"rendered":"https:\/\/aleksandraleksejev.wordpress.com\/?page_id=416"},"modified":"2024-01-15T12:13:36","modified_gmt":"2024-01-15T10:13:36","slug":"protseduurid-sql-server","status":"publish","type":"page","link":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","title":{"rendered":"PROTSEDUURID\/ SQL SERVER"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">CREATE TABLE kool(\nkoolID int primary key identity(1,1),\nkoolNimi varchar(30),\naadress text,\nkontaktTelefon varchar(13),\nregNumber varchar(20));\nINSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber)\nVALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228');\n\nSELECT * FROM kool<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Use procedureRozhkov;\nGO\nCreate Procedure helloKool AS \nBegin\nSELECT * FROM kool\nEND<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Use procedureRozhkov;\nexec helloKool<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Use procedureRozhkov;\ndrop procedure helloKool<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0448\u043a\u043e\u043b\u044b<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">USE procedureRozhkov;\nGO\nCREATE PROCEDURE AddKool\n    @koolNimi NVARCHAR(20),\n    @aadress text,\n    @kontaktTelefon NVARCHAR(13),\n    @regNumber NVARCHAR(10)\nAS\nINSERT INTO Kool(koolNimi, aadress, kontaktTelefon, regNumber) \nVALUES(@koolNimi, @aadress, @kontaktTelefon, @regNumber)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443, \u043f\u0440\u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u0445\u043e\u0434\u0438\u0442 1 \u0431\u0443\u043a\u0432\u0443 \u0438\u043c\u0435\u043d\u0438 \u0448\u043a\u043e\u043b\u044b \u0438 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u044e\u0442\u0441\u044f \u0432\u0441\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043e \u044d\u0442\u0438\u0445 \u0448\u043a\u043e\u043b\u0430\u0445<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">use procedureRozhkov;\nGO\nCREATE PROCEDURE nimiOtsing\n@taht VARCHAR(1)\nAS\nBEGIN\nSELECT * FROM kool\nWHERE koolNimi LIKE @taht + '%';\nEND;\n\n\/\/\u0437\u0430\u043f\u0443\u0441\u043a\nexec nimiOtsing @taht='T'<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u041f\u0440\u043e\u0446\u0443\u0434\u0443\u0440\u0430 \u043f\u0440\u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0435 \u0441\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0435\u0442 id \u0438 \u0443\u0434\u0430\u043b\u044f\u0435\u0442 \u044d\u0442\u0443 \u0437\u0430\u043f\u0438\u0441\u044c<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">use procedureRozhkov;\nGO\nCREATE PROCEDURE del\n@deleteID int\nAS\nBEGIN\nDELETE FROM kool WHERE koolID=@deleteID;\nSELECT * FROM kool;\nEND\n\n\/\/\u0437\u0430\u043f\u0443\u0441\u043a\nexec deleteID @deleteID=1;<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430 Maksumus<\/em><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">USE procedureRozhkov;\nGO\nCreate procedure kooliMaksumus\n@minHind money output,\n@maxHind money output\nAS\nBEGIN\nSELECT @minHind=MIN(maksumus), @maxHind=MAX(maksumus) FROM kool\nEND\n\n\/\/\u0417\u0430\u043f\u0443\u0441\u043a\ndeclare @minHind money, @maxHind money;\nexecute kooliMaksumus @minHind output, @maxHind output\nPRINT 'minimaalne hind' + CONVERT(varchar,@minHind);\nPRINT 'maksimaalne hind' + CONVERT(varchar,@maxHind);<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-416","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES (&#039;Tallinna Kutsekool&#039;,&#039;Tehnika, 2 Tallinn&#039;,&#039;1337&#039;,&#039;228&#039;); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"google-site-verification\" content=\"tkbGFUaoRuR10CiaeVP2r2eJVzWl5wL0lGtASf0HS_s\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aleksandr Aleksejev Protfoolio - Noorem takvaraarendaja\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio\" \/>\n\t\t<meta property=\"og:description\" content=\"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES (&#039;Tallinna Kutsekool&#039;,&#039;Tehnika, 2 Tallinn&#039;,&#039;1337&#039;,&#039;228&#039;); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-01-15T10:13:36+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-15T10:13:36+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio\" \/>\n\t\t<meta name=\"twitter:description\" content=\"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES (&#039;Tallinna Kutsekool&#039;,&#039;Tehnika, 2 Tallinn&#039;,&#039;1337&#039;,&#039;228&#039;); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3#listItem\",\"position\":1,\"name\":\"\\u0413\\u043b\\u0430\\u0432\\u043d\\u0430\\u044f \\u0441\\u0442\\u0440\\u0430\\u043d\\u0438\\u0446\\u0430\",\"item\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#listItem\",\"name\":\"PROTSEDUURID\\\/ SQL SERVER\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#listItem\",\"position\":2,\"name\":\"PROTSEDUURID\\\/ SQL SERVER\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3#listItem\",\"name\":\"\\u0413\\u043b\\u0430\\u0432\\u043d\\u0430\\u044f \\u0441\\u0442\\u0440\\u0430\\u043d\\u0438\\u0446\\u0430\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\",\"name\":\"Aleksandr Aleksejev Protfoolio\",\"description\":\"Noorem takvaraarendaja\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/extendify-demo-logo.png\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#organizationLogo\",\"width\":96,\"height\":97},\"image\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#webpage\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/\",\"name\":\"PROTSEDUURID\\\/ SQL SERVER - Aleksandr Aleksejev Protfoolio\",\"description\":\"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228'); SELECT * FROM kool \\u0421\\u043e\\u0437\\u0434\\u0430\\u043d\\u0438\\u0435 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \\u0412\\u044b\\u0437\\u043e\\u0432\\u044b \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b Use procedureRozhkov; exec helloKool \\u0423\\u0434\\u0430\\u043b\\u0435\\u043d\\u0438\\u0435 \\u043f\\u0440\\u043e\\u0446\\u0435\\u0434\\u0443\\u0440\\u044b Use procedureRozhkov; drop procedure\",\"inLanguage\":\"et\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#breadcrumblist\"},\"datePublished\":\"2024-01-15T12:13:36+00:00\",\"dateModified\":\"2024-01-15T12:13:36+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"name\":\"Aleksandr Aleksejev Protfoolio\",\"description\":\"Noorem takvaraarendaja\",\"inLanguage\":\"et\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","description":"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228'); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure","canonical_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"tkbGFUaoRuR10CiaeVP2r2eJVzWl5wL0lGtASf0HS_s","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3#listItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/aleksejev21.thkit.ee\/wp3","nextItem":{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#listItem","name":"PROTSEDUURID\/ SQL SERVER"}},{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#listItem","position":2,"name":"PROTSEDUURID\/ SQL SERVER","previousItem":{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3#listItem","name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430"}}]},{"@type":"Organization","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization","name":"Aleksandr Aleksejev Protfoolio","description":"Noorem takvaraarendaja","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","logo":{"@type":"ImageObject","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#organizationLogo","width":96,"height":97},"image":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#webpage","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","name":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","description":"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228'); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure","inLanguage":"et","isPartOf":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website"},"breadcrumb":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#breadcrumblist"},"datePublished":"2024-01-15T12:13:36+00:00","dateModified":"2024-01-15T12:13:36+00:00"},{"@type":"WebSite","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","name":"Aleksandr Aleksejev Protfoolio","description":"Noorem takvaraarendaja","inLanguage":"et","publisher":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization"}}]},"og:locale":"et_EE","og:site_name":"Aleksandr Aleksejev Protfoolio - Noorem takvaraarendaja","og:type":"article","og:title":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","og:description":"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228'); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure","og:url":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","og:image":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","og:image:secure_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","article:published_time":"2024-01-15T10:13:36+00:00","article:modified_time":"2024-01-15T10:13:36+00:00","twitter:card":"summary_large_image","twitter:title":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","twitter:description":"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES ('Tallinna Kutsekool','Tehnika, 2 Tallinn','1337','228'); SELECT * FROM kool \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; GO Create Procedure helloKool AS Begin SELECT * FROM kool END \u0412\u044b\u0437\u043e\u0432\u044b \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; exec helloKool \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b Use procedureRozhkov; drop procedure","twitter:image":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png"},"aioseo_meta_data":{"post_id":"416","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-06-03 11:41:39","updated":"2025-06-05 07:48:05","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aleksejev21.thkit.ee\/wp3\" title=\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\">\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPROTSEDUURID\/ SQL SERVER\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","link":"https:\/\/aleksejev21.thkit.ee\/wp3"},{"label":"PROTSEDUURID\/ SQL SERVER","link":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio\" \/>\n<meta property=\"og:description\" content=\"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Aleksandr Aleksejev Protfoolio\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100011831793026&amp;locale=ru_RU\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Eeldatav lugemisaeg\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/\",\"name\":\"PROTSEDUURID\\\/ SQL SERVER - Aleksandr Aleksejev Protfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\"},\"datePublished\":\"2024-01-15T10:13:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/protseduurid-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PROTSEDUURID\\\/ SQL SERVER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"name\":\"Aleksandr Aleksejev Portfoolio\",\"description\":\"Noorem takvaraarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\",\"name\":\"Aleksandr Aleksejev Portfoolio\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/image.png\",\"width\":1200,\"height\":1200,\"caption\":\"Aleksandr Aleksejev Portfoolio\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=100011831793026&locale=ru_RU\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","og_locale":"et_EE","og_type":"article","og_title":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","og_description":"CREATE TABLE kool( koolID int primary key identity(1,1), koolNimi varchar(30), aadress text, kontaktTelefon varchar(13), regNumber varchar(20)); INSERT INTO kool(koolNimi,aadress,kontaktTelefon,regNumber) VALUES [&hellip;]","og_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","og_site_name":"Aleksandr Aleksejev Protfoolio","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100011831793026&locale=ru_RU","twitter_card":"summary_large_image","twitter_misc":{"Eeldatav lugemisaeg":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/","name":"PROTSEDUURID\/ SQL SERVER - Aleksandr Aleksejev Protfoolio","isPartOf":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website"},"datePublished":"2024-01-15T10:13:36+00:00","breadcrumb":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/protseduurid-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/aleksejev21.thkit.ee\/wp3\/"},{"@type":"ListItem","position":2,"name":"PROTSEDUURID\/ SQL SERVER"}]},{"@type":"WebSite","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","name":"Aleksandr Aleksejev Portfoolio","description":"Noorem takvaraarendaja","publisher":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksejev21.thkit.ee\/wp3\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization","name":"Aleksandr Aleksejev Portfoolio","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#\/schema\/logo\/image\/","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/10\/image.png","contentUrl":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/10\/image.png","width":1200,"height":1200,"caption":"Aleksandr Aleksejev Portfoolio"},"image":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=100011831793026&locale=ru_RU"]}]}},"_links":{"self":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages\/416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/comments?post=416"}],"version-history":[{"count":0,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages\/416\/revisions"}],"wp:attachment":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/media?parent=416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}