Category Archives: SQL

SQL

Which are the different types of joins?

INNER JOIN Inner join shows matches only when they exist in both tables. Example in the below SQL there are two tables Customers and Orders and the inner join in made on Customers. Customerid and Orders. Customerid. So this SQL will only give you result with customers who have orders. If the customer does not… Read More »

How to solve – Insertion into replicated table failure ?

Hi All, In SQL data base, data  insertion to a table fails due to identity range check constraint for replicated tables, if the identity is managed by replication.This issue may be faced in SQL insertion. How to Solve this ? In SQL there are two types of users for a replicated table. First One is… Read More »

Encryption for Stored Procedure in SQL Server

Hi Friends, Stored Procedures are very important in software development.While developing software we use stored procedures to fetch and insert different critical data from and to data base. Sometime it is very important to hide the business logic from end user due to security reasons. Once Stored procedures are encrypted it is not possible to… Read More »