Is SET a SQL Keyword?
Answers were Sorted based on User's Feedback
Answer / radhakrishnan vaithilingam
Yes.
The SET is keyword in SQL Server. The SET is ANSI standard.
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / digvijay
yes, set is assign the value in declared variable.
exaple:--
declare @a int
set @a=20
@a hold the 20.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / ganesh dhage
SET is Reserved word in the SQL Server.Basically SET keyword is used for updating the particular record in the database table with some conditions...If i need to change the name of Student from Student table then i can write query like this->
update Student set Stud_Name=Ganesh
where StudID=201 and Email='abcd@pune.com';
| Is This Answer Correct ? | 1 Yes | 0 No |
Do you know nested transaction?
How will you know when statistics on a table are obsolete?
What is the fastest way to permanently delete a 1 million row table named customers?
Differentiate between a primary key and a unique key.
How to get a list of columns using the "sys.columns" view in ms sql server?
What is temporal data type?
How to transfer a table from one schema to another?
What are the different types of joins and what does each do?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to find 6th highest salary from Employee table ?
Difference Between varchar and nvarchar datatype?
What is cursor in ms sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)