DevSocial Blogs · SQL Server blogs

Sometimes it happens that we misspell the column name or wish to rename the column. We can do so by following the steps in this post.

Abhay ShankerDec 9, 20133,288250

In this post I would like to show you the method of exporting data from SQL table to Excel.

Priti KumariDec 9, 20135,060250

In this post I would like to define the method of deleting the duplicate row from the database table.

Priti KumariDec 6, 20134,603250

In this blog you will learn how to Insert the bulk data at a time in an SQL table.

Priti KumariDec 5, 201327,022250

Here I have to show an example on how to restrict the SQL injection.

Priti KumariDec 4, 2013115,497250

In this blog we will know how to find and remove the underscore records in a table.

Satyapriya NayakDec 4, 20133,898250

Here, I created user function it called TRIM for us for get trim string.

Gaurav MalviyaDec 3, 20134,939250

SELF JOIN for use same table join, in some business logic want some result by same table but with condition that time we use this.

Gaurav MalviyaDec 3, 20133,904250

Displaying Row number without using Row_number function in SQL Server.

Devesh OmarNov 21, 201341,793250

In this blog I will explain how to return identity column value in SQL Server.

Nitin BhardwajNov 19, 20133,464250

In this Blog I will discuss on the SET ANSI_NULL ON/OFF setting.

Ravi ShekharNov 18, 201311,553250

Selecting the top records from the SQL Server without using the TOP keyword.

Devesh OmarNov 18, 201311,745250

This query will give you column name in all tables,Sps,etc. just give your column name in place of employee and see the magic.

Ways to find and deleting Duplicate records in SQL Server.

Devesh OmarNov 13, 20133,846250

Ways to get N th largest salary in SQL Server.

Devesh OmarNov 13, 20132,615250

How to get list of databases and their size with simple query.

Rajat JaiswalNov 13, 20133,329250

Easy way to determine what is currently running on my SQL Server?

Rajat JaiswalNov 13, 20133,815250

What is Merge DML statement and what can it do?

Milstein MunakamiNov 11, 20135,839250

In my table identity column values starts from 1 and so on.

Purushottam RathoreNov 9, 201335,649250

Query for rebuild all indexes of database at single click.

Ravi ShekharOct 30, 20134,739250

This blog defined how to Convert money to Indian Rupee System using SQL Function.

Bhupendra SinghOct 24, 20136,880250

Delete conditional data from datatable at disconnected mode.

Dileep Kumar PatelOct 23, 201312,188250

This blog defines how to set value to variable using 'execute' in SQL Server.

Ravi ShekharOct 23, 201335,050250

Page_count and fragmentation of Indexes in SQL.

Ravi ShekharOct 23, 20139,130250