4,669 questions
2
votes
1
answer
3k
views
Database alias in Informix
In Informix I can run SQL statement that use other database:
INSERT INTO other_db:mytable ...
I would like "unite" both databases, but I would like do it "step by step".
At first I want to move all ...
- 54.5k
4
votes
5
answers
8k
views
MySQL: Use Aliased Fields in Aggregate Functions
I have a SQL statement similar to this:
SELECT COUNT(*) AS foo, SUM(foo) AS foo_sum FROM bar
But MySQL doesn't allow this because foo is an alias. Does anyone have an idea of how this could be ...
- 6,002
10
votes
3
answers
46k
views
How do you create "Aliases" in Apache Tomcat?
I am working on a web application that allows users to upload attachments. These attachments are stored on a different drive than that of the web application. How can I create an alias (equivalent ...
- 6,830
7
votes
9
answers
12k
views
What type of scope does Haskell use?
I'm trying to figure out if Haskell uses dynamic or static scoping.
I realize that, for example, if you define:
let x = 10
then define the function
let square x = x*x
You have 2 different "x's", and ...
- 15.8k
1
vote
6
answers
1k
views
Readable SQL aliases
Since I'm sure many people have different standard, I've made this post a community wiki.
My question is, what's a good naming scheme for table aliases? I've been using the first letter of every word ...
11
votes
4
answers
7k
views
How does one - without inheritance - override a class method and call the original from within the new method?
I found one source which successfully overrode Time.strftime like this:
class Time
alias :old_strftime :strftime
def strftime
#do something
old_strftime
end
end
The trouble is, strftime ...
- 11.9k
6
votes
5
answers
1k
views
C# Default scope resolution
I have inherited a c# class 'Button' (which I can't change) which clashes with the BCL class 'Windows.Forms.Button'. Normally, Id be very happy to go:
MyPackage.MyClass.Button;
But there are a large ...
- 48.1k
6
votes
9
answers
1k
views
Is it correct to use inheritance instead of name aliasing in c#?
In other words, is it correct to use:
public class CustomerList : System.Collections.Generic.List<Customer>
{
/// supposed to be empty
}
instead of:
using CustomerList = System.Collections....
- 12.4k
5
votes
5
answers
36k
views
Double Quotes in Oracle Column Aliases
Ok, this is bit of an obscure question, but hopefully someone can help me out with it.
The system I'm working on builds a dynamic SQL string for execution inside a stored procedure, and part of that ...
- 5,252
7595
votes
67
answers
1.4m
views
What is the difference between String and string in C#?
What are the differences between these two, and which one should I use?
string s = "Hello world!";
String s = "Hello world!";