Answer Posted / 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 |
Post New Answer View All Answers
What is a View ? Can we insert, Update and delete a view?
What do I need to start working with sql studio? : sql server management studio
Differentiate between sql temp table vs table variable?
We need to perform what steps in the following order to work with a cursor?
Difference between connected and disconnected database in .net with sql server?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
How we can refresh the view?
What is ems sql management studio? : sql server management studio
What happens if strings are casted into wrong code pages in ms sql server?
What is sql server agent and what are the two modes of authentication in sql server?
What is the purpose of a table?
What is the difference between implicit and explicit transaction?
What is difference between rownum and rowid?
Scalability, Availability, Integration with internet, etc.)?
List the types of recovery model available in sql server?