The best way for pager of searching result is use pager in Database side, use stored procedure: Here is a sample : SELECT TOP pageSize *From [TestDB].[dbo].[USER_EVENTS_LOG]Where [LogEventsUserID] not in (select top pageSize * pageID [LogEventsUserID] FROM [TestDB].[dbo].[USER_EVENTS_LOG] order by CreateTime desc) order by CreateTime desc (the pageID start from 0 above, and also it [Read More ...]
Mar 182011
Mar 092011
SQL DateTime Operations: SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE = ’2003-04-09′ SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE between ’2003-04-09′ AND ’2003-04-10′ SELECT * FROM DATE_SAMPLE WHERE CONVERT(CHAR(10),SAMPLE_DATE,120) = ’2003-04-09′(about why use 120 above, please check MSDN here) SELECT * FROM DATE_SAMPLE WHERE SAMPLE_DATE >= ’2003-04-09′ AND SAMPLE_DATE <’2003-04-10′ SELECT * FROM DATE_SAMPLE WHERE DATEPART(YEAR, SAMPLE_DATE) [Read More ...]
Jan 272011
SqlConnection db = new SqlConnection(“connstring”); SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { new SqlCommand(“INSERT INTO TransactionDemo ” + “(Text) VALUES (‘Row1′);”, db, transaction) .ExecuteNonQuery(); new SqlCommand(“INSERT INTO TransactionDemo ” + “(Text) VALUES (‘Row2′);”, db, transaction) .ExecuteNonQuery(); transaction.Commit(); } catch (SqlException sqlError) { transaction.Rollback(); } db.Close();
Oct 072010
How to easily select a specified range records ? such as from #25 to #45 ? samples: record 1 – 20: SELECT TOP 20 * from member where … order by ID record 21 – 40: SELECT TOP 20 * from member where … AND ID NOT IN (SELECT TOP 20 ID FROM member order [Read More ...]
Sep 082010
Both of nchar and nvarchar are character data types that are either fixed-length, nchar, or variable-length, nvarchar, Unicode data and use the UNICODE UCS-2 character set. nchar [ ( n ) ] Fixed-length Unicode character data of n characters. n must be a value from 1 through 4,000. The storage size is two times [Read More ...]