20 August 2013

Update alternate rows in sqlserver

›
update s set recstatus=’I’ from (select row_number() over (order by id) sno,* from mastertbl)s where sno%2=0 or with c as ( select row_numbe...
02 August 2013

Int range in .net

›
Int16 : The value of this constant is 32767 : hexadecimal 0x7FFF Int16 (or short) uses 16 bits to store a value, giving it a range from -32,...
10 February 2013

9 February

›
i). Machine. Config ii). Web.Config (For desktops app.Config) Common paints for confn files: These are simple text files & can be ed...
01 February 2013

SQL SERVER – Introduction to JOINs – Basic of JOINs

›
INNER JOIN This join returns rows when there is at least one match in both the tables. OUTER JOIN There are three different Outer Join metho...
25 January 2013

Create virtual files in asp

›
    private void virfile()     {         if (!Directory.Exists(Server.MapPath("download/")))             Directory.CreateDirectory...
22 January 2013

WCF Tutorial

›
                              WCF(WINDOWS COMMUNICATION FOUNDATION ) Introduction to WCF: Windows Communication Foundation (Code named Indig...

WCF Tutorial

›
                              WCF(WINDOWS COMMUNICATION FOUNDATION ) Introduction to WCF: Windows Communication Foundation (Cod...
20 January 2013

Image binary format c#

›
source:     <div>         <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"    ...
06 January 2013

Row to Column conversion separated delimiter in sql

›
declare @str1 varchar(max)=',,sql,,,asp,technique,yield,ado,,' declare @str2 varchar(max)='' create table #tbl1 (id varchar(...
02 January 2013

Reset Identity for the table in sqlserver

›
CREATE TABLE IdentTest (Ident INT NOT NULL IDENTITY (1,1), varfield varchar(100)) INSERT INTO IdentTest VALUES ('abc') DBCC CHECKIDE...
01 January 2013

Happy new Year with sqlserver query

›
SELECT CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15) + CHAR(15) + CHAR(15) + CHAR(15) +...
05 December 2012

Create a table named 'select' with column 'table'

›
SET QUOTED_IDENTIFIER ON CREATE TABLE "SELECT" ("TABLE" int) When SET QUOTED_IDENTIFIER is ON, all strings delimited by ...
15 November 2012

Customize sql startup query window from:

›
C:\Users\My-PC\AppData\Local\VirtualStore\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SsmseeTemplates\Sql\Sql...
06 October 2012

Replace multiple spaces with one/none in sql server

›
select replace(replace(replace(LTrim(RTrim('      6      Spaces  6      Spaces.      ')),'  ',' |'),'| ',...

sort array of int values without using built-in functions (using Bubble sort)

›
string res = ""; int[] arr = { 800, 11, 50, 771, 649, 770, 240, 9 }; for (int k = 0; k < arr.Length; k++) { for (int i = 0; i ...