A Comparative Study of Multiple Table Data Queries Based on SQL Server 2008

Ruibin Xu

2023

Abstract

Using SQL language to complete multi table queries in databases is a key learning point for database learners. This article compares and studies three methods of implementing multi table queries: join query, view query, and stored procedure query, exploring their respective advantages and disadvantages, in order to improve learning efficiency.

Paper Citation

in Harvard Style

Xu R. (2023). A Comparative Study of Multiple Table Data Queries Based on SQL Server 2008. In Proceedings of the 2nd International Seminar on Artificial Intelligence, Networking and Information Technology - Volume 1: ANIT; ISBN 978-989-758-677-4, SciTePress, pages 306-309. DOI: 10.5220/0012282100003807

in Bibtex Style

@conference{anit23,
author={Ruibin Xu},
title={A Comparative Study of Multiple Table Data Queries Based on SQL Server 2008},
booktitle={Proceedings of the 2nd International Seminar on Artificial Intelligence, Networking and Information Technology - Volume 1: ANIT},
year={2023},
pages={306-309},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0012282100003807},
isbn={978-989-758-677-4},
}

in EndNote Style

TY - CONF

JO - Proceedings of the 2nd International Seminar on Artificial Intelligence, Networking and Information Technology - Volume 1: ANIT
TI - A Comparative Study of Multiple Table Data Queries Based on SQL Server 2008
SN - 978-989-758-677-4
AU - Xu R.
PY - 2023
SP - 306
EP - 309
DO - 10.5220/0012282100003807
PB - SciTePress