Syntax Question

Can I hide a part of the text by a "More..." link?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > MS SQL database development > Syntax Question 25 November 2007 16:51:45

Recent blog posts:

How to convert DVD Video to…
Most people who own an iPhone 3G know they can watch videos but they may not know how to exactly. So the…

Softswitch from IXC! 24/7…
We, Interexchange Carrier (IXC), are offering a perfect authentic solution in SoftSwitch and billing…

Low cost website promotion
Making a website is the easy part, getting the website to do what it was intended to do is the difficult…

How to converter DRM WMA to MP3…
This guide will show you how to convert DRM WMA to usable MP3 with DRM converter software, then you can…

Clone2go Free Video Converter…
Clone2go Free Video Converter(http://www.clone2go.com/products/freevideo.php ) is a…

wcorto@gmail.com
wcorto@gmail.com

All in one Video Converter…
Wondershare Video Converter Platinum is the best video format converter that can convert your video…

Konichi-wa
Konichi-wa,people.

Buy or rent from IXC VoIP…
=^B IXC can offer you the following solutions for such VoIP services: 1. Wholesale / Retail…

How to Transfer iTunes M4P…
If you've got an iPod, you go and buy m4p files from iTunes store, but then your machines dies, or have…

They have birthday today:

Yolanda Montealegre

huangyongxian

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

Reads and writes to a sql…
Is it possible to find the reads/writes to a sql server table ?

Insert Function Help
Hello All I have been looking over the various forums and threads trying to learn as much as I can…

dependent assembly…
Hi. Looking for any help I can find! I have a brand new virtual server running Windows Server 2003…

format files for use with bulk…
I used bcp to produce the apended format file. How can it be modified to recognize the quotes that…

Allow NULL or Define DEFAULT…
I am designing a new table with a few columns that may or may not have a value on each row that is…

Recent forum topics:

Re: new 'failthrow' branch for…
Patrick R. Michaud wrote: Not all undefined values are unhandled Failures. It can be an undefined…

Stupid question
I have a script that outputs this: 0.023884057998657 What's the command to make it shrink down to this…

neopets hacking
for all of ya'll who play neopet this is a great way to get rich quick okay see this link at the bottom…

2nd: switch between template…
Dear List readers and ZMS devels, regarding my last posting yesterday i will try to…

Recent forum comments:

RE: Crystal Reports in VB.NET
How to Pick a Colour from colourdialouge box in the crystal reports text object

RE: 2nd: switch between template…
Hello Niels, different for a Maybe my proposed approach for filesystem-based template-editing…

RE: RE: TinyMCE
Hi Stefan It would be great, if you can post your patch. We are very interested. We got two main…

RE: RE: TinyMCE
Hi Sebastian I'll try this one out. Thanks a lot! --- In…

RE: RE: TinyMCE
Hallo Herr Seifert, ich bin sehr an der Integration vom Epoz-Editor in ZMS 2.10.5 interessiert. Es w…

RE: Stupid question
On Fri, Sep 5, 2008 at 8:42 AM, Bruce Johnson <johnson@pharmacy.arizona.edu> wrote…

RE: DBD::Oracle 1.22 - Problem…
John, Now that you are back from vacation (I hope it went well), did you see this? I have also logged…

RE: Stupid question
Bruce Johnson wrote: Go to http://search.cpan.org tap "DBD::Oracle" into the module…

RE: Stupid question
Where can I find older versions of DBD::Oracle...in particular I need 1.18 or 1.17 I have a massively…

RE: DBD-Oracle-1.16 Error on AIX…
Deo wrote: I might be I have never tried it myself. Normally what I see is the compiler that comes…

Moderators:

Administrator
Protorioris


Syntax Question
Guest 25 November 2007 16:51:45
	SQL Server 2000 When joining tables, some use: AliasTableName.ColumnName = AliasTableName.Column while others use LEFT/RIGHT etc JOIN ....... Is one better than the other in cases where the join is a simple JOIN of equality ? Curious ... Thanks, Craig
		Add comment


David Portas 11 May 2005 17:50:41 [ permanent link ]
	In a WHERE clause your first example would perform an INNER JOIN whereas LEFT and RIGHT are keywords for OUTER JOINs. So these are not equivalent at all. For INNER joins either put the criteria in the WHERE clause or use the FROM ... INNER ... ON syntax. The choice mainly comes down to personal preference and coding style within your organization. For OUTER joins always use the { { LEFT \| RIGHT \| FULL } [OUTER] } JOIN syntax. Avoid the obsolete = / =, which has some problems and limitations and won't be fully supported in future. -- David Portas SQL Server MVP --
		Add comment


ThatsIT.net.au 18 November 2007 09:53:41 [ permanent link ]
	"Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message news:Xns99EBC912567ACeejj99@194.109.133.242... McKirahan wrote on 17 nov 2007 in microsoft.public.inetserver.asp.general: Yes; though your first set of parentheses is wrong. Also, for readability, take a look at this: If (SubsQuestions = "Yes" And Area = "Six") _ Or (SubsQuestions = "Yes" And Area = "Seven") Then 'Do stuff Else 'Do not End If I prefer for readability: SQy = SubsQuestions = "Yes" A6 = Area = "Six" A7 = Area = "Seven" If SQy AND (A6 OR A7) Then 'Do stuff Else 'Do not End If or: SQy = SubsQuestions = "Yes" A6 = Area = "Six" A7 = Area = "Seven" A6orA7 = A6 OR A7 If SQy AND A6orA7 Then 'Do stuff Else 'Do not End If To use a bit of both your suggestions testQ = (SubsQuestions = "Yes") test6 = (Area = "Six") test7 = (Area = "Seven") IF testQ then IF test6 OR test7 THEN 'Do stuff END IF ELSE 'Do not END IF -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress)
		Add comment


ThatsIT.net.au 25 November 2007 16:51:45 [ permanent link ]
	"McKirahan" <News@McKirahan.com> wrote in message news:dYKdnbRn_v3avdranZ2dnUVZ_rWtnZ2d@comcast.com... "ThatsIT.net.au" <me@thatsit> wrote in message news:0B03165D-385B-490C-AB08-AB59F67BC46D@microsoft.com... "McKirahan" <News@McKirahan.com> wrote in message news:WpmdnWFbL48syt3anZ2dnUVZ_tuonZ2d@comcast.com... "ThatsIT.net.au" <me@thatsit> wrote in message news:67AA2DFD-4317-4A5D-8BDD-14D45520ADDA@microsoft.com... "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message news:Xns99EBC912567ACeejj99@194.109.133.242... [snip] I prefer for readability: SQy = SubsQuestions = "Yes" A6 = Area = "Six" A7 = Area = "Seven" If SQy AND (A6 OR A7) Then 'Do stuff Else 'Do not End If [snip] To use a bit of both your suggestions testQ = (SubsQuestions = "Yes") test6 = (Area = "Six") test7 = (Area = "Seven") IF testQ then IF test6 OR test7 THEN 'Do stuff END IF ELSE 'Do not END IF Sorry, that's not equivalent;you don't handle: IF test6 OR test7 THEN's ELSE yes it is, first subquerys must be true or it fails, only if subquerys is true need we test test6 or test7 Sorry, it's not. If the second test fails you do not perform "Do not". IF testQ then IF test6 OR test7 THEN 'Do stuff ELSE <= you don't allow for this 'Do not END IF ELSE 'Do not END IF OK I see what you mean, my error
		Add comment

QAIX > MS SQL database development > Syntax Question 25 November 2007 16:51:45

	see also: Re: [Fwd: Re: Build fails when run in… anthill website down? is it possible to build a specific…		пройди тесты:		see also: Hallo It's me Hi!I'm ok)Your?

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

Syntax Question

Add new comment