SQL query to convert column to row Krunal Shah2017-09-27T05:11:00-07:00 During the creation of table maximum time we only consider the purpose and efficiency of the table. All time we don’t think about the repo...Read More
MS SQL Server Krunal Shah2017-09-27T05:10:00-07:00 MS SQL Server is a computer application that is primarily used to store and retrieve data. This program is developed by Microsoft Corporat...Read More
Difference Between Primary Key and Unique Key Krunal Shah2017-09-27T05:08:00-07:00 In relational database system primary key and unique key are two important concepts. Both are used to uniquely identify a row in a table. ...Read More
How to make a Great Primary Key? Krunal Shah2017-09-27T05:08:00-07:00 The primary key is in important factor for any relational database. It plays a vital role. It has numerous functionalities. On a table we ...Read More
Difference between Stored Procedure and Function Krunal Shah2017-09-27T03:50:00-07:00 In a database system, stored procedures and functions are SQL statements that provide similar functionality. Both allow us to create bundl...Read More
SQL Server Agent Krunal Shah2017-09-27T03:49:00-07:00 SQL Server Agent or SQL Agent is a Microsoft Windows service that executes scheduled automated tasks. In SQL Server this task is called jo...Read More
How to Check the Status of SQL Server Agent? Krunal Shah2017-09-27T03:48:00-07:00 SQL Server Agent is very important to perform automated tasks. If the agent goes stop, no automated task will be executed. This article ex...Read More
SQL or Structured Query Language Krunal Shah2017-09-27T03:47:00-07:00 This article describes introduction to SQL , basic overview of SQL . Summary of the article: What is SQL? Why we should Use SQL? SQL...Read More
Update One Table with Another Table Krunal Shah2017-09-27T03:46:00-07:00 Sometimes we need to update the data of one table with the data from another table in SQL. It can be done in different ways. We can use st...Read More
Error Handling or Exception Handling in SQL Server Krunal Shah2017-09-27T03:45:00-07:00 Error handling or exception handling is the most vital part of any software development. Generally we are not interested to show any type ...Read More