Database

void CDaoWorkspace::Create(LPCTSTR lpszName, LPCTSTR lpszUserName, LPCTSTR lpszPassword)
{
  ...

	// Get the DAODBEngine interface and initialize if necessary
	_AFX_DAO_STATE* pDaoState = AfxGetDaoState();
	if (pDaoState->m_pDAODBEngine == NULL)
		InitializeEngine();
  ...
}

pDaoState->m_pDAODBEngine->put_SystemDB(THIS_BSTR SystemDBPath);

SELECT Samples.ID, P1.PicName AS PicName1, P2.PicName AS PicName2, P3.PicName AS PicName3
FROM
   Samples
INNER JOIN
   Pics P1 ON Samples.PicID1 = P1.ID
INNER JOIN
   Pics P2 ON Samples.PicID2 = P2.ID
INNER JOIN
   Pics P3 ON Samples.PicID3 = P3.ID
-- insert WHERE clause here

Select Samples.ID
,(Select Pics.PicName where ID=Samples.PicID1) as FirstPic
,(Select Pics.PicName where ID=Samples.PicID2) as SecondPic 
,(Select Pics.PicName where ID=Samples.PicID3) as ThirdPic

SELECT COUNT(*) AS RowCount
FROM tbl
WHERE tblAccount = 2828;

USE database
EXEC sp_spaceused

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)

CREATE TRIGGER tg_timestamp ON MyTable
FOR INSERT, UPDATE
AS
UPDATE MyTable
SET TimeStampField = GETUTCDATE()
WHERE PrimaryKey IN
  ( SELECT PrimaryKey FROM inserted )