answersLogoWhite

0

Differences between set and select in sql server 2005?

Updated: 8/17/2019
User Avatar

Ksuvarnakumar

Lvl 1
12y ago

Best Answer

SELECT word is use to retrieve the records from the database.

SET word is use whenever you want to update the the table.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Differences between set and select in sql server 2005?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


Diff between sql server 2000 and sql server 2005?

Hi Everybody, I am Vijay.According 2 me the differences are: 1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio. 2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype 3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.


What is deffirence between sql server 2005 and oracle?

oracle runs on any platform whereas sql server runs only on windows.


Describe IDE of SQL Server 2005?

An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts


What are the differences between MySQL and SQL Server 2005?

MySQL is an open source database - MS SQL Server (any version),being a Microsoft product, isn't, and can only be used on MS Servers. MySQL is popular for 'net applications because it runs on Linux servers, and again, being open source, is a lot cheaper and more popular.


What are the release dates for Dramatic Differences - 2005 TV?

Dramatic Differences - 2005 TV was released on: USA: 2005


When was SQL Server Management Studio created?

SQL Server Management Studio was created in 2005.


When was Subsonic - media server - created?

Subsonic - media server - was created on 2005-02-10.


Where can one get SQL Server 2005 downloads?

The best way in order to get an SQL Server 2005 installation package would be to go to the related Microsoft SQL Server 2005 download page. The "Express" edition is free of cost and can be redistributed with own applications - all other versions of Microsoft SQL server can only be legally purchased.


What kind of databases and database servers does MySpace use?

MySpace is use Microsoft SQL server 2005 for database & database server.


What are the release dates for Classical Differences Reflections on Class in Rhode Island - 2005?

Classical Differences Reflections on Class in Rhode Island - 2005 was released on: USA: 2005


What has the author Louis Davidson written?

Louis. Davidson has written: 'Pro SQL Server 2005 Database Design and Optimization' 'Pro SQL server 2008 relational database design and implementation' -- subject(s): Client/server computing, SQL server 'Pro SQL Server 2005' 'SQL Server 2000 Stored Procedures Handbook (Expert's Voice)'