Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

sql server - Why does SQL Management Studio add a cross join? -


i need run basic updates on join. example:

update t1 set col1 = 'val1' table1 t1 inner join table2 t2 on t1.id = t2.t1_id t2.col3 = 'val3' 

this works perfectly, reason, in ms sql management studio express, wants convert to

update t1 set col1 = 'val1' table1 t1 inner join table2 t2 on t1.id = t2.t1_id cross join t2 t2.col3 = 'val3' 

it adds crossjoin reason don't understand.

now question is: why management studio think meant? must have genuine use, otherwise wouldn't suggest it. yet have no idea how , when (and why).

according msdn cross join equivalent inner join. perhaps uses cross joins because cross join can used create cartesian products simpler joins - whereas inner join more limited.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -