Research of Information Extraction from SQL Server Based on SQL-DMO

Wei Zheng; Ya Ping Wu; Yao Fei Chen

doi:10.4028/www.scientific.net/AMR.468-471.2878

Paper Titles

The Empirical Identification and Analysis of Key Risk Factors of Inventory Financing
p.2859

VHDL Finite State Machine Based Elevator Controller
p.2863

Research of Composite Material Properties Based on Waste Glass and Scrap Aluminum
p.2868

Research and Application of Full-Length Grouted Anchor in Roadway under Mining Face
p.2872

Research of Information Extraction from SQL Server Based on SQL-DMO
p.2878

Removal of Some Heavy Metals by Electrocoagulation
p.2882

Research of Permanent Magnet Synchronous Motor Speed Control System Based on DSP
p.2891

Research and Development of a New Laboratory Mill
p.2895

Research of the Open CNC System Based on PC and Programmable Multi Axes Controller
p.2899

HomeAdvanced Materials ResearchAdvanced Materials Research Vols. 468-471Research of Information Extraction from SQL Server...

Research of Information Extraction from SQL Server Based on SQL-DMO

Abstract:

This article describes the SQL Server object model SQL-DMO. Through the object model all information of SQL Server's internal objects can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object’s information extraction. Get the child object by analyzing the parent object’s collection property and get internal information by analyzing the object’s properties. A visual basic procedure is designed to achieve the table’s structure information for all user tables in specified SQL Server database. This method is more complete and simple than the method based on system table.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Advanced Materials Research (Volumes 468-471)

Pages:

2878-2881

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.468-471.2878

Citation:

Cite this paper

Online since:

February 2012

Authors:

Wei Zheng, Ya Ping Wu, Yao Fei Chen

Keywords:

Information Extraction, Skill Assessment, SQL Server, SQL-DMO

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Xu Jun,Liu Quan Bo,He Ke Kang. CAA new area of research - IT Skills Assessment Automation (1),E-education Research,vol. 105, no. 1(2002),P.33~37.

Google Scholar

[2] Chen Yaofei,Chen Huantong,Ni Yinghua.Automatic Marking in SQL Server Skills Assessment Based on XML, Computer Systems & Applications,Vol.3(2010),P.158-161,186.

Google Scholar

[3] LI Gui-cheng,CUI Jun. Design and implementation of automatic examination paper markingfor database operation,Computer Engineering and Design,vol. 25, no.6(2004), P.1005~1006, 1018.

Google Scholar

[4] Zhao Kai. SQL Server Applications based on SQL-DMO, Ordnance Industry Automation, Vol.23 (2004), P.87-88.

Google Scholar

[5] Gu Hai Jie, Manipulated MS SQL Server database using SQL-DMO, Computer Programming Skills & Intenance, Vol.3 (2002), P.50–53.

Google Scholar