In Focus
Kolkata Chapter Developer Day: May 25
C# Corner Delhi Chapter Meet, May-18, 2013 Official Recap
Istanbul Chapter May 2013 2nd Seminar Announced : Learn WinJS, Windows Store, MVC
ANNOUNCEMENT: April 2013 Month Winners
Email :
Password :
Remember me?
Forgot password
Contribute
An Article
A Blog
A News
A Video
A Link
An Interview Question
Ask a Question
TECHNOLOGIES
.NET 4.5
Current Affairs
Learn .NET
SharePoint 2010
Web Development
.NET Assemblies
Databases & DBA
LightSwitch 2012
SharePoint 2013
Web Services in C#
ADO.NET in C#
Design & Architecture
LINQ
Silverlight with C#
Windows 8
AJAX in C#
Exception Handling C#
Mobile & Embedded
Smart Devices
Windows Azure
Android Programming
Graphics Design
Office 2013
SQL
Windows Controls C#
Articles C#
Hardware
OOP/OOD
SQL Server 2012
Windows Forms C#
ASP.NET Controls in C#
How do I
Operating Systems
Testing
Windows Phone 8
ASP.NET MVC with C#
HTML 5
PHP
TypeScript
Windows Server 2012
ASP.NET Programming
Internet & Web
Products
Visual C#
Windows Store Apps
C# Language
iPhone/iPad
Project Management
Visual Studio .NET
Workflow Foundation in C#
C# Tutorials
Java
Reports using C#
Visual Studio 2010
WPF
C, C++, MFC
Java and .NET
Robotics & Hardware
Visual Studio 2012
XAML
Career Advice
JavaScript, CSS
Security in .NET
WCF with C#
XML
Chapters
JQuery
Request a new Category
|
View All
ANSWERS
BLOGS
VIDEOS
INTERVIEWS
BOOKS
LINKS
NEWS
CHAPTERS
CAREER ADVICE
Create Outlook Add-in by MAPI Functionality ...
Debugging jQuery in ASP.NET
Top 10 HTML5 Interview Questions
How to Enable Sign in as Different User Opti ...
How to Select Multiple Rows in Grid Using Li ...
Find and Delete Duplicate Records From SQL Table
Custom Paging With GridView in ASP.NET 4.5
Encrypt and Decrypt in SQL Server: Part 2
Working With Database in HTML5
Panel Default Button is Not Working For Rad ...
SQL Server 2012
Welcome to SQL Server 2012 section of C# Corner. In this section, you will find various SQL Server 2012 related source code samples, articles, tutorials, and tips using C# language.
Tweet
RECENT ACTIVITY
ALL
ARTICLES
BLOGS
TUTORIALS
VIDEOS
NEWS
Put Multiple Column Fields in Order by Syntax
Posted by
Pankaj Pandey
in
Blogs
on May 10, 2013
SQL Server Database Mirroring: Part 1
Posted by
Nipun Tomar
in
Articles
on May 09, 2013
Tags:
.net
,
C#
,
Database Mirroring
,
Log Shipping
,
SQL Server
,
SQL Server 2005
Change Tracking in SQL Server 2008
Posted by
Nipun Tomar
in
Articles
on May 09, 2013
Tags:
.net
,
C#
,
Change Tracking
,
CHANGE_TRACKING_MIN_VALID_VERSION
,
sql articles
,
sql server
Columnstore index in SQL server 2012
Posted by
Seema Chaudhary
in
Blogs
on May 08, 2013
Show and insert data in linked server from mysql to SQL Server
Posted by
Pankaj Pandey
in
Blogs
on May 03, 2013
Get definition/Script of all stored procedures
Posted by
Pankaj Pandey
in
Blogs
on May 02, 2013
Get List of Database Tables,Stored Procedures,View,Index,Functions and more
Posted by
Pankaj Pandey
in
Blogs
on May 02, 2013
Find Number of Days in Month in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on May 01, 2013
New Functions in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 26, 2013
Tags:
SQL Function
,
SQL New Date and time Function
,
SQL New Logical Function
,
SQL New Parse Function
,
SQL Server 2012 New Function
Get Procedures used in another Procedure
Posted by
Siva Ganesh Rongala
in
Blogs
on Apr 25, 2013
Difference between Rank() and Dense_Rank() function in SQL Server
Posted by
Pradip Pandey
in
Blogs
on Apr 25, 2013
New Parse Conversion Function in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 23, 2013
Tags:
SQL Cast Function
,
SQL convert Function SQL Server 2012
,
SQL Function
,
SQL Parse Function
Execute a Query in String Format in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 23, 2013
Insert from One Table to Another, both Tables are from Diffrent Database in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 23, 2013
Insert Data from One Table to Another Table in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 22, 2013
Call Stored Procedure inside a stored procedure
Posted by
Pankaj Pandey
in
Blogs
on Apr 22, 2013
Getting Date and Time Values From Their Parts in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 19, 2013
Tags:
SQL DATEFROMPARTS Function
,
SQL DATETIMEFROMPARTS Function
,
SQL Function
,
SQL Server
,
SQL TIMEFROMPARTS Function
Women in SQL - SQL Bangalore UG Meet
Posted by
Muralidharan Deenathayalan
in
News
on Apr 19, 2013
Query Shortcut in SQL SERVER
Posted by
Gaurav Gupta
in
Blogs
on Apr 12, 2013
Difference between PatIndex and CharIndex function in SQL SERVER
Posted by
Gaurav Gupta
in
Blogs
on Apr 11, 2013
SQL Server Database Mirroring: Part 1
Posted by
Nipun Tomar
in
Articles
on May 09, 2013
Tags:
.net
,
C#
,
Database Mirroring
,
Log Shipping
,
SQL Server
,
SQL Server 2005
Change Tracking in SQL Server 2008
Posted by
Nipun Tomar
in
Articles
on May 09, 2013
Tags:
.net
,
C#
,
Change Tracking
,
CHANGE_TRACKING_MIN_VALID_VERSION
,
sql articles
,
sql server
New Functions in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 26, 2013
Tags:
SQL Function
,
SQL New Date and time Function
,
SQL New Logical Function
,
SQL New Parse Function
,
SQL Server 2012 New Function
New Parse Conversion Function in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 23, 2013
Tags:
SQL Cast Function
,
SQL convert Function SQL Server 2012
,
SQL Function
,
SQL Parse Function
Getting Date and Time Values From Their Parts in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Apr 19, 2013
Tags:
SQL DATEFROMPARTS Function
,
SQL DATETIMEFROMPARTS Function
,
SQL Function
,
SQL Server
,
SQL TIMEFROMPARTS Function
SQL Server Effective Database Tune up and Maintenance
Posted by
Nipun Tomar
in
Articles
on Apr 05, 2013
Tags:
ALTER INDEX REBUILD
,
ALTER INDEX REORGANIZE
,
AUTO_CREATE_STATISTICS
,
AUTO_UPDATE_STATISTICS
,
SQl Server
Extended Events Update In SQL Server 2012
Posted by
Swati Agarwal
in
Articles
on Apr 01, 2013
Tags:
create session in sql
,
Extended Event in SQL
,
SQL Server 2012
,
SQL Server new feature
Track Data Changes In SQL Server 2012
Posted by
Swati Agarwal
in
Articles
on Mar 20, 2013
Tags:
CHECKSUM
,
ROWVERSION
,
SQL Server 2012
,
track data changes
Getting the Name of the Server and Databases in SQL Server
Posted by
Rohatash Kumar
in
Articles
on Mar 19, 2013
Tags:
SQL DB_NAME Function
,
SQL Query
,
SQL Server 2012
,
SQL sysservers
Create Backup and Restore Database in SQL Server 2012
Posted by
Satya Prakash
in
Articles
on Mar 16, 2013
Tags:
backup database in SQL Server 2012
,
restore backup file
,
sql
,
Sql server 2012
,
Restore Database in SQL Server 2012
Sp_who2 Stored Procedure in SQL Server 2012
Posted by
Manish Sharma
in
Articles
on Mar 08, 2013
Tags:
SP_who2 Stored Procedure
,
SQL
,
SQL Server 2012
,
System Stored Procedure
Getting Some Useful Date and Time Information From Getdate Function in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Mar 06, 2013
Tags:
SQL Datepart Function
,
SQL Getdate Function
,
SQL Query
,
SQL Server 2012
LEN and DATALENGTH Function in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Mar 03, 2013
Tags:
DATALENGTH Function
,
LEN Function
,
Problem with SQL LEN Function
,
SQL Function
,
SQL Server 2012
Some Important XML Data Type Methods in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Feb 22, 2013
Tags:
Node Method
,
Query Method
,
SQL Server 2012
,
XML Method
Sp_who Stored Procedure in SQL Server 2012
Posted by
Manish Sharma
in
Articles
on Feb 22, 2013
Tags:
SP_who Stored Procedure
,
SQL
,
SQL Server 2012
,
System Stored Procedure
Display Stored Procedure Output Parameter Value With Query Window in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Feb 19, 2013
Tags:
Output Parameter in stored procedure
,
SP Output parameter
,
SQL Server 2012
,
SQL Server Stored Procedure
LEN Function in SQL Server 2012
Posted by
Rahul Sharma
in
Articles
on Feb 06, 2013
Tags:
LEN Function
,
length of column in SQL Server
,
SQL Server 2012
,
Statement in SQL Server
GROUPING SETS Clause in SQL Server
Posted by
Jignesh Trivedi
in
Articles
on Feb 05, 2013
Tags:
GROUPING SETS
,
SQL Server
,
SQL Server GROUPING SETS
Database Backup With Compression in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Jan 15, 2013
Tags:
Backup
,
SQL Backup with Compression
,
SQL Database Backup
,
SQL Server 2012
New FileTables Feature in SQL Server 2012
Posted by
Rohatash Kumar
in
Articles
on Jan 14, 2013
Tags:
SQL FileStream
,
SQL FileTables
,
SQL Server 2012
,
SQL Server New Feature
View All
Put Multiple Column Fields in Order by Syntax
Posted by
Pankaj Pandey
in
Blogs
on May 10, 2013
Columnstore index in SQL server 2012
Posted by
Seema Chaudhary
in
Blogs
on May 08, 2013
Show and insert data in linked server from mysql to SQL Server
Posted by
Pankaj Pandey
in
Blogs
on May 03, 2013
Get definition/Script of all stored procedures
Posted by
Pankaj Pandey
in
Blogs
on May 02, 2013
Get List of Database Tables,Stored Procedures,View,Index,Functions and more
Posted by
Pankaj Pandey
in
Blogs
on May 02, 2013
Find Number of Days in Month in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on May 01, 2013
Get Procedures used in another Procedure
Posted by
Siva Ganesh Rongala
in
Blogs
on Apr 25, 2013
Difference between Rank() and Dense_Rank() function in SQL Server
Posted by
Pradip Pandey
in
Blogs
on Apr 25, 2013
Execute a Query in String Format in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 23, 2013
Insert from One Table to Another, both Tables are from Diffrent Database in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 23, 2013
Insert Data from One Table to Another Table in SQL Server
Posted by
Pankaj Pandey
in
Blogs
on Apr 22, 2013
Call Stored Procedure inside a stored procedure
Posted by
Pankaj Pandey
in
Blogs
on Apr 22, 2013
Query Shortcut in SQL SERVER
Posted by
Gaurav Gupta
in
Blogs
on Apr 12, 2013
Difference between PatIndex and CharIndex function in SQL SERVER
Posted by
Gaurav Gupta
in
Blogs
on Apr 11, 2013
Create a Copy/Dummy of a existing table
Posted by
Pankaj Pandey
in
Blogs
on Apr 11, 2013
Bulk Import In Sql Server 2008 from csv/text file
Posted by
Pankaj Pandey
in
Blogs
on Apr 11, 2013
Sequence in SQL Server 2012
Posted by
Joxin Stanly
in
Blogs
on Apr 08, 2013
Differences between Stored Procedures and triggers
Posted by
Pankaj Pandey
in
Blogs
on Mar 20, 2013
Call A function in Stored procedure
Posted by
Pankaj Pandey
in
Blogs
on Mar 20, 2013
Query to copy all tables from one database to another or Dummy create tables
Posted by
Pankaj Pandey
in
Blogs
on Mar 19, 2013
View All
Designing and creating a database in SQL Server 2005
Posted by
Vijaya Kadiyala
in
Tutorials
on Aug 27, 2008
View All
How to Use the SQL Server 2005 Tuning Advisor
Posted by
John Penn
in
Videos
on May 14, 2011
Tags:
SQL Server 2005
,
SQL Server 2008
,
database
,
indexes
,
optimization
,
tuning
View All
Women in SQL - SQL Bangalore UG Meet
Posted by
Muralidharan Deenathayalan
in
News
on Apr 19, 2013
Tags:
sql server
,
sql
,
sql server 2012
In-Memory Computing and in-memory Data: Future of SQL Server
Posted by
Mahesh Chand
in
News
on Nov 07, 2012
Tags:
In-Memory Computing
,
in-memory Data
,
SQL Server
,
SQL Server 2012
View All
HOT KEYWORDS
.NET Framework 4
Access
BI
BIDS
Binary Large Objects
BLOB
Character Map
Clustered Index
Code First
Column Transformations in SSIS
Count
CTE
Data flow transformation
Database Links
Database Mirroring
Database objects
DENALI
Export Data
Expressions
FilterExpression
Foreign Key
FTP Task in SSIS
FTP Task in SSIS Package
Functions
Functions in SQL Server 2008
Group By
Hierarchical
Import Column Transformation in SSIS
Import Data
Import Excel to SQL Server
Linked Servers
Linked Servers in SQL Server 2008
Lookup Transformation in SSIS
Mail Configuration
Many business intelligence
Many to Many
Microsoft SQL Server 2008
Mobile Device
MOSS2010
Mysql server
One to Many
One to One
Order By
Output
Output Clause
Parsing Name of Database Object
performance tuning
pivot
PowerPivot
PowerPivot Excel
PowerPivot SharePoint
query optimization
remote
Remote Connection
reporting service
Row Sampling in SSIS
sample
Script component
Send Mail Task in SSIS
SMO
source code
SQL CLR
sql cubes
SQL Mail
SQL Optimization Tips
SQL Query
SQL Server 2005 articles
SQL Server 2005 tutorials
SQL Server 2008
SQL Server 2008 R2
sql server 2012
SQL Server Database Mirroring
SQL Server Integration Services
SQL Server Interview Questions
SQL server Management Studio
SQL Server tutorials
SQLCLR
SQLCLR Debugging
sqlserver 2008
Sridhar Rama subramanian
Sridhar Subramanian
SSAS
SSIS
SSIS articles
SSIS Package
SSIS packages
SSIS Percentage Sampling Transformation
SSIS tutorials
SSMS
Stored Procedure in SQL Server 2008
Table Valued Parameter
Temporary table
Transfer
Transformations Control in SSIS
Triggers in SQL Server
Triggers in SQL Server 2005
UDF
User Defined Functions
views in sql server 2005
Vijaya Kadiyala
PREMIUM SPONSORS
iPhone, Android & Web Development Services
Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.
STATISTICS
TOP LEADERS
View All
WHITEPAPERS AND BOOKS
Interview Questions on SharePoint 2013
SharePoint 2010 Administration & Development
Getting Started with Managed Metadata Service in SharePoint 2010
Windows Phone 7 Hileleri
Windows Phone Development Step by Step Tutorial
Essentials of SharePoint 2010: Business Intelligence Capabilities
Working with Directories in C#
FileInfo in C#
Programming List with C#
Source Code: Graphics Programming with GDI+
View All
Follow @twitterapi
TRENDING UP
Views & Stored Procedure in SQL Server 2005
Using Stored Procedures with ASP.NET
Functions in SQL Server 2005
Query Optimization in SQL Server 2005
Creating Drilldown Hierarchical Report using SQL Server Reporting Services 2005
Change SQL Server 2005 SA Password
View All
SPONSORED BY
DynamicPDF ReportWriter Suite
PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.
LATEST JOBS
Sr. ASP.NET Developer
Multiple positions
.NET Developer and PHP Developer
Marketing Executives
Sr. ASP.NET Developer
Software Director - Pharmacy Automation
Applying for job
Metro Style App Developer
.NET Developer WPF or Silverlight exp Boston MA
ASP .Net Developers
View All Jobs
|
Post a New Job
Poll
Result
All Polls
What is the best product to build Mobile apps?
What is the best product to build Mobile apps
PhoneGap
Icenium
Xamarin Studio
KendoUI Mobile
JQueryMobile
Native iOS/Android
What is the best product to build Mobile apps
Options
Votes
%
PhoneGap
0
0.00
Icenium
0
0.00
Xamarin Studio
0
0.00
KendoUI Mobile
0
0.00
JQueryMobile
60
90.91
Native iOS/Android
6
9.09
Total
66
100%