Database

SELECT DISTINCT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1 
ORDER BY MSysObjects.Name

EricDV wrote:

I think adding "AND MSysObjects.Flags=0" will exclude system tables, but I'm not 100% on whether or not that is all that will be excluded.

Dim strRestrictions As String() = New String() {Nothing, Nothing, Nothing, "TABLE"}<br />
dtTables = myConnection.GetSchema("tables", strRestrictions)

Dim strRestrictions = New String() {Nothing, Nothing, "myTableName", Nothing}<br />
dtColumns = myConnection.GetSchema("Columns", strRestrictions)

SELECT * FROM MyTable WHERE [date] >= '2006-04-20 00:00:00' AND [date] <= '2006-04-20 23:59:59'

SELECT * FROM MyTable WHERE [date] >= '2006-04-14 00:00:00' AND [date] <= '2006-05-21 23:59:59'

-- Performance is okay
...WHERE DAY([date]) = 22 AND MONTH([date]) = 5 AND YEAR([date]) = 2006
 
-- Performance is abysmal on large datasets and useless if part of a join (What was I thinking!?!)
WHERE [date] = dbo.datetime_rounddown(@someDateTime) 
 
-- Okay as a replacement for a column that is being SELECTed
SELECT dbo.datetime_rounddown([date]) FROM MyTable
 
-- If using a temp table to add an extra column that specifically excluded the time portion

-- Or if the table is sufficiently large, you could add an extra column to hold the date only version

srinuivasaRaoS wrote:

Can any one tell me the actual problem for this

srinuivasaRaoS wrote:

how to avoid this situation

Process 1                        Process 2
Requests Lock on Table A         Requests Lock on Table B
Gets Lock on Table A             Gets Lock on Table B
Requests Lock on Table B         Requests Lock on Table A
Blocks until Table B released    Blocks until Table A is released
 
Deadlock detection kicks in and one of the processed become the deadlock victim
 
                                 Deadlock victim: 
                                 Lock released on Table B and Transaction Rollsback
Gets Lock on Table B
Completes request.

srinuivasaRaoS wrote:

shell i use xml files for updating the each user status, in the sense one xml file will be created per one user.After that i will write another code which will update the status of each user after completion of exam, is it right way ?.If i will do in this way whether i face any problem.Please Let me know