0
Why not trigger in SQL Server 2000?
I think you need to understand what the definition of a database trigger is in this case. A database trigger is simply code that the database system will trigger when a certain event occurs.
The classic example is having a multi-table order system that has the order # in one table and parts ordered linked in a orderDetails table, with the order pointing to the product description in a separate table.
So a useful trigger would be that when an order gets deleted from the order table, all the matching order detail rows in the orderDetails table get deleted.
Hope this helps.
What else can I help you with?
Example for trigger creation in SQL server in 2000 and syntex for it?
please i want learn trigger and procedure but i don't know anything i know some commend in sql server can any person help me this is my email nassir_farhan1@yahoo.com
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 has the author Patrick Dalton written?
Patrick Dalton has written: 'SQL server 2000 black book' -- subject(s): Client/server computing, Relational databases, SQL server 'Microsoft SQL Server black book' -- subject(s): Client/server computing, Database management, SQL server
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/
How to backup sql database?
Use program way backup and recovery. Tool repair sql database any version starting with MS SQL Server 2000, including SQL 2005.-------------You can backup SQL server database using SQL Server Management Studio (SSMS), T-SQL or PowerShell.Limitation: Backup created using higher version can't be restored in earlier version of SQL server.
What is the difference between sql server and ms sql 2000 database?
SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/
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/
What is SQL Server Training about?
SQL server training is designed to help system administrators learn the everyday tasks they will need to keep their server up and running at optimum performance.
Introduction to sql server?
The nintroduction sql server is are the following
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.
