TechSapphire Sunday, 2024-12-22, 5:15 AM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • Main » 2015 » April » 21

    SQL VIEWS and Security


    What View do ?
    • First,  It help you break down complex queries.
    • Secong, Query reusability.
    • Third, Security.(not fully recommendable)

    What is View ?
    View is just a stored query. Can also be said as virtual 
    table. They don't hold any data into them.Data comes from 
    real tables.SQL select query operator (WHERE, ORDER BY, etc)
     can be used with it.

    Script:

    File 1:

    ... Read more »

    Category: Database | Views: 3022 | Added by: Admin | Date: 2015-04-21 | Comments (0)

    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