Their are many approaches to get alternate record from SQL server database table. Here i have discussed 2 approaches
1. Complex Query
2. Using Views
Complex Query: SELECT * from (SELECT ROW_NUMBER() OVER(ORDER BY Employee_id) as RowNumber, * from employees) T where t.RowNumber%2=0
Using Views:
CREATE VIEW with_rownumber
as
SELECT ROW_NUMBER() OVER(ORDER BY Employee_id) as RowNumber,* from employees;
SELECT * from with_rownumber where RowNumber%2=0
The approach preferred here is using VIEW because:
1. Easy to understand.
2. In future if you need to perform any operation related to RowNumber
then you don't need to create another complex query. You could use view
having rownumber column in it.
ASP.NET Security Lecture 1
Authentication: Checks user identity Authorization: Check Permissions 4 type of security: 1. Windows Authentication
2. Forms Authentication: Can be customized
3. Passport Authentication
4. None
Web.config
<!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration> <system.web> <compilation debug="true" targetFramework="4.0"/> <authentication mode="Forms"> <forms name="abc" defaultUrl="Default.aspx" loginUrl="Login.aspx">  
... Read more »
This software provide calculator to Brokers to manage their daily money transaction against different Parties and other Brokers. This product by default calculate money interest on rate 1.25%.
This software provide easy interface to user to manage its PC security, this software provides around 2000 restrictions. This software works on registry settings to apply restrictions. This software require administrator permissions to work effectively.
This software provide you facility to maintain your customer details. This also contains the feature which will notify you about customer birthday and other upcoming events.