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

ZTFLH:

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:

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

[1]	TANG Xiao-qing. A Semi-supervised Linear Subspace Learning Approach via Sparse Coding[J]. 电脑与电信, 2021, 1(8): 44-48.
[2]	CHEN Shuang-quan. Design of Real-time Database for Automatic Measurement and Control System [J]. 电脑与电信, 2021, 1(8): 49-51.
[3]	ZHANG Mei-fengGUO Jie. Design and Development of Sensor Virtual Experiment Platform[J]. 电脑与电信, 2021, 1(5): 15-17.
[4]	ZHANG Shu-rong. Practice of the Cloud Teaching Mode in the Course of Database Programming[J]. 电脑与电信, 2020, 1(8): 71-74.
[5]	YANG Qing-hu. Research on High-quality Teaching Design of Database Foundation Course in Private Vocational Colleges[J]. 电脑与电信, 2020, 1(8): 86-.
[6]	ZHOU Hong-cheng FENG Kai-zheng XIAO Feng . Intelligent Forestry System Design Based on Big Data[J]. 电脑与电信, 2020, 1(4): 56-59.
[7]	ZHAO Hong-fei. Research on Query Optimization Technology of Distributed Database System[J]. 电脑与电信, 2020, 1(3): 55-58.
[8]	GUO Xiao-lei SHI Hong-ye. Design and Development of Wechat Program for Doctors' Follow-up[J]. 电脑与电信, 2020, 1(12): 40-.
[9]	CHENG Min. Study on the“Four-stepAdvance Mode”of Teaching in Database Building and Management Course[J]. 电脑与电信, 2020, 1(10): 22-.
[10]	SUN Pei-yan. Design and Implementation of Class OASystem Based on SQL SERVER[J]. 电脑与电信, 2019, 1(7): 46-48.
[11]	SI Xiao-yun SHEN Zheng LI Wei SUN Wei-hong GUO Hai-jun ZHENG Hong-mei DENG Na. Design and Development of Patient Information Management System Based on SQL Server and C#[J]. 电脑与电信, 2019, 1(6): 20-24.
[12]	LI Bo. Application of Grubbs Criterion in Project Evaluation System[J]. 电脑与电信, 2019, 1(6): 61-63.
[13]	CHEN Ling-ling JIN Xiao-hang TIAN Li-li Feng Qi. Experimental Design and Implementation of the Main Course of Telecommunication Based on LabVIEW[J]. 电脑与电信, 2019, 1(6): 70-74.
[14]	CHENG Yuan-yuan CAO Yan DONG Hui MA Jian. Reform and Practice of the Teaching Model of Database Technology in Higher Vocational Colleges Based on WebQuest[J]. 电脑与电信, 2019, 1(4): 25-27.
[15]	PENG Yan-fang. Analysis of Causes and Countermeasures of Database Monopoly[J]. 电脑与电信, 2019, 1(3): 48-50.

Viewed

Full text

Abstract

Cited

Shared

Discussed