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 |
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
what is the different types of backups available in sql server? : Sql server database administration
What is a Lock and let me know Different types of locks?
What is a rownum?
Who developed sql server?
What is a heap?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is dimension table? : sql server analysis services, ssas
How to delete duplicate records based on single column from a table?
0 Answers Petranics Solutions,
how insert selected column only ?
What command do we use to rename a db, a table and a column?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
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)