Skip to main content
Search
Search This Blog
Code - Snippet
codes for my personal use, anyone who finds it useful can use my code.
Posts
November 18, 2020
FOREIGN KEY - THINGS TO KNOW (MS SQL SERVER)
November 18, 2020
Primary key - things to know (MS sql server )
November 18, 2020
Column adding -ms sql server
November 17, 2020
Index- unique and non unique
November 17, 2020
Index - Advantage and Disadvantage.
November 17, 2020
Index - Non-Clustered Index - similar to index of a text book's table of content which is always in separate page, similarly non clustered index creates sperate table to store the indexing
November 17, 2020
Index -Clustered Index- for faster Findings - similar to book index but not in separate page but for faster finding arranging the data into organized way from unorganized(mess).
November 10, 2020
FOR XML CLAUSE IN SQL SERVER
November 09, 2020
Limitations of views.- cant parameters, rules and default, Order by unless Top or For XML, cant temp table
November 09, 2020
Views -- Indexed views-- not suitable for OLTP --suitable for OLAP
November 08, 2020
Views --updatable view -- dont update view directly if the view is composed of multiple tables-- use instead of trigger for updating such table
November 08, 2020
Disable trigger querry
November 05, 2020
LogOn Triggers. - limiting sessions anything you want regarding logon .. with this you can limit sessions
November 05, 2020
DDL TRIGGERS - stopping procedure table to be modified or created
November 05, 2020
triggers-DML- instead of triggers
November 02, 2020
Exit Control Loop -Do while
November 02, 2020
Entry Control Loops
October 31, 2020
Android Basics Nanodegree Syllabus
October 29, 2020
Triggers- DML - after triggers(for)
October 29, 2020
Rename Column Name
Newer Posts
Older Posts
Home
