sql-server-2000
error with stored procedure logic
I am trying to do something similar to How can I improve this 开发者_开发技巧SQL query? However, in there logic[详细]
2023-03-30 21:22 分类:问答Problem With Sorting in Database
If I run a query like: select * from personaldata order by 3 the we get the sorting according to ascending order of the 3rd column, but if I want to sorting according to descending order, then wh[详细]
2023-03-30 19:52 分类:问答Deleting at most one record for each unique tuple combination
I want to delete at most one record for each unique (columnA, columnB)-tuple in my following delete statement:[详细]
2023-03-30 16:46 分类:问答SQL Server Error: maximum number of prefixes. The maximum is 3. with join syntax
Trying to run a cross-server update: UPDATE ASILIVE.CustomerManagementSystem.dbo.Sessions SET ASILIVE.CustomerManagementSystem.dbo.Sessions.VarianceAmount=Variances.VarianceAmount[详细]
2023-03-29 17:27 分类:问答In T-SQL / SQL Server 2000, referencing a particular row of a result set
I want to reference the nth row of the #temptable (at the second SQL comment is below). What expression will allow me to do so?[详细]
2023-03-29 16:27 分类:问答number of row that repeated
table tbl1 field id,name id=1name=a id=1name=a id=1name=w id=1name=f id=2name=c id=2name=a how can get number of field repeated. i开发者_运维知识库d=1 ,name=a==>2it\'s simple[详细]
2023-03-28 21:23 分类:问答Is there a way to get a list of all current temporary tables in SQL Server?
I realize that temporary tables are session/connection bound and not visible or accessible out of the session/connection.[详细]
2023-03-28 14:25 分类:问答SQL Server 2000 caching
I have one question in order to speed up SQL Server 2000. I want to use caching mechanism, but I don\'t know how to use.[详细]
2023-03-28 10:33 分类:问答Numbering rows in a view
I am connecting to an SQL database using a PLC, and need to return a list of values. Unfortunately, the PLC has limited memory, and can only retrieve approximately 5,000 values at any one time, howeve[详细]
2023-03-27 15:48 分类:问答Does ORDER BY work in SELECT @some_var=
SQL Server 2008r2 Express SP1. I need to make a sting with list of al开发者_C百科l distinct dates in some field for EXEC \'dynamic SQL\'. Of course, dates should be in right order. The code below wor[详细]
2023-03-27 13:20 分类:问答