Viewing 15 posts - 61 through 75 (of 188 total)
Another thing I would suggest is to minimize the use of special characters in database and object names. Instance names you can't always avoid having special characters (\ for example)....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
May 27, 2009 at 6:08 am
Anyone who still uses text variables should be shot, especially because it makes me read the question wrong.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
April 28, 2009 at 7:11 am
Jayeff (4/22/2009)
mike (4/22/2009)
Can I get...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
April 22, 2009 at 9:52 am
You can write a whole library about this.
Yes, use PK's in your joins, so you can use their indexes. This is pretty much a general rule that applies for...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
April 21, 2009 at 5:33 am
Hrm, why did I do left 4!
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
April 21, 2009 at 5:21 am
No! Yes! .... Maybe? should be a third option then... As what a former poster said, it sounds like SQL Server has a female intuition inside 🙂
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
April 13, 2009 at 6:15 am
I like these questions a lot more than making 'SQL puzzles', just by showing bad code. Your question is a typical sample of what I run into daily. Every DBA...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 23, 2009 at 8:05 am
What you have read is correct... Adding columns into the middle of the table is quite fuzzy and out of database technical view not needed. However, many people tend to...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 18, 2009 at 7:56 am
I think the correct query would be to add the GROUP BY of course, and also ORDER BY 3 DESC. Or name the derived item, and order by that name....
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 18, 2009 at 7:23 am
LOLOLOLOLOL!!!
If it makes you feel better to keep insisting on how (fill in the blank) everyone else is, while you are superior in every possible fashion, by all...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 17, 2009 at 12:43 pm
If I were you, change jobs so you can be fully a C# developer. If we may believe you, SQL will be obsolete in a few years anyway.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 17, 2009 at 11:16 am
Ha, I guess I was too slow answering, or I didn't read the whole thread first...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 16, 2009 at 9:53 am
Both statements work for me in Access:SELECT '"STICHTING WERELDHULP-BELGIE"'
SELECT """STICHTING WERELDHULP-BELGIE"""
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 16, 2009 at 9:52 am
I would like to pass my data like this
region = 'NE,'SE','SW','SE'
SalesPerson = 'Smith','Barney','Jones' if All Sales People selected or
SalesPerson = 'Smith' if only smith is selected.
Were you trying...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 16, 2009 at 9:35 am
Explaining what you're trying to achieve sounds like a good idea... Along with DDL and sample input. Since I don't know what you're trying to do, the only thing that...
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 13, 2009 at 7:03 am
Viewing 15 posts - 61 through 75 (of 188 total)