sql-server-2000
Limit record like ROWNUM in MS SQL server 2000
I want to know how to limit records in SQL Server 2000. In Oracle, I already wrote a SQL query like that.[详细]
2023-04-03 12:12 分类:问答Median in SQL Server 2000
For even rows formula for median is (104.5 + 108)/2 for table below and For odd rows it is 108 for table below[详细]
2023-04-03 06:57 分类:问答Is it possible to do a GROUP BY in SQL Server 2000 that returns the whole row?
I have an SQL Server 2000 database that contains a view that shows meter readings for supply points which has the following columns:[详细]
2023-04-03 02:52 分类:问答How am I violating this constraint?
I have this constraint in a table: CREATE TABLE [dbo].[InventoryLocations] ( [recid] [int] IDENTITY(1,1) NOT NULL,[详细]
2023-04-03 01:39 分类:问答How do I write a simple insert or update in T-SQL?
I have a process that I do not want to track if something is a create or an update.Tracking would be complex.I would like to perform a create OR update. The schema is like...[详细]
2023-04-02 02:46 分类:问答SQL/C# - Primary Key error on UPSERT
UPDATE(simplified problem, removed C# from the issue) How can I write an UPSERT that can recognize when two rows are the same in the following case...[详细]
2023-04-01 19:47 分类:问答How to insert unique value into non-identity field
I\'m trying to do an insert into an established table which has a primary key fields and another field (call it field1) that is unique (this other unique field has a unique constraint preventing my in[详细]
2023-04-01 17:41 分类:问答how to round up to decimal place like money
I need to round money values up to the nearest cent, then do some operations on that rounded value.I cannot use Round()开发者_开发技巧 because this will also round down.These are all money values.[详细]
2023-04-01 12:34 分类:问答After SQL Server 2008 upgrade, query with UNION runs very slowly
We migrated from SQL Server 2000 to 开发者_StackOverflow社区2008 and a query for some users (in certain database roles) runs very slowly when we use UNION operator. I tried it with UNION ALL[详细]
2023-04-01 07:21 分类:问答Help with 2 loops and an update in SQL Server 2000
I am working on a stored procedure that will trigger once a week so I am not worried about speed as much as getting the thing to 开发者_运维技巧work.[详细]
2023-03-31 06:34 分类:问答