answersLogoWhite

0

View in SQL is a virtual table.It is possible to add SQL functions ,WHERE and JOIN statements to a view.This will help in presenting the data as if coming from a single table.It is possible to update the view also .We can drop a view also if not needed.

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Computer Science

List of data warehousing and mining tools?

weka sql server 2005


Pl sql programs executes in sql server?

PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.


In which os sql server works?

SQL server is a database developed by the Microsoft corporation. The database is built to exclusively work on Microsoft Operating systems like Windows XP, Windows 2000, Windows Vista etc. It works on all Windows based platforms, but it does depend on the Edition of SQL Server you are going to implement. For example you can run SQL Server Express on Windows Server, but you cannot run SQL Server Enterprise on Windows XP. It will only run on Windows Server systems.


When does a SQL server error happen?

Typically, SQL Server errors happen when running scripts. Errors can show up for a number of reasons, likely involving data errors. Fortunately, Microsoft makes the SQL Server and has tech support available.


What do you mean sql client?

In the context of computer programming and database management, an SQL client is a software application or tool that allows users to connect to a database server and execute SQL queries against the database. The SQL client provides an interface for users to enter SQL commands, execute those commands against the database, and view the results. Some examples of SQL clients include MySQL Workbench, Microsoft SQL Server Management Studio, and Oracle SQL Developer. SQL clients are commonly used by database administrators, software developers, data analysts, and other professionals who work with databases. They are essential tools for managing and manipulating data in relational databases. For more information, please visit: 1stepGrow

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.


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


When was SQL Server Management Studio created?

SQL Server Management Studio was created in 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)'


From sql server 2000 and sql 2005 which one is best?

It's a long list check this website: http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/


Which tool is available in sql server 2005 that lets you stop or disable unused components?

sql server management


What is syntax errors in sql server 2005?

wrong sql syntax in your query


What is the sql management studio used for?

SQL Management Studio is a software application that was first released with Microsoft SQL Server 2005. It enables one to configer, manage and collect information through SQL Server 2005.


Where can one download SQL server 2005 video tutorials?

If someone wants SQL server 2005 tutorials then they can be downloaded from YouTube. They can also be watched or downloaded from various SQL teaching and help sites such as sql-form.


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.


IDE which is used in Sql server 2005?

There are many IDE's available that can be used with a SQL Server database. Some of them are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analystsetc.


What is the advantage and disadvantage of sql server 2000 and sql server 2005?

The list of changes is too long to type so here is a website that has everything you ned to know:http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/