
Data base
文章平均质量分 81
sooner01
work hard, play hard
展开
-
select records by Date in SQL Server
1, how to selectassume the table CAS.dbo._Test have a field AuthTime with the type datetime, We may use following SQL to select all the records in 2009-04-06. SELECT *FROM CAS.dbo._TestWHE原创 2009-04-10 17:34:00 · 884 阅读 · 0 评论 -
Insert raw data into a binary data field with ADO
With ADO it’s easy to append some common data type in to a field, such as char, int, short, string, double and so on. Just use the following sentences:rs->Fields->Item[2]->Value = "value";rs->Fiel原创 2009-04-12 10:36:00 · 884 阅读 · 0 评论 -
SQL Server tips
1. Why don’t use “select * ” a) when a new culume isinserted into the DB, the current program may not work.b) The “query optimizer” maynot work. 2. chara) char的数原创 2009-05-13 15:48:00 · 834 阅读 · 0 评论