DevSocial Blogs · SQL Server blogs

Count total number of stored procedure, tables, Views and triggers in SQL Server 2008.

Deepak PorwalApr 21, 201466,181250

There is a situation when we need to retrieve only unique row based on one column. And also used join two tables to retrieve unique data. In this case we use distinct keyword to select unique records.

Naveen KumarApr 17, 201413,168250

Split comma separated values in Sql Server using charindex function.

Pradip PandeyApr 16, 20147,498250

Update multiple data from 1 table to other table in single Query.

Ashutosh TripathiApr 13, 20142,694250

Difference b/w union and union All in SQL Server.

Munesh SharmaApr 7, 20148,204250

This blog defines how to update default value of column in SQL Server.

Ashok SharmaApr 2, 20144,540250

An error occurs in the SQL Server whenever we use the create database, or whenever we try to save the code. Let's see how to solve this issue.

Abhijit PatilMar 11, 20144,445250

In this blog, I will explain the procedure of checking correctly if a temporary table exists in the SQL Server or not.

KalaiMar 10, 201422,853250

This blog defines the previous date with the current date in SQL Server.

Ashok SharmaMar 10, 201449,262250

This stored procedure helps the user to create a temp table and insert/update/select in the temp table.

Gohil JayendrasinhMar 7, 201439,448250

Try-CATCH block is supported in the natively compiled stored procedures. As we know, the TRY - CATCH block is used for implementing error handling.

Jignesh TrivediMar 6, 20147,605250

This blog defines the procedure of removing a duplicate row from a table in SQL Server.

Ashok SharmaMar 6, 20143,872250

In this blog, I will demonstrate about the SQL Server Services.

Abhijit PatilMar 5, 201447,901250

This blog defines the procedure of fetching a duplicate row from a table in SQL Server.

Ashok SharmaMar 5, 20143,988250

When we face any interview, then, we are mostly asked questions on SQL Server.

Abhijit PatilMar 5, 201469,897250

This blog defines how to restore backup SQL Server with Query.

Ashok SharmaMar 4, 20143,757250

Format functions in SQL server

Biswa Pujarini MohapatraMar 3, 201417,468250

Here, I would like to describe the method of getting the time in 24 hours, in the SQL server.

Priti KumariMar 3, 201416,278250

In this blog, I will explain the procedure of deleting a duplicate row from your table using the Query.

Kunal PatelFeb 28, 20144,831250

This blog defines how to fetch 50 Random rows every time from the table.

Mayur DhavleFeb 28, 20143,133250

This blog defines how to delete a table in SQL Server.

Ashok SharmaFeb 26, 20143,297250

This blog defines the default keyword in the SQL server.

Ashok SharmaFeb 25, 20147,218250

This blog discusses how to copy a table with all filed from the existing database to another database.

Ashok SharmaFeb 25, 20143,649250

Here, we will see how to find out about all the tables in my database, in the SQL Server.

Ashok SharmaFeb 25, 20142,883250