Saturday, December 12, 2015

Telerik Rad Editor Example With Mail Merge and Custom Dropdown

Telerik Rad Editor Example With Mail Merge Custom radeditor dropdown  binding from code behind Step 1 :- Rad Editor Design <telerik:RadEditor runat="server" ID="RadEditorMailMerge" SkinID="DefaultSetOfTools" EnableResize="true" Visible="false" ContentFilters="MakeUrlsAbsolute,FixEnclosingP" EditModes="Design" Height="250px" Width="750px" ContentAreaMode="Iframe" AutoResizeHeight="false"...
Read More »

How to Kill all Active Connections to the SQL Server Database

How to Kill all Active Connections to the SQL Server Database use master DECLARE @dbname sysname SET @dbname = 'Your DB Name' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid > @spid END ...
Read More »

Friday, December 4, 2015

How to use the simple Dynamic pivot in SQL Server (Dynamic Columns)

Normal 0 false false false EN-US X-NONE HI ...
Read More »