Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

I want to retrieve names having single quotes. To do this i tryed as select * from hospital where name like' " ' " ' and select * from hospital where name like ''' . But I failed with these two ways . Please help me to do this

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi, MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever). Is there a flag/setting in the DB...

what is the diffrence in DBMS and RDBMS?

Well Mr. Aprato, What I was trying to tell is. I have a database (SQL SERVER 2005 database) with a single table having Seven columns. i.e. Date column, FirstNumber column, SecondNumber column.....up to FifthNumber and lastly BonusNumber. In this case I have already connect the database to a form in VISUAL...

I want to write a SQL server 2005 QUERY to return sets of numbers which meet a specified criteria and at the same time give color to the numbers which match the input numbers. I have seen this type of function in US-POWERBALL LOTTO. See this URL www Search Winning Numbers From: 1/30/2008 1/26/2008 1...

Hi I have a table (Sql server 2000) which has 14 cost columns for each record, and now due to a new requirement, I have 2 taxes which needs to be applied on two more fields called Share1 and share 2 e.g Sales tax = 10% Use Tax = 10% Share1 = 60% Share2 = 40% So Sales tax Amt (A) = Cost1 * Share1 * Sales...

$50,000 of free software from xSQL Software... xSQL Software is giving away 100 free licenses of their software...that is $50,000 worth of free software! Special thanks to the team over at xSQL Software for this generous offering. Check out xSQL Software because they have a number of valuable SQL Server...

arunraj_c, Thank you for the posting. This could be a good tip. If you were interested we would be interested in seeing a comparision and contrast with the version of Profiler from Microsoft that ships with the Standard or Enterprise Edition. Let us know if you would be interested. Thank you, The MSSQLTips...