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 |
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What command is used to create a database in the sql server and how?
What is the difference between views and stored procedures? Can we have input parameters for views?
Explain a differential backup?
How to connect PK and FK?
What are the essential components of sql server service broker?
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
Do you know what is replace and stuff function in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What do you understand by hotfixes and patches in sql server?
What is data integrity? Explain constraints?
How to find the date and time of last updated table?
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)