Search

Mavin world

Elegant short notes on technical concepts

Category

SQL SERVER

Entity Framework Concepts made easy

Conceptual model, entity, context ....in Entity framework. Confused?? Say No to confusion now, since I have made this blog post to throw a perfect illusion of how all these things relate to each other. Let's begin... I begin with simple... Continue Reading →

Basic understanding of Merge Clause in Sql server

Merge Me using You  on You.obidient=Me.obidient When Matched  Then Party time When Not Matched By Me Then Sorry  When Not Matched By You Then Unfortunate  Viola Viola A quick and charming poem, Isn't it?  Merge clause may seem daunting at... Continue Reading →

A First sight on cast and convert functions in sql server

I often get messed up myself when it comes to use cast and convert functions. No matter how many times I use them still I get stuck around at the basic syntax difference between the two. So lets make it... Continue Reading →

A simplified Glance ROW_NUMBER and OUTPUT clause in Sql Server

This post elucidates the concepts for the beginnners in an elegant way.The table chosen is simple for comprehending the concepts in a better way.

Create a website or blog at WordPress.com

Up ↑