Viewing 15 posts - 14,986 through 15,000 (of 15,381 total)
Looks like the answer you got will return the same thing you already figured out (although maybe a little simpler). What is the result you are looking for?
February 28, 2011 at 10:58 am
What is the error message? This error number can have several different messages along with it.
February 28, 2011 at 10:44 am
It sounds like it is a connection string issue. Check out Connection Strings[/url] website. That error number is one I have dealt with myself and simple getting the right connection...
February 28, 2011 at 10:34 am
I took a different approach and just formatted it...
select Code + char(13) + Name + char(13) + cast(Data as varchar(50)) + char(13)
February 25, 2011 at 2:01 pm
The other thing you should learn from this is why your original results were wrong. When you joined your tables with no condition you were actually creating the sum of...
February 25, 2011 at 1:48 pm
KermitTheRock (2/25/2011)
The table will use FTS on...
February 25, 2011 at 1:21 pm
For example, I say things like, "we'll burn that bridge when we come to it".
One of mine is "it is not rocket surgery". 😛
February 25, 2011 at 1:14 pm
Yes this is an asp.net issue and nothing to do with the database at all. This is a precaution in .net to prevent certain types of injection attacks like xss...
February 25, 2011 at 11:26 am
Not really sure what your are meaning about a non-unique index in the context that you are referring to it.
With 70,000 rows i would think you want to have...
February 25, 2011 at 10:44 am
1. Can a primary key be non unique?
NO. This is the definition of a primary key.
2. Can I create a non unique index without a primary key?
Yes.
3. Should I have...
February 25, 2011 at 10:27 am
WayneS (2/25/2011)
Gianluca Sartori (2/25/2011)
Sean Lange (2/25/2011)
...there is not a table to log against. This is no different than any other variable type.
Not true: operations on table variables are logged, but...
February 25, 2011 at 9:57 am
Carlton Leach (2/25/2011)
Sean Lange (2/25/2011)
Carlton Leach (2/25/2011)
My 5 cents is always use a temp table. It behaves more like a real table than a table variable does.Carlton.
There are perfectly valid...
February 25, 2011 at 9:48 am
Check out convert here. You can do this pretty painlessly.
February 25, 2011 at 9:46 am
1. make a SQL query box on a page so that it links to the database and users can make their own queries from ASP. Is that possible?
Be VERY careful...
February 25, 2011 at 9:44 am
This sounds like it is a job for the front end and not sql. sql is just an engine to store and retrieve data. Formatting is best left to whatever...
February 25, 2011 at 9:37 am
Viewing 15 posts - 14,986 through 15,000 (of 15,381 total)