DevSocial Blogs · SQL Server blogs

Today, in this post, I am going to explain the SQL statement which is used to to get the date and time difference in a valid format like 1 hr ago, or 30 min ago, or 1 week ago, 1 month ago, and so on.

Nikunj SatasiyaOct 17, 201826,231250

A few days ago our system administrator installed the Microsoft test manager 2012 on Microsoft Team Foundation Server 2010(TFS 2010). Suddenly our TFS stopped working. TFS was not able to extract the data from Database.

I am explaining how we can create Table, Store procedure , and C# class via uploading excel and it can save developer’s time.

Vikas AgarwalOct 12, 201821,037250

In this article, we’ll see how to handle the error and raise an error in SQL Server with a stored procedure.

Raju AhmedOct 12, 201890,967250

SQL Server DDL Trigger is a special kind of trigger that fires in response to Data Definition Language (DDL) statements – CREATE, ALTER, DROP (Table, Function, Index, Stored Procedures, Views.. etc).

This blog exclusively explains the process of cleaning the execution history of SQL Server Integration Services packages from SSISDB.

Kirankumar SadhanalaOct 4, 201815,185250

In this blog, we will learn about the differences between Union and Joins in SQL. Union and Join, both are used to combine the data from two or more tables.

Sachin TripathiSep 21, 201818,636250

In this post, we will discuss how to work with SQL constraints and explain the concepts with an example in simple way. I hope this is very useful for beginners to help them understand the basic concept.

Jitendra WaghaleSep 13, 201810,669250

In this post, we will discuss how to work with SQL string functions and explain the concepts with an example in simple way. I hope this is very useful for beginners and intermediate to help them understand the basic concept.

Jitendra WaghaleSep 13, 20187,481250

In this article, we Learn about Cursor, types of Cursor in details with example.

Sanwar RanwaSep 11, 20188,593250

In this Article, we will learn about T/SQL and difference between SQL and T/SQL.

Sanwar RanwaSep 11, 201814,954250

In this blog, you will learn about Triggers in SQL Server and I will explain the concept of triggers with an example in a simple way.

Jitendra WaghaleSep 10, 201822,370250

An operator is a symbol which is used to perform some actions on the given expressions.

Sanwar RanwaSep 5, 201837,381250

In this post, we will learn about how to use TRY CATCH in SQL Procedure and store error with error text and procedure with the line number in the table. Here is a simple example for generating the error and store in SQL table. Let's start coding.

Hardik DeshaniSep 4, 201811,329250

In this post, we will discuss how to work with Indexes in SQL and explain the concepts with an example in a simple way. I hope this is very useful for beginners and intermediates to help them understand the basic concept.

Jitendra WaghaleAug 30, 201811,096250

One of the most important routes to high performance in SQL server database is an index.

Sanwar RanwaAug 6, 20189,395250

We add Clauses in Query to provide the additional facilities like filtering the records, storing the records, fetching the records and grouping the records in the Table.

Sanwar RanwaAug 6, 201812,475250

There are many problems which we face while using SQL Server. Its very important to design your database correctly and keep it working.

NILESH SAMGIRJul 31, 201810,399250

Do you know what is the easy way to create packages in Oracle? There are two steps in creating the package. I am using toad as an Oracle Developer Software for accessing the database.

Prashant GoswamiJul 30, 20189,253250

All fields must be at the same position and the same data type, you can make all kind of selects, joins, where etc the UNION ALL comand is best then UNION if you want select all rows if they are the same**, this is not the case in this sample, you can make it a View.

Jefferson S. MottaJul 30, 201816,597250

Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number sequence. But there also other ways to accomplish the same thing without using ranking function. I will tell you 3 various ways to generate the unique number sequence including ranking function.

Kapil Singh KumawatJul 27, 20186,751250

In this post, we will learn about how to replace newline characters from SQL fields. In this post, we have to use replace function for replace string and also use char function to remove newline characters and replace instead of this. Here I will give you the syntax of replace function and how to use char function and what is the meaning of 10 in char function.

Hardik DeshaniJul 26, 2018102,911250

In this article, we will discuss how to make faster SQL Server Search - Part Two.

Jefferson S. MottaJul 25, 20187,443250

Synonyms is database object which can be created as an alias name/duplicate name for any object like table views ,procedure etc.

Sanwar RanwaJul 24, 201813,830250