sql server - TSQL Error handling, getting SQL Query which triggered an error -


i know these functions handling sql error

  1. error_line()
  2. error_message()
  3. error_number()
  4. error_procedure()
  5. error_severity()
  6. error_state()

described here https://technet.microsoft.com/en-us/library/ms179495(v=sql.105).aspx

but, there possibility sql query string triggered error ?


Comments

Post a Comment

Popular posts from this blog

php - Embed BBCode within itself not working -

so working on simple php bbcode system, though doing [center][b][i]text[/i][/b][/center] doesn't parse. leaves couple out. curious if give me tip? or point me in direction learn how fix issue. sample of code: function bbcode($str) { $patterns = array(); $patterns = array( '#\[b\](.*?)\[/b\]#', '#\[i\](.*?)\[/i\]#', '#\[u\](.*?)\[/u\]#', '#\[color=(.*?)\](.*?)\[/color\]#', '#\[img\](.*?)\[/img\]#', '#\[center\](.*?)\[/center\]#', '#\n#' ); $replacements = array(); $replacements = array( '<strong>$1</strong>', '<em>$1</em>', '<u>$1</u>', '<span style="color:$1">$2</span>', '<img src="$1" style="max-width:45%;"></img>', '<center>$1</center>', '<br/>' ); return preg_replace($patterns, $re...
Read more

neo4j - finding mutual friends in a cypher statement starting with three or more persons -

Image
i trying build cypher statement neo4j know 2-n starting nodes name , need find node (if any) can reached of starting nodes. at first tought similar "mutual friend" situation handled (start1)-[*..2]->(main)<-[*..2]-(start2) in case have more 2 starting points around 6 know name. so puzzled how can include third, fourth , on node cypher able find commmon root amongst them. in above example neo4j website need path starting 'dilshad', 'becky' , 'cesar' check if have common friend (anders) excluding 'filipa' , 'emil' not friends of three. so far create statement programmatically looks like match (start1 {name:'person1'}), (start2 {name:'person2'}), (start3 {name: 'person3'}), (main) (start1)-[*..2]->(main) , (start2)-[*..2]->(main) , (start3)-[*..2]->(main) return distinct main but wondering if there more elegant / efficient way in cypher possibly use list of names parameter ...
Read more

php - How to remove letter in front of the word laravel -

Image
based on picture above result of var_dump() , dd() of same variable ,when var_dump() , apostrophe (') symbol in black diamond of question mark , when dd() same variable , apostrophe can seen letter 'b' appear in front of words what want can me result : loreal's sdn bhd and @ same time want remove special character ( excluding these 4 symbols (-) ,(_) ,('),(,) ) simply escape special character resolve issue. mysqli_real_escape_string resolve issue. $name = mysqli_real_escape_string($request()->user); or use addslashes function() $name = addslashes($request()->user);
Read more