TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
SQL Server
FOLLOW
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.
Articles
(1123)
Blogs
(1121)
Resources
(55)
Videos
(19)
News
(7)
Articles
Move a Database Using Detach and Attach in SQL Server 2012
This article introduces how to Detach and Attach a database in SQL Server 2012 by using SQL Server Management Studio.
Rohatash Kumar
Aug 01, 2012
Output keyword in Sql Server 2008
In a simple word we can say OUTPUT clause used with INSERT, UPDATE, or DELETE to identify the actual rows affected by these statements and also used for the auditing purpose.
Akshay Teotia
Nov 12, 2011
Concept of Exists Condition in SQL Server
This article shows how to use the EXISTS condition in SQL Server. The EXISTS condition is used to check if the row exists or not in the table. EXISTS queries are very inefficient since the sub-quer...
Rohatash Kumar
May 22, 2012
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II
In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000 ( Part 1 ), describe using the fu...
Michael Livshitz
May 22, 2006
Using the System Function fn_listextendedproperty of SQL Server 2005 for .NET Applications: Part II
In this article, divided into two parts, I will compare the system function fn_listextendedproperty of SQL Server 2005 with the similar function of SQL Server 2000, describe using the function for ...
Michael Livshitz
May 24, 2006
Building Managed Code Using Common Language Runtime (CLR) Integration in SQL Server 2005
In this article I am going to talk about a cool new feature of SQL Server 2005 called CLR Integration, its advantages and how to program database objects using managed code with a simple project in...
Sekar Lanka
Oct 24, 2005
SQLCLR Debugging
In SQL Server 2005, CLR integration allows you to write stored procedures, triggers, user-defined types, and user-defined functions using any .NET Framework language, including Microsoft Visual Bas...
Amit Anajwala
Nov 10, 2005
SQL Server Reporting Services
This article describes how to modify the team reports generated by VSTS or BI Studio over SQL Server 2005.
Anubhav Bansal
Aug 04, 2005
Understanding SQL Server Yukon Service Broker
The new version of Microsoft SQL Server™ Yukon comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the S...
Jesus Rodriguez
Feb 25, 2004
SQL Server Reporting Services
SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources. This arti...
K S Ganesh
Feb 25, 2005
Distributed Databases in SQL Server 2005.
An increasing number of applications require access to multiple databases located at different sites. A distributed database system allows applications to access database locally and remote transpa...
John Charles Olamendy
Nov 20, 2007
Migrating from ASP.NET 1.0/SQL Server 2000 to ASP.NET 2.0/SQL Server 2005
The article provides details of various steps followed by author in upgrading ASP.Net 1.1 application to ASP.Net 2.0 and SQL Server 2000 to SQL Server 2005
Bhala
May 28, 2008
Cursors in Database Management Systems
This article is intended to show the principles and uses of cursors in relational database management systems. We’re going to discuss how cursors are implemented in Microsoft SQL Server and Oracle ...
John Charles Olamendy
Jul 23, 2008
Understanding Database Stored Procedures
This article discusses basics of stored procedures and how to create, update, and delete stored procedures in a database.
Shashi Ray
Sep 29, 2008
Backup and Recovery in Database Systems
This article is intended to cover one of the most critical responsibilities of database administrators in order to maintain data integrity.
John Charles Olamendy
Feb 25, 2008
SQL Query Optimization FAQ Part 1 (With video explanation)
In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to un...
Shivprasad
Feb 02, 2010
How to Connect Mysql Server with Asp.net 2005 / 2008 (C#)
Here I will discus in the easiest way to connect your asp.net web application with MYSQL Server and also how you can migrate from Microsoft SQL to MYSQL.
Asem M
Feb 11, 2010
Wildcards in SQL Server 2005
SQL wildcards are used for searching data’s in a database, which were used with LIKE operator.
Karthika Palaniswamy
Oct 27, 2009
New Features in SQL Server 2008
Here are some of the new features added to SQL Server 2008.
Karthika Palaniswamy
Oct 26, 2009
Openxml - XML Integration with SQL Server
In this article we will know about Openxml and how to perform operation using it.
Rekha Singh
Jul 20, 2009
No Records Available.
901
-
920
of
1123
<<
44
45
46
47
48
>>
Build And Architect Distributed Cloud Applications
Challenge yourself
SQL server
E-Book Download
Get Certified
Programming with Visual Basic .NET