Prior to updating sysdatabases entry for database
It’s based on the ANSI SQL 92 standard but takes this standard into its own hands so to speak, adding that extra touch of flexibility and robustness to the commands that it supports.
Thirdly, as with many RDBMSs, there’s always more than one way to accomplish a particular task.
Throughout this article we will accomplish many things firstly with Enterprise Manager, and then with plain TSQL code in Query Analyzer.
Now that we’ve got a bit of jargon out of the way, let’s create our first database.
Right click on the databases node in the left pane and choose the New Database option.If you take a look at the list of databases under the databases node in the left pane, then you’ll also notice the Northwind and pubs database, which come bundled with the SQL Server 2000 installation.These databases are not tied to the workings of SQL Server 2000 in any way, and you’re free to do whatever you want with them.Before we proceed, however, you should have SQL Server 2000 installed on your machine.I’m running Windows 2000 Advanced Server, but SQL Server 2000 can also be installed on Windows 2000 Server, Windows 2000 Datacenter Server, and Windows NT 4.0 with service pack 5.Try surfing around the Internet and find a popular site that doesn’t use some sort of database to store its content.I bet you’ll have a tough time finding just one popular site (i.e.Once you’ve found it, right click on it and choose the Open Table - Return all rows option.Take a look at the various fields and values in the table, and then close it by pressing Ctrl F4.For example, Enterprise Manager lets you create tables using a familiar point and click interface similar to basic desktop databases like MS Access.Query Analyzer, on the other hand, acts more like command-driven databases such as My SQL, allowing you to get right down to the bare metal and code everything yourself.