DevSocial Articles · SQL Server articles

Here you will see how to pass a table valued parameter to a Stored Procedure.

In this demonstration I am taking simple scenario, where I will to pass customers information to stored proc and insert customer rows into database.

This article describes how to pass a DataTable to a Stored Procedure as a parameter using ADO.NET in C#.

This article will help to convert values in rows to column/fields name or headers.

Suthish NairJun 10, 2019165,5291,000

Here we are going to discuss clustered and non-clustered indexes in SQL Server.

Nipun TomarJun 10, 2019153,0121,000

This article will give you an idea of how to join three or more tables and also defines the join in SQL Server.

Rohatash KumarJun 7, 2019266,6881,000

This article offers suggestions on how to optimize query performance in SQL Server 2005.

John Charles OlamendyJun 7, 2019130,3851,000

In this article we will see how to delete duplicate records from a table using CTE. But first let us see what CTE is.

NitinJun 7, 2019230,3421,000

In this article I provide a quick overview of the various Queries to remove the first and last character from a string in SQL Server.

Rohatash KumarJun 7, 2019565,0691,000

Here, we will see how to store and retrieve an image in Crystal Reports from SQL Database and folder using ASP.Net.

Saineshwar BageriJun 7, 2019212,3081,000

Here you will see how to Create and manage User Defined Functions in SQL Server 2008.

Vishal NayanJun 6, 2019159,8351,000

Learn how ROW_NUMBER(), RANK(), and DENSE_RANK() differ in SQL Server, including ordering, partitions, ties, and ranking gaps.

Atul RawatJun 6, 2019362,3891,000

In this article, you will see how to create drill down hierarchical report using SQL Server reporting services 2005.

In this article you will see lists of various types of transformations in SSIS 2012 .

Chigicherla MallikarjunaJun 6, 2019212,8251,000

STUFF Function in SQL Server. In this article we will learn how to concatenate multiple rows within a single row in SQL Server 2008.

Satheesh Kumar PilliJun 6, 2019445,2951,000

In this article you will learn the basic differences between union and union all operators in SQL Server.

Jignesh TrivediJun 6, 2019192,8731,000

In this article, we will see how to insert new and update existing records using SSIS.

Rajeev KumarJun 6, 2019287,6571,000

Common SQL Server interview questions covering stored procedures, functions, indexes, DELETE versus TRUNCATE, WHERE versus HAVING, and database keys.

Mahesh AlleJun 6, 2019169,7651,000

In this article I am going to explain how to use the @@FETCH_STATUS function in SQL Server 2012.

Vipendra VermaJun 6, 2019200,8151,000

In this article, I would like to show the difference between two dates in years, months and days in SQL Server.

Rohatash KumarJun 6, 2019346,0091,000

This article describes the usage of TRY_PARSE, TRY_CONVERT and TRY_CAST in SQL SERVER.

Manas MohapatraJun 5, 2019283,7081,000

This article shows how to calculate the difference between two dates of the same column or in different columns in SQL Server 2012.

Rohatash KumarJun 5, 2019378,5571,000

SQL Server Functions. In this article, I am going to explain about some SQL Server 2005 functions with examples. Here are going to discuss about some string functions, numeric functions and date/time functions.

Raj KumarJun 5, 2019188,2951,000

Today, I have provided an article showing you how to use a return value with a Stored Procedure in SQL Server 2012

Rohatash KumarJun 5, 2019406,4271,000

In this article you will learn basics of Database Administration In SQL Server. Learn what is Piecemeal Restore and see Piecemeal Restore Example.

Yashwant VishwakarmaJun 5, 201931,2281,000

In this part, we will discuss some basic things about SQL Server File Groups. Learn What is Filegroup, Types of Filegroups, Filegroup Examples, How to view filegroups, Changing default filegroup, Filegroups Backup in SQL Server

Yashwant VishwakarmaJun 5, 201960,6621,000

In this article you will learn the basics of Database Administration in SQL Server. Learn SQL Server Storage, primary data files like mdf, ldf, ndf, sysfiles vs sys.database_files, Transaction Log Files, storage capacity for different SQL Server objects

Yashwant VishwakarmaJun 5, 201963,1821,000

This article explains SQL Server Users, Owned Schemas, Membership, Securables, Extended Properties, Orphaned Users. Learn What is schema, How to view schema, Creating Extended Properties, Viewing Extended Properties, Updating Extended Properties, Deleting Extended Properties.

Yashwant VishwakarmaJun 5, 201992,8961,000

In this part we will try to understand each & every thing related to SQL Server logins.

Yashwant VishwakarmaJun 4, 2019107,2511,000