SQL

Exploring the Depths of SQL and LINQ Joining Fundamentals

USE [Inventory] GO /****** Object: Table [dbo].[Customer] Script Date: 1/4/2016 11:20:47 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Customer]( [CustomerId] [int]...

📄

SQL

SQL Database Design: Understanding Primary and Foreign Keys

Today I am going to explain difference between Primary key and Foreign key in SQL. It is very frequently asked interview question for beginner or experienced. So, I will try...

📄

SQL

What Are the Advantages of Using Stored Procedures in SQL Server

Today, I am going to explain, what is stored procedure in SQL and advantage of stored procedure in SQL and something more about stored procedure how to create stored. So,...