TechSapphire Friday, 2024-03-29, 1:14 PM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • Main » Entries archive
    Get duplicate records from table
    Select ename from tbemp a where a.eno!=(select Max(eno) from tbemp b where a.ename=b.ename)

    Here eno denotes to employee number and ename denotes to employee name.
    Category: Database | Views: 2214 | Added by: Admin | Date: 2012-09-03 | Comments (0)

    Without Data
    Select * INTO tbem1 from tbemp where 1=2

    Why 1=2?
    Because none of the record could satisfy this condition i.e. 1=2. So no data would be copied into newly created table.

    With Data
    Select * INTO tbemp2 from tbemp

    With Condition
    Select * INTO tbemp3 from tbemp where depcod=102

    Here depcod denotes to department code.


    Category: Database | Views: 2162 | Added by: Admin | Date: 2012-09-03 | Comments (0)

    Select Alternate Row SQL Server

    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.


    Category: Database | Views: 3299 | Added by: Admin | Date: 2012-09-03 | Comments (0)


    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 »
    Category: Programming | Views: 2281 | Added by: Admin | Date: 2012-08-18 | Comments (2)

    Multi language Website using ASP.NET



    Their are 3 Methods for developing multi-language websites:

    1. Replication
    2. Generalized approach
    3. Using Concept of Localization and Globalization

    Replization: This is basic approach used in static websites. In this approach you need to

    create replica of each web page in different languages. Suppose you have 100 web pages in

    your web site and you want to provide same content in 3 languages then you have to create

    300 pages for it.

    This is totally incorrect approach.


    Generalized approach: This approach is supported in ASP.NET version 1.1, 2.0, 3.5 and

    4.0. Means this approach is supported by all version of  ASP.NET.

    Localization and Globalization: This approa ... Read more »
    Category: Programming | Views: 21349 | Added by: Admin | Date: 2012-08-11 | Comments (1)


    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%.

    Broker Calculator

    Download Broker Calculator



    For Customization of this product you could contact us. Thank You.
    Category: Project | Views: 2271 | Added by: Admin | Date: 2012-07-28 | Comments (0)

    Category: Project | Views: 3083 | Added by: Admin | Date: 2012-07-28 | Comments (1)


     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.

    Security Manager



    Security Manager


    For Customization of this product you could contact us. Thank You.

    Category: Project | Views: 1840 | Added by: Admin | Date: 2012-07-28 | Comments (0)


    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.

    Optical Shop

    Download Optical Shop System


    For Customization of this product you could contact us. Thank You.
    Category: Project | Views: 3266 | Added by: Admin | Date: 2012-07-28 | Comments (1)


    This software provide user with facility to manage their Invoice account and other information (it very much like Invoice Account Management System).

    Invoice Info System

    Download Invoice Info System





    For Customization of this product you could contact us. Thank You.
    Category: Project | Views: 2146 | Added by: Admin | Date: 2012-07-28 | Comments (0)

    « 1 2 3 4 5 6 7 »
    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2024