SQL Server Blogs

Post

SQL Server

Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Blogs

Query to Get Nth Highest Value

These are different types of query to get second highest value from table.
Kunal Vaishya Oct 26, 2012
Difference Between SCOPE_IDENTITY, IDENT_CURRENT and @@IDENTITY

In this blog I'll explain the difference between SCOPE_IDENTITY, IDENT_CURRENT and @@IDENTITY in Sql Server.
Manish Dwivedi Sep 19, 2012
FileStream in SQlServer 2008

This blog explains what the File Stream is in SQL Server 2008 and when and how to use it.
Kamal Rawat Sep 03, 2012
String Functions in SQL SERVER

In this Article, we will see about most frequently used string functions in SQL SERVER with working examples.
Prabhu Raja Sep 02, 2012
Saving changes is not persist in SQL Server 2008

While editing a table in database in SQL Server 2008 I ran into a brick wall, or a 'by design' feature of the Database Management Studio.
Yogesh Jaiswal Aug 27, 2012
Difference between NULLIF and ISNULL

In This blog, I’ll explain the basic difference between ISNULL and NULLIF
Manish Dwivedi Aug 15, 2012
How To Shrink Database Log File In Sql Server

In this blog I am going to explain how to shrink database log file in sql server.
Akshay Patel Aug 08, 2012
Delete Duplicate Rows From Table In Sql Server

In this article I am going to explain how to Delete Duplicate Rows From Table In Sql Server.
Amol Aug 05, 2012
SQL Function that convert Numerical Currency to String Format

In this blog I am going to explain how to convert Numerical Currency to String Format using sql function.
Gohil Jayendrasinh Aug 05, 2012
How to Work with Exceptions Handling in SQL Server Stored Procedure

In this blog I am going to explain how to work with exceptions handling in sql server stored procedure.
Mohammed Kaleem Jul 23, 2012
Enabling & Disabling xp_cmdshell in SQL SERVER

Here we going to see how to Enable & Disable xp_cmdshell in SQL SERVER
Lajapathy Arun Jul 03, 2012
Getting Basic Information of ALL Databases using system stored proc(sp_helpdb)

sp_helpdb -- Helps to get basic information of all database in the server
Lajapathy Arun Jul 02, 2012
Getting Difference Between sys.all_objects & sys.objects in sql server

Query returns all the rows which is different between both tables.
Lajapathy Arun Jul 02, 2012
Gettting List of Linked server configured in server using SQL Server

To get list of Linked server configured in server using SQL Server
Lajapathy Arun Jul 02, 2012
What's New in Replication of SQL server 2012

SQL Server 2012 introduces several new features and improvements to replication.
Lajapathy Arun Jul 01, 2012
Dropping Multiple Stored procedures at once in SQL SERVER 2008

We can drop multiple procedure at a time by comma separating the procedures.
Lajapathy Arun Jun 23, 2012
Getting Database objects count using SQL SERVER 2008

Used to get objects count from database.
Lajapathy Arun Jun 23, 2012
How to setup Intellisense in Sql Server 2008

In this article we are going to see, How to setup Intellisense in Sql Server 2008.
Lajapathy Arun Jun 20, 2012
Adding suffix to a column value for duplicate names in SQL

In this blog, let us see how to add suffix for a field value if the value already exists in the table.
Santhosh Kumar Jayaraman Jun 02, 2012
Asteric code is generated on the basis of geralization method

In this Blog we see the code on the basis of geralization method.
Vikrant More May 21, 2012

841 - 860 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Alchemy