I have some ad-hoc reporting users hitting some SQL Server views. Occasionally the read locks taken by these users for particularly lengthy queries caus开发者_开发问答es trouble elsewhere in the syste
UPDATE: the issue does not happen when run against SQL Server 2008. So this is something strange (or wrong) with SQL Server 2000.
As a follow-up to my previous question I would like to know if there is a simple way of doing the following (which doesn\'t compile):
Some how some records in my table are getting updated with value of xyz in a certain column. Out of hundred of stored procedures, functions, triggers, how can I determine which code is doing this acti
I have need of some logic in a stored procedure. All the stored procedure does it perform a couple开发者_开发技巧 of logic rules and then returns a true or false depending on the result.
I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access.
Here\'s my scenario: I have two tables A, B which (for the sake of this question are identical): Table X (PK)
Using SQL Server 2000 Table1 DateHoliday 23-02-20090 24-02-20091 25-02-2009 开发者_开发知识库0 Table2
I have the following script: SELECT left(SHI.FSOKEY, 6) AS [SoNo] ,substring(SHI.FSOKEY, 7, 3) AS [So Item]
Table1 ID Date Intime Outtime A00120000501 12:00:00 22:00:00 A00120000502 14:00:00 22:00:00 A00120000503 12:00:00 23:00:00
加载中,请稍侯......