• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Daily Archives: August 5, 2010

Breadcrumbs implementation in ASP.NET

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Following is the code to implement the breadcrumbs in asp.net

/* Add Web.sitemap.  To add this file, right click on Project Folder, select option "Add New Item".
Select Site Map and add file.  Your file should contain nodes like below :

<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0&quot; >
<siteMapNode url="~/default.aspx" title="Home"  description="Home">
<siteMapNode url="~/OrderDetails/OrderList.aspx" title="OrderList" description="" />
<siteMapNode url="" title="Search" description="" >
<siteMapNode url="~/GallerySearch/NewGallarySearch.aspx" title="Gallary Search"  description=""/>
<siteMapNode url="~/Search/Search.aspx" title="Advance Search"  description=""/>
</siteMapNode>
<siteMapNode url="" title="Administration"  description="">
<siteMapNode url="~/Partner/PartnerList.aspx" title="Partner List"  description="" >
<siteMapNode url="~/Partner/PartnerSummary.aspx" title="Partner Summary"  description="">
<siteMapNode url="~/Partner/EditPartner.aspx" title="Partner Edit"  description="" />
<siteMapNode url="~/Partner/PartnerProduct.aspx" title="Partner Product" description="" />
</siteMapNode>
</siteMapNode>
</siteMapNode>
<siteMapNode url="~/User/ViewaccountInfo.aspx" title="My Profile" description="" />
<siteMapNode url="" title="Help"  description="" />
</siteMapNode>
</siteMap>

/* To implement Breadcrumb upto first level of Querystring, add following code in your Global.aspx */

<%@ Application Language="C#" %>
<%@ Import Namespace="System.Diagnostics" %>

<script runat="server">
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);
}

void Application_End(object sender, EventArgs e)
{
//  Code that runs on application shutdown
}

void Application_Error(object sender, EventArgs e)
{
//Exception objErr = Server.GetLastError().GetBaseException();
//string err = "Error in: " + Request.Url.ToString() +
//                  ". Error Message:" + objErr.Message.ToString();
//if (Session["SessionInformation"] == null)
//{
//    Server.Transfer("../Logout.aspx");
//}
}

void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
//HttpContext context = HttpContext.Current;
//HttpCookieCollection cookies = context.Request.Cookies;
}

void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
// Note: The Session_End event is raised only when the sessionstate mode
// is set to InProc in the Web.config file. If session mode is set to StateServer
// or SQLServer, the event is not raised.
Application_Error(sender, e);
}

//Function to add breadcrumb with Querystring.
SiteMapNode AppendQueryString(object o, SiteMapResolveEventArgs e)
{
if (SiteMap.CurrentNode != null)
{
SiteMapNode temp;
temp = SiteMap.CurrentNode.Clone(true);
Uri u = new Uri(e.Context.Request.Url.ToString());
temp.Url += u.Query;
if (temp.ParentNode != null)
{
temp.ParentNode.Url += u.Query;
}
return temp;
}
else
{
return null;
}
}

</script>

/* Add following tag in Master Page, where you want to implement site map.

<asp:SiteMapPath ID="SiteMapPath1" runat="server" Font-Names="Verdana" ParentLevelsDisplayed="8"
Font-Size="0.8em" PathSeparator=" ->">
<PathSeparatorStyle Font-Bold="True" ForeColor="#507CD1" />
<CurrentNodeStyle ForeColor="#333333" />
<NodeStyle Font-Bold="True" ForeColor="#284E98" />
<RootNodeStyle Font-Bold="True" ForeColor="#507CD1" />
</asp:SiteMapPath>

Gauri Deshpande / Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

2 main functions in c#

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in C#

≈ Leave a comment


Mechanism by which u can define more than 1 main method.

Eg.

Class Main1
{
Public static void main()
{
Console.WriteLine("Main 1");
}
}

Class Main2
{
Public static void main()
{
Console.WriteLine("Main 2");
}
}

CSC MultipleMain.cs / main:Main1
In addition attempting to compile application consisting of multiple classes with
defined main methods and not specifying the /main switch will result in a compiler error.

Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

SPACE FUNCTION IN SQL SERVER 2005

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in SQL Concepts

≈ Leave a comment


SPACE FUNCTION IN SQL SERVER 2005

This will give space / spaces to you

Eg.
SELECT ‘Pawan’ + SPACE(1) + ‘Kumar’ –This will insert one space between Pawan and Kumar.
You can replace ‘ ‘ with SPACE(1)

Eg.
SELECT LEN(SPACE(2)) — This will give you 0 as len trims the spaces

Eg.
SELECT DATALENGTH(SPACE(2)) — This will return 2 as datalength does not trim the spaces.

Share Knowledge.We all are here to learn.

Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

REMOVE EXTRA MULTIPLE SPACES IN STRING IN SQL SERVER 2005

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in SQL Concepts

≈ Leave a comment


REMOVE EXTRA MULTIPLE SPACES IN STRING IN SQL SERVER 2005

Use following funtion to remove multiple spaces in string in SQL Server 2005

CREATE FUNCTION fnRemoveMiddleSpaces (@InputString VARCHAR(1024))
RETURNS VARCHAR(1024)
AS
BEGIN
WHILE CHARINDEX(SPACE(2),@InputString) > 0
SET @InputString =
REPLACE(@InputString,SPACE(2),SPACE(1))
RETURN @InputString
END
GO

DECLARE @Str varchar(256)
SET @Str = ‘Saurabh              Dolare            ‘
SELECT DATABEFORESPACES = @Str, DATABEFORESPACESREMOVED = dbo.fnRemoveMiddleSpaces (@Str)
GO

You can also use stuff function to remove spaces if you know the string in advance.

Eg.

SELECT STUFF ( ‘Gauri          Despande’ , 6 , 9 , ”)

Share Knowledge.We all are here to learn.

Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

COPY DATA FROM ONE TABLE TO ANOTHER IN SQL SERVER 2005

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in SQL Concepts

≈ Leave a comment


COPY DATA FROM ONE TABLE TO ANOTHER IN SQL SERVER 2005

CREATE TABLE EMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

INSERT INTO EMPLOYEE
SELECT ‘Pawan’ , 180000
UNION ALL
SELECT ‘Gaurav’ , 80000
UNION ALL
SELECT ‘Saurabh’ , 80000
UNION ALL
SELECT ‘Pawan’ , 830000
UNION ALL
SELECT ‘Neelam’ , 80000

SELECT * FROM EMPLOYEE

CREATE TABLE COPYEMPLOYEE
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
EMPNAME VARCHAR(100),
SALARY DECIMAL
)

—USE the following query to copy data from table to another

INSERT INTO COPYEMPLOYEE
SELECT EMPNAME ,  SALARY FROM EMPLOYEE

–CHECK Data in the new data

SELECT * FROM COPYEMPLOYEE

Share Knowledge.We all are here to learn.

Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email
← Older posts

Blog Stats

  • 1,085,537 hits

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

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

August 2010
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Jul   Sep »

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar