SQL Introduction

SQL is a standard language for accessing and manipulating databases. SQL stands for Structured Query Language and using SQL we can access and manipulate databases.

Usage of SQL against a database:-

• SQL can execute queries
• SQL can retrieve data from a database
• SQL can insert records into a database
• SQL can update records in database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, views, Triggers

 

Related Alrticles

• Download sql-introduction
• Download introduction
• Download get-columns-of-a-table-sql-server
• Download convert-float-value-to-varchar-type-in-ms-sql-server
• Download sql-server-datatypes
• Download set-nocount-on-improves-sql-server-stored-procedure-performance-high
• Download how-attackers-make-sql-injection-attack-what-script-they-used-for-sql-injection
• Download how-to-make-or-use-cursor-in-sql-server
• Download count-duplicate-records-from-table-in-sql-server
• Download delete-duplicate-records-from-table-sql-server
• Download quick-fix-to-prevent-sql-injection-attach-sql-server-Asp-Net-asp
• Download how-to-make-and-use-temporary-tables-in-sql-server
• Download stored-procedure-to-make-listing-and-search-between-to-and-from-date-or-start-date-end-date
• Download use-of-begin-commit-transaction-rollback-in-a-stored-procedure-sql-server
• Download sql-injection-attack-if-you-see-in-page-view-source-http-116jurist-ru
• Download replacing-all-text-within-brackets-or-any-other-special-character-by-ms-sql-query
• Download how-to-update-data-as-first-letter-upper-case-ms-sql-query
• Download rename-a-column-name-or-table-name-stored-procedure-name-in-ms-sql-server
• Download update-existing-column-datatype-in-ms-sql-server-database-without-losing-data
• Download compare-null-values-in-ms-sql-server