In this article I would like to discuss the Magic tables used in the SQL Server.
This article will give you an idea of how to use the magic table and also defines where you can use it.
In this article you will learn how to use Magic's and validation nature of a Round function in SQL Server
In this article I described Temporary Tables in SQL Server.
In this article, I am going to give a quick overview of the various types of tables in SQL Server.
In this article I'll show you how to search a column value in all the referencing tables.
We have seen lot of difference between temporary variable and temporary table. Here is a nice difference in Transaction perspective.
It is a common and business requirement to backup the data. The archiving is part of back ups and most of the applications and system will be following some procedure to archive the data.
Temporary tables are a useful tool in SQL Server provided to allow for short term use of data
This article lists some of the optimization tips for SQL Server development.
Here we are going to discuss the new parameter type which is introduced in SQL Server 2008 version.
In this article, you will see how to create a duplicate table with a new name using a script in SQL Server.
In this article we will bind three SQL Server tables with a TreeView in a hierarchical order
This article describes two simple ASP.NET pages for handling the stuff; one page for uploading and saving files to a SQL Server table and one for sending the selected file back to the user when requested. There is also a db class for the database jobs, separating the logic from the presentation layer.
When we try to change an existing table in SQL Server 2008, you might receive a Save (Not Permitted Dialog) box pop-up. This article explains the error and what to do about it.
This article demonstrates how to use Table variables in SQL Server instead of temporary tables.
This article explains about Common Table Expression(CTE) in sql server 2005 with sample sql queries.
In this article, I am going to give a quick overview of temporary tables in SQL Server 2012.
I happened to be working with the round function. I found some interesting / peculiar nature of the round fucntion. Hope you will enjoy this article.
In this article, we learn how use a Table Valued Parameter with a C# application.