sql server - Non Deterministic Function -


sql server telling me function non deterministic. confused because given date x return same.

dateadd(d, 13 - datediff(d, '9/23/10', servicedate) % 14, servicedate) 

  convert(date,  dateadd(d, 13 - datediff(d, convert(date, '9/23/10',101), servicedate) % 14, servicedate),101)

when refer date data type string literals in indexed computed columns in sql server, recommend explicitly convert literal date type want using deterministic date format style. list of date format styles deterministic, see cast , convert. expressions involve implicit conversion of character strings date data types considered nondeterministic, unless database compatibility level set 80 or earlier. because results depend on language , dateformat settings of server session. example, results of expression convert (datetime, '30 listopad 1996', 113) depend on language setting because string '30 listopad 1996' means different months in different languages. similarly, in expression dateadd(mm,3,'2000-12-01'), database engine interprets string '2000-12-01' based on dateformat setting.

cast

deterministic unless used datetime, smalldatetime, or sql_variant.

convert

deterministic unless 1 of these conditions exists:

...

source or target type datetime or smalldatetime, other source or target type character string, , nondeterministic style specified. deterministic, style parameter must constant. additionally, styles less or equal 100 nondeterministic, except styles 20 , 21. styles greater 100 deterministic, except styles 106, 107, 109 , 113.


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more