stuff (74)


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 us…


Hidden Features of Java

Locked.This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new answers or interactions. After reading Hidden Featu…


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 values rows group