I\'m working on a online game. I got some problems with inserting new data to table. I\'m getting 2010-4-8 2:14, 37000, 513,
I ha开发者_运维知识库ve table : number city1 city2 mentions 1 a b 5 1 b a 5 1 c d 2 1 d c 2 what I need is to remove duplicate records, such as a, b equal to b,a became :
Does SQL Server maintains any history to track table alterations like column add, delete, rename, type/ length change etc? I found many suggest to use stored procedures to do this manually. But I\'m c
I have a value in the database which is 2.700000002. When I run a query in Management studio in SQL SERVER 2005 I get 2.7. But when I run in SQL SERVER 2000 query analyzer 开发者_JS百科it comes 2.7000
I have one table let\'s say \"xxx \"in sql server 2000 . One .exe is inserting data into that table \"xxx\" throughsql job. But once data is inserted , one stored procedure is reading the data from th
I would like to know how you would run a stored procedure from a page and just \"let it finish\" even if the p开发者_Go百科age is closed. It doesn\'t need to return any data.A database-centric option
Does each column of a tab开发者_运维百科le in SQL Server have a unique id? I\'ve looked into sys.columns and the column_id there is merely the order of the columns which changes if the order of the co
Do you know any function implementation I could use for decrypting da开发者_Python百科ta encrypted by AES/Rijndael in SQL Server 2000?xp_crypt might do it
I have a SQL Server 2000 database with a column of type VARCHAR(255). All the data is either NULL, or numeric data with up to two points of precision (e.g. \'11.85\'). I tried to run the following T-S
I want to save an uploaded image to database. Now my question is: What should be the data type for SQL Server 2000 for image?
加载中,请稍侯......