sql server 2008 r2 - SQL Like statement is ordering results -

-

can please explain why simple sql statement cause results ordered column being 'liked'...

select * organisation company_name '%marce%'

the above cause results ordered company name...

select * organisation

will show results in index / id order.

order not guaranteed without explicitly using order by clause. it's arbitrary. there exist index on field, responsible 'natural' ordering of results, shouldn't relied upon.


Comments

Post a Comment

Popular posts from this blog

c# - Attribute value in root node of xml Linq to XML -

-
while parsing xml linq xml, came across strange behaviour (atleast me). below first xml parsed `<?xml version="1.0" encoding="utf-8"?> <testrun> <unittestresult testname = "arun" outcome = "i"> </unittestresult> <unittestresult testname = "arun1" outcome = "i"> </unittestresult> </testrun>` my code looks xdocument doc = xdocument.parse(filecontents); var result = doc.descendants("unittestresult"); the above works fine. if root node contain attributes same code not working. reason. xml sample below <?xml version="1.0" encoding="utf-8"?> <testrun id="7903b4ff-8706-4379-b9e8-567034b70abb" name="inaambika@inbelw013312a 2016-02-26 16:55:14" runuser="stc\inaambika" xmlns="http://microsoft.com/schemas/visualstudio/teamtest/2010"> <unittestresult testname = "arun" outcome = "...
Read more

android - Retrieve value from radioButtons in alertDialog -

-
i want retrive value radio buttons. doing below code. when click ok button of alert dialog app force closed. why is so. not retriving value properly final sharedpreferences settings = getsharedpreferences(prefs_name, mode_private); if (settings.getboolean("isfirstrun", true)) { layoutinflater li = layoutinflater.from(this); view promptsview = li.inflate(r.layout.prompts, null); alertdialog.builder alertdialogbuilder = new alertdialog.builder(this); alertdialogbuilder.setview(promptsview); final edittext userinput = (edittext) promptsview .findviewbyid(r.id.edittextdialoguserinput); final radiogroup radiogroup = (radiogroup) findviewbyid(r.id.radiogroup1); // set dialog message alertdialogbuilder.setcancelable(false).setpositivebutton("ok", new dialoginterface.onclicklistener() { public void onclick(dialoginterface dialog,int which...
Read more

mongodb - Struggling to get ordered results from the last retrieved article, given array of elements to search in -

-
i have collections of objects structure this: { "_id" : objectid("5233a700bc7b9f31580a9de0"), "id" : "3df7ce4cc2586c37607a8266093617da", "published_at" : isodate("2013-09-13t23:59:59z"), ... "topic_id" : [ 284, 9741 ], ... "date" : numberlong("1379116800055") } i'm trying use following query: db.collection.find({"topic_id": { $in: [ 9723, 9953, 9558, 9982, 9833, 301, ... 9356, 9990, 9497, 9724] }, "date": { $gte: 1378944001000, $lte: 1378954799000 }, "_id": { $gt: objectid('523104ddbc7b9f023700193c') }}).sort({ "_id": 1 }).limit(1000) the above query uses topic_id, date index not keep order of returned results. forcing use hint({_id:1}) makes results ordered, nscanned 1 million documents though limit(1000) specified. what missing?
Read more