Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
What Is a Transact-SQL Statement?
Submitted by: AdministratorA Transact-SQL statement is a basic execution unit of the Transact-SQL language. Here are some examples of Transact-SQL statements:
* "CREATE TABLE ...;" - A data definition language statement that defines a table.
* "INSERT INTO ...;" - A data manipulation language statement that inserts data into a table.
* "SELECT * FROM ...;" - A query statement that returns data from a table.
* "DROP TABLE ...;" - A data definition language statement that deletes a table.
* "DECLARE @name data_type;" - A declaration statement that defines a local variable.
* "SET @name = expression;" - An assignment statement that assigns a value to a local variable.
* "BEGIN TRANSACTION;" - A transaction management statement that marks the beginning of a transaction.
* "ROLLBACK TRANSACTION;" - A transaction management statement that rolls back all changes of a transaction.
Submitted by: Administrator
* "CREATE TABLE ...;" - A data definition language statement that defines a table.
* "INSERT INTO ...;" - A data manipulation language statement that inserts data into a table.
* "SELECT * FROM ...;" - A query statement that returns data from a table.
* "DROP TABLE ...;" - A data definition language statement that deletes a table.
* "DECLARE @name data_type;" - A declaration statement that defines a local variable.
* "SET @name = expression;" - An assignment statement that assigns a value to a local variable.
* "BEGIN TRANSACTION;" - A transaction management statement that marks the beginning of a transaction.
* "ROLLBACK TRANSACTION;" - A transaction management statement that rolls back all changes of a transaction.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.