prikaz prve stranice dokumenta Okidači i pohranjene procedure u sustavu MS SQL Server 2019
Access restricted to authenticated users
undergraduate thesis
Okidači i pohranjene procedure u sustavu MS SQL Server 2019
Varaždin: University of Zagreb, Faculty of Organization and Informatics, 2023. urn:nbn:hr:211:183672
Žunec, Mateja
University of Zagreb
Faculty of Organization and Informatics
Department of Theoretical and Applied Foundations of Information Sciences

Institutional repository: Faculty of Organization and Informatics - Digital Repository

Cite this document

Žunec, M. (2023). Okidači i pohranjene procedure u sustavu MS SQL Server 2019 (Undergraduate thesis). Varaždin: University of Zagreb, Faculty of Organization and Informatics. Retrieved from https://urn.nsk.hr/urn:nbn:hr:211:183672

Žunec, Mateja. "Okidači i pohranjene procedure u sustavu MS SQL Server 2019." Undergraduate thesis, University of Zagreb, Faculty of Organization and Informatics, 2023. https://urn.nsk.hr/urn:nbn:hr:211:183672

Žunec, Mateja. "Okidači i pohranjene procedure u sustavu MS SQL Server 2019." Undergraduate thesis, University of Zagreb, Faculty of Organization and Informatics, 2023. https://urn.nsk.hr/urn:nbn:hr:211:183672

Žunec, M. (2023). 'Okidači i pohranjene procedure u sustavu MS SQL Server 2019', Undergraduate thesis, University of Zagreb, Faculty of Organization and Informatics, accessed 07 May 2024, https://urn.nsk.hr/urn:nbn:hr:211:183672

Žunec M. Okidači i pohranjene procedure u sustavu MS SQL Server 2019 [Undergraduate thesis]. Varaždin: University of Zagreb, Faculty of Organization and Informatics; 2023 [cited 2024 May 07] Available at: https://urn.nsk.hr/urn:nbn:hr:211:183672

M. Žunec, "Okidači i pohranjene procedure u sustavu MS SQL Server 2019", Undergraduate thesis, University of Zagreb, Faculty of Organization and Informatics, Varaždin, 2023. Available at: https://urn.nsk.hr/urn:nbn:hr:211:183672

Metadata
TitleOkidači i pohranjene procedure u sustavu MS SQL Server 2019
Title (english)Triggers and stored procedures in MS SQL Server 2019
AuthorMateja Žunec
MentorKornelije Rabuzin (mentor)
MBZ: 246472
Committee memberRuben Picek (član povjerenstva)
MBZ: 241564
GranterUniversity of Zagreb
Faculty of Organization and Informatics
(Department of Theoretical and Applied Foundations of Information Sciences)
Varaždin
Defense date and country2023-09-01, Croatia
Scientific / art field,
discipline and subdiscipline		SOCIAL SCIENCES
Information and Communication Sciences
Organization and Informatics
Abstract
Tema ovog rada je Okidači i pohranjene procedure u sustavu MS SQL Server 2022. Za potrebe izrade rada koristili su se programi Visual Studio Code 2022 i MS SQL Server 2022. Kroz rad se opisuju navedeni alati koje koristimo za izradu baze podataka. Rad se bavi izradom baze podataka za potrebe projekta koji provodi razne aktivnosti za svoje sudionike. Kako bi se olakšala sama organizacija te provođenje aktivnosti stvara se baza podataka u koju se upisuju potrebni podaci vezani za projekt. Pohranit će se osnovne informacije vezane za sudionike, aktivnosti, dvorane i termine u kojima se aktivnosti odvijaju. Preko stvorene baze podataka u radu su prikazani način korištenja okidača i pohranjenih procedura u spomenutim programima te su prikazane prednosti koje nam one nude. Okidač se automatski pokreće kada se dogodi određeni događaj te su u radu prikazana dva tipa okidača, INSTEAD OF i AFTER okidači. Pohranjene procedure zahtijevaju ručno upisivanje naredbe za pozivanje određene pohranjene procedure. Na samom kraju rada donesen je zaključak na ovu temu.
Keywords
Languagecroatian
URN:NBNurn:nbn:hr:211:183672
Study programmeTitle: Information Systems
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike (sveučilišni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) informatike)
Type of resourceText
File originBorn digital
Access conditionsAccess restricted to authenticated users
Terms of useLicence Attribution 3.0 Unported (CC BY 3.0) icon
Created on2023-09-04 04:00:24