stuff (72)


Hidden Features of C#?

Hidden Features of C#?

This came to my mind after I learned the following from this question: where T:struct We, C# developers, all know the basics of C#. I mean declarations, conditionals, loops, operators, etc. Some of…


Hidden Features of Java

After reading Hidden Features of C# I wondered, What are some of the hidden features of Java?…


How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

I didn't see any similar questions asked on this topic, and I had to research this for something I'm working on right now. Thought I would post the answer for it in case anyone else had the same quest…


java When do you use a JSP and when a Servlet?

This question already has an answer here: What is the difference between JSF, Servlet and JSP? 16 answers I have an application that sends the customer to…


How can I combine multiple rows into a comma-delimited list in SQL Server 2005?

Right now, I have a SQL Query like this one: SELECT X, Y FROM POINTS It returns results like so: X Y---------- 12 3 15 2 18 12 20 29 I'd like to return results all in one row, like this…


How do I add a Line break in a SQL Server Stored Procedure?

I'm making a Stored Procedure that basically concatenates a long string with data from many records. I want to do: set @[email protected]+'aaa'+LINEBREAK How do I specify that line break?…



Wicket and JSPs

Using add(new Include()) syntax, I was able to include jsps which are at the top level. However those which are present inside 'WEB-INF' cannot be referenced, is there any way to achieve this?…


Aggregate adjacent only records with T-SQL

I have(simplified for the example) a table with the following data Row Start Finish ID Amount------------------------------ 1 2008-10-01 2008-10-02 01 10 2 2008-10…


How to preserve an ampersand(&) while using FOR XML PATH on SQL 2005

Are there any tricks for preventing SQL Server from entitizing chars like &,<, and>? I'm trying to output a URL in my XML file but SQL wants to replace any '&' with '&amp;' Take the following quer…


Where can I get a large Sql Server sample database?

I was wondering if it is possible to get a large, enterprise-scale sample Sql Server database? I am working with Sql Server 2005, and feel that looking at a large scale database would really improve…




sql server string for how column with rows group values