I\'ve been put in charge of a 10-year old transactional system where the majority of the business logic is implemented at the database level (triggers, stored procedures, etc). Win2000 server, MSSQL 2
How to alter 开发者_Go百科the datatype of a column in a table?CREATE TABLE dbo.MyTable (column_a INT );
I have a table like that IDORDERTEAMTIME IL-11A_Team11 IL-12A_Team3 IL-13B_Team2 开发者_开发问答 IL-14A_Team1
I have few databses of sql 2000 on windows 2000. Can I attach these databases to another instance of SQL Server 2000 on anothermachine having windows 2003 installed?? D开发者_如何学Gooes attach and de
What is the difference between the following two statements? alter table [dbo].[Demo] add constraint [UC_Demo_Code] unique ( [Code] )
Here is the scenario: SQL Server 2000 (8.0.2055) Table currently has 478 million rows of data. The Primary Key column is an INT with IDENTITY. There is an Unique Constraint imposed on two other colu
I have a trigger which deals with some data for logging purposes like so: CREATE TRIGGER trgDataUpdated
Can anyone give me a hand improving the performance of this cursor logic from SQL 2000. It runs great in SQl2005 and SQL2008, but takes at least 20 minutes to run in SQL 2000. BTW, I would never choos
Here is an example of my code in a DAL. All calls to the database\'s Stored Procedures are structured this way, and there is no in-line SQL.
I\'m somewhat new to SQL and need help with query syntax. My issue involves 2 tables wit开发者_开发技巧hin a larger multi-table join under Transact-SQL (MS SQL Server 2000 Query Analyzer)
加载中,请稍侯......