Implementation of Multi Table Data Query in SQL Server2008

Computer & Telecommunication

Current Issue | Archive | Adv Search

YANG Hao-yu

Kunming Vocational and Technical College of Industry

Download:

PDF(0KB)
Export: BibTeX | EndNote (RIS)

Abstract As the key point of database operation, data query has always been the focus of learning, multi table query is one of the most important and difficult points to learn. This paper discusses on the advantages and disadvantages of three ways to query in multi table: SQL statement, view and storage procedure.

Key words： database SQL view storage procedure

TP311.13

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	YANG Hao-yu

Cite this article:

YANG Hao-yu. Implementation of Multi Table Data Query in SQL Server2008. Computer & Telecommunication, 2017, 1(11): 80-81.

URL:

https://www.computertelecom.com.cn/EN/ OR https://www.computertelecom.com.cn/EN/Y2017/V1/I11/80

[1]	WANG Yu-lin　WANG Jin-heng　ZHAO Yu-qi　XIE Xiao-hui. Teaching Innovation and Practice of "Triple Optimization and Innovation" in the Course of Database Principle and Application in Private Universities under the Background of Information Technology Innovation[J]. 电脑与电信, 2024, 1(5): 42-.
[2]	LIU Ping　WANG Shi-wei　JIANG Meng-yun. Research on the Ideological and Political Education in the Courses of Embedded System in Applied Undergraduate[J]. 电脑与电信, 2024, 1(3): 24-.
[3]	WANG Zi-ming　XIAO Da-wei　LIU Ya-nan. Knowledge Graph Construction for Data Science and Big Data Technology[J]. 电脑与电信, 2024, 1(1): 32-34.
[4]	TANG Xiao-qing. A Semi-supervised Linear Subspace Learning Approach via Sparse Coding[J]. 电脑与电信, 2021, 1(8): 44-48.
[5]	CHEN Shuang-quan. Design of Real-time Database for Automatic Measurement and Control System [J]. 电脑与电信, 2021, 1(8): 49-51.
[6]	ZHANG Mei-fengGUO Jie. Design and Development of Sensor Virtual Experiment Platform[J]. 电脑与电信, 2021, 1(5): 15-17.
[7]	YUAN Jing. Research on the Resource Library Model of Database Course Based on Cloud Storage [J]. 电脑与电信, 2021, 1(12): 50-52.
[8]	CHEN Ya-rui YANG Guang. Research and Practice of Blended Teaching Mode Based on OBE under the Background of New Engineering--Take Database Principle Course for Example [J]. 电脑与电信, 2021, 1(12): 66-68.
[9]	YANG Yu. Research and Design of a Data Acquisition and Analysis Platform [J]. 电脑与电信, 2021, 1(11): 90-94.
[10]	WANG Jin LV Tai-zhi. Design and Implementation of Student Award System Based on Spring Boot + Vue [J]. 电脑与电信, 2021, 0(10): 52-55.
[11]	ZHANG Shu-rong. Practice of the Cloud Teaching Mode in the Course of Database Programming[J]. 电脑与电信, 2020, 1(8): 71-74.
[12]	YANG Qing-hu. Research on High-quality Teaching Design of Database Foundation Course in Private Vocational Colleges[J]. 电脑与电信, 2020, 1(8): 86-.
[13]	ZHOU Hong-cheng FENG Kai-zheng XIAO Feng . Intelligent Forestry System Design Based on Big Data[J]. 电脑与电信, 2020, 1(4): 56-59.
[14]	ZHAO Hong-fei. Research on Query Optimization Technology of Distributed Database System[J]. 电脑与电信, 2020, 1(3): 55-58.
[15]	GUO Xiao-lei SHI Hong-ye. Design and Development of Wechat Program for Doctors' Follow-up[J]. 电脑与电信, 2020, 1(12): 40-.

Viewed

Full text

Abstract

Cited

Shared

Discussed