Sequence of Key words in SQL Statement

FROM & JOINs: determine & filter rows
WHERE: more filters on the rows
GROUP BY: combines those rows into groups
HAVING: filters groups
ORDER BY: arranges the remaining rows/groups
LIMIT: filters on the remaining rows/groups

-Mayank Gupta

Comments

15404 error in SQL not able to create new DB diagram

In SQL Server Management Studio do the following: Right Click on your database, choose properties Go to the Options Page In the Drop down at right labeled "Compatibility Level" choose "SQL Server 2005(90)" 3-1. choose "SQL Server 2008" if you receive a comparability error. Go to the Files Page Enter "sa" in the owner textbox. 5-1 or click on the ellipses(...) and choose a rightful owner. Hit OK after doing this, You will now be able to access the Database Diagrams.

How to check if JWT Token is Tampered ?

JWT Tokens has three parts: Header Pay Load Signature Header includes the encryption algorithm and token type. e.g: { "alg" : "HS256", "typ" : "JWT" } Signature is created using base64url encoding the header and payload and concatenating them with a period(.) as a seperator. Take the signature of the token and decode it from base64, take the encryption algorithm from the header and generate the signature for the base64 encoded header + '.' + base64 encoded payload. If the signature received and calculated are matching then nobody has tampered the JWT. - Mayank Gupta

Design Patterns : Abstract Factory

Abstract Factory is a kind of Structural Design Pattern. Solves the problem of creating instances of entire product families without specifying their concrete class. Frequency of use: 5/5 (High) Intent: Provides an interface for creating families of related or dependent objects without specifying their concrete classes. The new operator is considered harmful Problem: Solution: Explicitly declare interfaces for each distinct product of the product family Make all variants of that product follow those interfaces Create an abstract factory which returns abstract product type represented by the interface UML Class Diagram: Code: using System; namespace AbstractFactory { class Program { static void Main(string[] args) { Console.WriteLine("This is Abstract Factory"); Console.ReadLine(); } } #region FamilyOfProducts abstract class Button { public abstract void Pain...

Mayank Gupta

Search This Blog