Skip to main content

SQL Server Things (Databases, Cursor, Indexes, Tables, Views, Stored Procedure, Functions and Triggers).

This contains the brief of the mentioned topics in the title and the possible best suitable link to explain in the details.


  • Views:  
    A view provides several benefits.


    1. Views can hide complexity: 
      If you have a query that requires joining several tables, or has complex logic or calculations, you can code all that logic into a view, then select from the view just like you would a table.
    2. Views can be used as a security mechanism: 
      A view can select certain columns and/or rows from a table, and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.
    3. Views can simplify supporting legacy code: 
      If you need to refactor a table that would break a lot of code, you can replace the table with a view of the same name. The view provides the exact same schema as the original table, while the actual schema has changed. This keeps the legacy code that references the table from breaking, allowing you to change the legacy code at your leisure.
These are just some of the many examples of how views can be useful.




Below are the links that explains in the better why the views are most powerful and why is brought in to existence as Tables are already available.


  • Stored Procedure
Labels:

Comments

Post a Comment

Popular posts from this blog

All the require docs of job seekers (java docs, testing docs, study materials, genuine consultancy link)

# JUST_FOR  JAVA LOVERS : CORE & ADVANCED JAVA Notes ! Core Java and Advanced Java Notes! . Link 1 :-  https://www.dropbox.com/s/t…/1--%20Core%20Java%28TOC%29.pdf… Link 2 :-  https://www.dropbox.com/s/0ahi8r…/9--%20Advanced%20Java.pdf… _________________________________ 1.  https://drive.google.com/…/0BxJrew1xg5ZLZjdabnVUUkswalk/view 2. https://drive.google.com/…/0BxJrew1xg5ZLVHVSQ0tiU1VmVXM/view 3. https://drive.google.com/…/0BxJrew1xg5ZLdS1JUTAxMWtTcEU/view 4. https://drive.google.com/…/0BxJrew1xg5ZLY1M5bGp2Ym5lZUk/view 5. https://drive.google.com/…/0BxJrew1xg5ZLck13Rndpd1ZlcEU/view 6.  https://drive.google.com/…/0BxJrew1xg5ZLb2xodlhOTEVzLTA/view --------------------- Spring --------------------- https://drive.google.com/…/0BxJrew1xg5ZLQ3VaQnlja3N1Mkk/view https://drive.google.com/…/0BxJrew1xg5ZLTXNVLUdOR0xmTzQ/view https://drive.google.com/…/0BxJrew1xg5ZLWU9PUmVKUUYtMjQ/view ---------------------- Hibernate ---------------------...
Post a Comment
Read more

npm install on windows 7 python2 not found error and node-sass@3.13.1 error #317

Before I write all, I'd like to say that before the update everything worked well; while updating node from version 7.2.1 to version 9.4.0 and npm from version 5.5.1 to version 5.6.0 in Windows 7 (64-bit) using the installer (https://nodejs.org/en/download/) and installing globally gulp-cli version 2.0.0, as far as npm install starts from the JointsWP folder I get the following error: $ npm install npm WARN deprecated babel-preset-es2015@6.24.1: รฐ  Thanks for using Babel: we recommend using babel-preset-env now: please read babeljs.io/env to update! npm WARN deprecated gulp-util@3.0.8: gulp-util is deprecated - replace it, following the guidelines at https://medium.com/gulpjs/gulp-util-ca3b1f9f9ac5 npm WARN deprecated minimatch@2.0.10: Please update to minimatch 3.0.2 or higher to avoid a RegExp DoS issue > uws@0.14.5 install C:\Users\Bob\Dropbox\Development\vhosts\mongoose-project\vanilla\themes\JointsWP\node_modules\uws > node-gyp rebuild > build_log.txt 2>...
1 comment
Read more

Use your mobile phone as web cam to your pc/laptop

 Brief  This thing started when I had an interview😮 with one of the company in Nepal and my laptop camera quality was so bad that I was asked to turn off 😥 it which made me to think to buy a webcam for my laptop and I realized if the webcam be attached to my laptop using USB cable or WIFI then why we cannot use my phone. This is how it started. I have tested it and using this app called iVCam since then it worked very well as well with teams, zoom and other streaming app as well. We need to download these 2 stuffs only: The mobile app. The PC client software. Install these two software on your individual mobile and pc and then you are good to go.Mobile phone will ask for the permissions, and allow all the permission it ask for. There are two by which we can connect your mobile phone as web cam and they are:  A) WIFI: Connect your laptop and mobile to the same wifi network. Open app in both mobile and laptop/pc. It will automatically connect to the mobile camera....
Post a Comment
Read more