DevSocial Blogs · SQL Server blogs

Sometimes we required to generate a comma separated list of columns values like a list of EmailIDs to send mail. In SQL Server, we can make a comma separated list by using COALESCE as shown in below.

Naveen KumarJul 21, 2014151,966250

This blog describes to insert values form one database table to the another database table.

Nimit JoshiJul 16, 2014274,037250

This blog defines bulk query in SQL.

Abhishek JaiswalJul 16, 201414,029250

In this blog i will give demonstration on constraints in C#.

Abhijit PatilJul 8, 201420,633250

This blog defines how we need to store the db backup using script.

Khan Abrar AhmedJul 8, 20143,709250

Using SQL query we will create the DB user and user associate the db role.

Khan Abrar AhmedJul 8, 20143,601250

In this blog you will learn about Magic Table in SQL Server.

Abhishek JaiswalJun 30, 201454,865250

This blog defines stuff in SQL Server.

Jasminder SinghJun 27, 201410,943250

This blog explains OLAP feature in SQL Server.

Rupesh KahaneJun 26, 20145,831250

In this blog we will learn how to add column in table with default value.

Kumar SambhavJun 26, 20144,414250

Schema is a blueprint of how database is constructed and also it's design view.

Abhishek JaiswalJun 24, 20144,040250

In this blog am going to talk about some confusing and most frequent asked commands in SQL.

Abhishek JaiswalJun 24, 201410,702250

This blog defines ASCII in SQL Server.

Rupesh KahaneJun 24, 201411,087250

This blog describes indexes on Table by using sp_helpindex.

Rupesh KahaneJun 24, 20143,554250

SQL Server 2012 has a new feature called Columnstore Index. I will explain about this feature that how data is stored when using a Columnstore Index.

Pradip PandeyJun 18, 20144,913250

This blog defines subquery in SQL Server.

Abhijit PatilJun 17, 20148,043250

This will give an overview of Business Intelligence and Microsoft tools used for BI.

Pankaj BajajJun 16, 20144,820250

This blog defines string function in SQL Server.

Abhijit PatilJun 16, 20145,203250

This blog defines primary key in SQL Server.

Rakesh KalluriJun 11, 20149,514250

This blog defines how to export excel data to SQL using T-SQL.

Rakesh KalluriJun 10, 20145,833250

In this blog I demonstration on getting list of tables in SQL.

Abhijit PatilJun 2, 20145,242250

This blog defines how to save text file in SQL Server.

Abhijit PatilMay 30, 201419,361250

In this blog, I’m going to explain to you guys a very simple way to perform the procedure of passing table as a parameter to a Stored Procedure.

Sanjay SinghMay 27, 20145,043250

In this blog we will learn how to create scheduled Data base backup using maintenance plan in SQL server 2012.

Khan Abrar AhmedMay 27, 201447,888250