sql-server-2000

相关标签：javascript jquery android 多少钱 iPhone

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 分类：问答