Skip to content

Rahul's space

Learn, Share and Grow with me !

  • About
  • Donation

Tag: Microsoft SQL Server

Comma separated values in mysql

March 2, 2015 Rahul Bhatia

MY SQL: GROUP_CONCAT function concatenates values within each group defined by GROUP BY clause. Syntax GROUP_CONCAT([DISTINCT] exp [ORDER BY sorting] [SEPARATOR ‘sep’]) Quick Example SELECT

Continue reading

Visual Studio – Database Project Not Loading

March 3, 2013 Rahul Bhatia

Have you ever created a Database project and after some time you are not able to load it in the Visual Studio? Probably you might

Continue reading

Cannot drop database because it is currently in use.

March 1, 2013 Rahul Bhatia

This is a very common error when DROP Database is command is executed and the database is not dropped. The following commands will raise above

Continue reading

CHECK constraint with User Defined Function in SQL Server

November 7, 2012 Rahul Bhatia

This post describes how to use result of an user defined function with CHECK constraint in SQL Server.  For demonstration, considered a situation where it

Continue reading

COALESCE with DISTINCT in SQLServer

November 6, 2012 Rahul Bhatia

If you want comma separated values from columns it is so simple. Use COALESCE function provided by SQL Server. DECLARE @csv varchar(max) select @csv =

Continue reading

Categories

  • AngularJs (13)
  • ASP.NET (104)
  • C Programming (1)
  • Code Project (2)
  • CodeProject (1)
  • Entity Framework (6)
  • Ext.NEt (1)
  • HTML5 (1)
  • Interview .NET (2)
  • Introduction (1)
  • JQuery (1)
  • Linq (1)
  • Microsoft office (2)
  • MOSS-(Sharepoint 2010) (2)
  • MVC (5)
  • Outlook (1)
  • Sql Server (30)
  • SSRS (5)
  • TFS (1)
  • Tips & Tricks (16)
  • Twitter bootstrap (1)
  • VB.NET (1)
  • Visual Studio 2012/2013 (1)
  • Web Services (1)
  • Windows Workflow (1)

Top Posts & Pages

  • MYSQL : How to skip first 10 records from a SELECT query and take next 10?
  • GridView: Findcontrol from HeaderTemplate/ItemTemplate
  • ASP.NET Routing with IIS 7 (runallmanagedmodulesforallrequests = true)
  • How to Collapse all #regions only(!) in C# (Visual Studio)
  • Define Composite Key in Model.(Core, EF Code First)
  • Kendo grid error : kendo.all.min.js:12 Uncaught TypeError: e.slice is not a function
  • USAePay Token error: 23 Specified source key not found
  • Updatepanel triggers another updatepanel
  • Entity Framework : Could not load type System.Data.Entity.Design.AspNet.EntityDesignerBuildProvider
  • How to compile .NET Core Console Application as .exe File?

Recent Posts

  • How to compile .NET Core Console Application as .exe File?
  • Define Composite Key in Model.(Core, EF Code First)
  • How to remove x from Internet Explorer ?
  • The client and server cannot communicate, because they do not possess a common algorithm
  • How to check if all items are the same in a list C#
  • How to Collapse all #regions only(!) in C# (Visual Studio)
  • Issue: Password field returned empty in edit mode
  • Load XML from URL giving an error (The remote server returned an error: (401) Unauthorized.)
  • How to use Variable in MySQL Like Clause ?
  • Error :(System.Web.UI.HtmlControls.HtmlIframe) is not compatible with the type of control (System.Web.UI.HtmlControls.HtmlGenericControl) in VS2017

Blog Stats

  • 158,671 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 239 other followers

AngularJs ASP.NET Code Project CodeProject C Programming Entity Framework Ext.NEt HTML5 Interview .NET Introduction JQuery Linq Microsoft office MOSS-(Sharepoint 2010) MVC Outlook Sql Server SSRS TFS Tips & Tricks Twitter bootstrap VB.NET Visual Studio 2012/2013 Web Services Windows Workflow

Rahul Bhatia

  • Rahul Bhatia

Comments

aishwarya on remove pie chart slices labels…
Chakib on UpdatePanel and triggers from…
Mehdi Bennis on AngularJS With Asp.net Web API…
hnc24 on Send Email from a Static HTML
Rob on Send Email from a Static HTML

Profile

Blog Stats

  • 158,671 hits
Blog at WordPress.com.