Context Navigation

lib825mssql

v23	v24
72	72	}}}
73	73
74		Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. The library has a new function !AppendLimitClause to automatically append the correct syntax without having to use an if condition.
	74	Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. Microsoft SQL 2012 and above have "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY" that achieves the same function. (Microsft SQL requires "ORDER BY" clause immediately before this. The library has a new function !AppendLimitClause to automatically append the correct syntax without having to use an if condition.
75	75
76	76	{{{#!c++