sql - 'MOD' is not a recognized built-in function name -

-

i wanted use mod function in sql server 2008r2 , followed link still got message:

'mod' not recognized built-in function name.

declare @m int set @m = mod(321,11) select @m

error:

msg 195, level 15, state 10, line 2
'mod' not recognized built-in function name.

why can't use function link above?

the mod keyword exists in dax language (tabular dimensional queries), not tsql

use % instead.

ref: modulo


Comments

Post a Comment

Popular posts from this blog

arrays - PHP Shopping Cart Variable and Object errors -

-
i need eliminate errors im getting. have shopping cart displayed on products page way of cart update page. below pair of errors (notices) every product listed: notice: undefined variable: obj in c:\xampp\htdocs\project2\browseproducts.php on line 89 notice: trying property of non-object in c:\xampp\htdocs\project2\browseproducts.php on line 89 when click on of add cart buttons, nothing added cart , get: notice: undefined index: stock in c:\xampp\htdocs\project2\cart_update.php on line 25 my code is: <?php $user = "root"; $password = ""; $database = "webstore"; mysql_connect("localhost", $user, $password); @mysql_select_db($database) or die("unable select database"); $current_url = base64_encode("http://".$_server['http_host'].$_server['request_uri']); $query = "select * products order category"; ...
Read more

mysql - java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) -

-
after validation of select combo box have selected not able insert in database. tomcat gives following error java.sql.sqlexception: parameter index out of range (1 > number of parameters, 0). how caused , how can solve it? you error when call of setxxx() methods on preparedstatement , while sql query string not have placeholders ? this. for example wrong : string sql = "insert tablename (col1, col2, col3) values (val1, val2, val3)"; // ... preparedstatement = connection.preparestatement(sql); preparedstatement.setstring(1, val1); // fail. preparedstatement.setstring(2, val2); preparedstatement.setstring(3, val3); you need fix sql query string accordingly specify placeholders. string sql = "insert tablename (col1, col2, col3) values (?, ?, ?)"; // ... preparedstatement = connection.preparestatement(sql); preparedstatement.setstring(1, val1); preparedstatement.setstring(2, val2); preparedstatement.setstring(3, val3); note parameter i...
Read more