Database

ALTER TABLE dbo.TableName ADD CONSTRAINT
	PK_KeyName PRIMARY KEY CLUSTERED 
	(
	FieldName
	) ON [PRIMARY]

SELECT * FROM [Order Details]
BEGIN TRANSACTION
DELETE FROM [Order Details]
SELECT * FROM [Order Details]
ROLLBACK TRANSACTION
SELECT * FROM [Order Details]

UPDATE A
SET A3 = B.B3
FROM A
INNER JOIN B ON A.A1 = B.B2

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