Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Suresh Behera

The Microsoft .Net Junkies

  • V-Days Vs SQL

    Open query analyzer and press Ctrl + T and run this below code.
    See what the magic will be happen.Thanks  Narayan.
    With regards,
    -Suresh ,Microsoft MVP .Net
    -----------------------------------------------------
    /*
    Author: Steve Kass, Drew University
    Hosted by: http://vyaskn.tripod.com
    Script works on SQL Server 7.0 and 2000
    */
    USE tempdb
    GO
    SET NOCOUNT ON
    CREATE TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26] (nbr int IDENTITY)
    DECLARE @i int
    SET @i = 0
    WHILE @i < 25
    BEGIN
    	INSERT INTO [seqA1740E61-1E21-11D6-B831-E02C0D466A26] DEFAULT VALUES
    	SET @i = @i + 1
    END
    DECLARE @heart binary(264)
    SET @heart =
      0x010b0e12220b0108100e25
    + 0x080105120a280501031406
    + 0x2a03010215042b02010116
    + 0x022c010100160201000100
    + 0x1602010001000100010001
    + 0x0001000100010101002c01
    + 0x010201002b020104010029
    + 0x0401060100270601080100
    + 0x2508010a0100230a010c01
    + 0x00210c010e01001f0e0110
    + 0x01001d10011201001b1201
    + 0x1401001914011601001716
    
    SELECT
      STUFF(STUFF(STUFF(
          R,A/256,A%256,SPACE(A%256)),
            B/256,B%256,SPACE(B%256)),
            C/256,C%256,SPACE(C%256))
    AS N'I love you/Eu te amo/Ti amo/Je t''aime/Ya vas lyublyu/Ich liebe Dich!!!'
    FROM (
      SELECT Nbr AS L, SUBSTRING(S,Nbr,2*L) AS R FROM (
        SELECT
          LEN(S+'*') AS L,
          REPLICATE(S+'*',4) AS S
        FROM (
          SELECT 'Happy-Valentine''s-Day' AS S
        ) X
      ) V CROSS JOIN [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
      WHERE Nbr BETWEEN 1 AND L
    ) W JOIN (
      SELECT
        Nbr,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-5,2)) AS A,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-3,2)) AS B,
        CONVERT(int,SUBSTRING(@heart,6*Nbr-1,2)) AS C
      FROM [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
      WHERE Nbr BETWEEN 1 AND 24
    ) X
    ON L = Nbr
    GO
    DROP TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
    

  • Icons on Menus

    I tryed hard to get a icon on menus,unfortunatly the .Net does not gives built in support to add a icon on menu.I found one nice article on msdn.

  • IBM calls Sun's bluff over Open Source

    IBM has called Sun's bluff over open source, responding to a challenge laid down by Simon Phipps (Sun's Chief Technology Evangelist) when talking to at EclipseCon 2004 in which he asked "Why hasn't IBM given its implementation of Java to the open-source community?" by offering to work with Sun to open source Java.

  • Application Interoperability:Microsoft.NET & J2EE

    This white paper specifically addresses the ‘Interoperability’ between .NET and J2EE applications, in explaining the various techniques by which ‘Interoperability’ can be achieved. This white paper also recommends the preferred way and charts down some of the best practices in achieving ‘Interoperability’.