Viewing 15 posts - 58,606 through 58,620 (of 59,053 total)
As a "best practice", you should always use at least the two part naming convention, which includes the user name. There's dozens of articles on this recommendation on the Web......
October 31, 2005 at 10:13 pm
>because DB programming is almost the same in oracle and in sql 2000
Boy oh boy are you in for a surprise! Take, for instance, that SQL Server 2000 has a...
October 31, 2005 at 9:59 pm
Couldn't see the forest for the circumlocution ![]()
October 31, 2005 at 9:44 pm
I don't get it, Neetu... you posted...
RefNo Pro_No Country
1. 11,22,33,44 X
2. 33,44,22,11 Y
3. 44,55,33,22 Z
Explain to me why 44 is in RefNo 1, why 33,44 is in RefNo2, and why...
October 31, 2005 at 9:38 pm
You bet, Henk... thank you for the feed back.
I gotta know... what's comical about it?
October 31, 2005 at 5:24 pm
"The difficult can be done immediately... the impossible takes slightly longer."
This will work but the creation of a real "Numbers" table would be better as it would be more predictable...
October 31, 2005 at 6:16 am
My mistake... I misread BOL... the NVARCHAR(4000) is for the command line INPUT... you can't get more than 255 characters in the OUPUT... so, the following will work just fine...
October 31, 2005 at 5:52 am
You just don't need to write a VB script to count the number of files in a directory from T-SQL. In fact, with a little clever CMD line code in...
October 30, 2005 at 8:37 am
Just adding my two cents...
Use STR(n,l,d) for numerics on this...
n = number to convert
l = final length of all characters (defaults to 10)
d = number of decimal places (defaults to...
October 30, 2005 at 8:07 am
I share David Burrow's opinion of this series of articles. Very well written with a great amount of understanding of what's what in the world of employment both from the employee...
October 25, 2005 at 5:52 am
The computed sum column example a couple of postings above may give an incorrect sort order depending on the data.
The ORDER BY CASE example works wonderfully for 3 columns. It does...
October 22, 2005 at 11:32 pm
Sounds more like homework than a request from the vendor...
October 16, 2005 at 7:59 pm
Thank you Carl... that's just what the Dr. ordered.
October 15, 2005 at 9:51 am
Viewing 15 posts - 58,606 through 58,620 (of 59,053 total)