Showing posts with label Transact SQL T-SQL. Show all posts
Showing posts with label Transact SQL T-SQL. Show all posts

GroupBy Clause - SQL Server vs MySQL

›
A GROUP BY Clause is used to group the data based on specific columns along with summary information. However there are some differences in ...

SQL Server Inner Join - Concepts and Best practices

›
In a database such as SQL Server, we create tables which are related to each other through a common column. For example, if we have to stor...

SQL Server Query Pagination

›
This article was authored by Praveen Dabade. In SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query...

Shrink a Live SQL Server Database and Logs - Caveats and Best Practices

›
Updated on December 20th, 2017. If you have deleted a lot of data in the database and truncated some tables, probably you may want to shr...
3 comments:

SQL Server ISNULL() With Multi Column Names

›
Many a times we come across null values within tables in SQL Server. Null values are the values with no data; that means the data is missin...
1 comment:

SQL Server T-SQL DateDiff Example

›
How do we find the difference between two dates in SQL Server. Not just the difference in the number of days, but also number of weeks, mont...

SQL Server: Return Newly Inserted Row

›
Whenever you insert a new row in a SQL Server table that contains default values, you may want to return the newly inserted row to the use...

Calculate SQL Azure Database Size

›
I was looking out for a correct way to programmatically determine the size of a SQL Azure database. After searching many solutions, I finall...
1 comment:

Remove Non-Alphabet Characters from a String–SQL Server

›
Suppose you have a string that contains numbers and other special characters and you want to keep only alphabets and remove all the other ch...

Nested Case Statement in SQL Server

›
This article is a continuation of SQL Server CASE Statement and CASE WHEN Examples . Today we will learn about Nested Case Statement in SQ...

SQL Server select into temp table

›
Many a times we get an output, and then query the output further. In such scenarios instead of writing the entire query repeatedly, and the...

SQL Server Default Port

›
In this article, we are going to explore the default port number of SQL Server required for getting connected to different applications. W...

SQL Server Update statement with JOIN

›
In this article, we are specifically going to see a practical usage of the UPDATE statement in SQL Server when the condition is based on JO...

SQL Server Substring with CharIndex

›
In this article we are going to explore the T-SQL function CharIndex and also how to use it with another T-SQL function Substring(). Char...
1 comment:

SQL Server Delete Duplicate Rows

›
There can be two types of duplication of rows in a table 1. Entire row getting duplicated because there is no primary key or unique key. ...
2 comments:

T-SQL Insert Into Table Examples

›
In T-SQL, to add records into a table (SQL Server) we use a Data Manipulation Language (DML) command known as Insert statement . In this ar...
1 comment:

SQL Server Alter Table with Add Column

›
There are many scenarios where we need to do structural changes to a table, i.e. adding a column, modifying data type, dropping a column an...