Greg Low, Development Expert Return to SQL Server tables FAQs 5. What script will select a specific record from a table?
CREATE TABLE TestTable ( ID int, TestDate datetime ) GO INSERT TestTable VALUES(1,’20051231′) INSERT TestTable VALUES(1,’20051230′) INSERT TestTable VALUES(1,’20051230′) INSERT TestTable VALUES(1,’20051229′) INSERT TestTable VALUES(2,’20051230′) INSERT TestTable VALUES(3,’20051229′) INSERT TestTable VALUES(3,’20050101′) GO
