Promotic
WikipediaLinkedInYoutubeTwitterFacebook

List of statements and stored procedures of the database language MS SQL Server

ALTER TABLE Change the structure of an existing database table. It is possible to add, delete or change the column.
BACKUP DATABASE Database backup
CREATE TABLE Create new database table.
DELETE Delete rows in the table
DROP TABLE Delete database table
INSERT Delete new record into the table
RESTORE DATABASE Restore the database from the backup
SELECT Data query. The result is always in the table form.
sp_addlogin Create a login account for the connection to the SQL Server instance with using the SQL Server authentication
sp_addrolemember Add an account as a database role member of the SQL Server in the current database
sp_addsrvrolemember Add an account as a fixed role member of the SQL Server
sp_grantdbaccess Enable an access of the specified login account to the current database
sp_password Change the password of the login account
sp_rename Change the name of a user created object (table, column, etc.) in the current database
sp_tables Returns a list of objects that can appear in the clause FROM (tables, views)
UPDATE Change values in the existing table record
USE Change the database context (current, default database)
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice