Paging in sql server

select * from (
select t1.*, t2.* ,ROW_NUMBER() OVER (order by t1.siteID ) AS RowNo
from t1
inner join t2 on (t1.f1 = t2.f1)
)

as A where A.RowNo between @beginRowNo and @endRowNum

Web synchronization option for merge replication

http://msdn2.microsoft.com/en-us/library/ms151319.aspx SQL Server 2005 Books Online Implementing Replication over the Internet Replicating data over the Internet allows remote, disconnected users to access data when they need it using a connection to the Internet. Replicate data over the Internet using: A Virtual Private Network (VPN). For more information, see Publishing Data over the Internet Using VPN . The Web synchronization option for merge replication. For more information, see Web Synchronization for Merge Replication . All types of Microsoft SQL Server replication can replicate data over a VPN, but you should consider Web synchronization if you are using merge replication.

html5 file upload

Note: slice method from File API was replaced by mozSlice in Firefox and webkitSlice in Google Chrome

Request Signatures in Blackberry

Request Signatures in Blackberry need copy sigtool.db, sigtool.csk to SDK/component/Bin folder for example V 4.2.1 ../eclipse\plugins\net.rim.eide.componentpack4.2.1_4.2.1.17\components\bin

Field Mapping

Search This Blog