var hljs=new function(){var i=["sql"];var o=(i.join(",")+","+["python","ruby","perl","php","css","xml","html","django","javascript","java","cpp","1c","axapta","delphi","rib","rsl","vbscript","profile","dos","bash"].join(",")).split(",");var k={xml:"www",html:"www",css:"www",django:"www",python:"dynamic",perl:"dynamic",php:"dynamic",ruby:"dynamic",cpp:"static",java:"static",delphi:"static",rib:"renderman",rsl:"renderman"};var l={};var b={};function m(q){return q.replace(/&/gm,"&amp;").replace(/</gm,"&lt;").replace(/>/gm,"&gt;")}function e(s,r){if(!s){return false}for(var q in s){if(s[q]==r){return true}}return false}function c(C,E){function D(O,P){O.sub_modes=[];for(var N in O.contains){for(var M in P.modes){if(P.modes[M].className==O.contains[N]){O.sub_modes[O.sub_modes.length]=P.modes[M]}}}}function s(M,O){if(!O.contains){return null}if(!O.sub_modes){D(O,F)}for(var N=0;N<O.sub_modes.length;N++){if(O.sub_modes[N].beginRe.test(M)){return O.sub_modes[N]}}return null}function x(N,M){if(q[N].end&&q[N].endRe.test(M)){return 1}if(q[N].endsWithParent){var O=x(N-1,M);return O?O+1:0}return 0}function y(M,N){return N.illegalRe&&N.illegalRe.test(M)}function L(S,T){var N=[];function R(U){if(!e(N,U)){N[N.length]=U}}if(S.contains){for(var Q in T.modes){if(e(S.contains,T.modes[Q].className)){R(T.modes[Q].begin)}}}var O=q.length-1;do{if(q[O].end){R(q[O].end)}O--}while(q[O+1].endsWithParent);if(S.illegal){R(S.illegal)}var M="("+N[0];for(var P=0;P<N.length;P++){M+="|"+N[P]}M+=")";return g(T,M)}function r(O,N){var P=q[q.length-1];if(!P.terminators){P.terminators=L(P,F)}O=O.substr(N);var M=P.terminators.exec(O);if(!M){return[O,"",true]}if(M.index==0){return["",M[0],false]}else{return[O.substr(0,M.index),M[0],false]}}function B(Q,M){var O=F.case_insensitive?M[0].toLowerCase():M[0];for(var N in Q.keywordGroups){var P=Q.keywordGroups[N].hasOwnProperty(O);if(P){return[N,P]}}return false}function G(N,S){if(!S.keywords||!S.lexems){return m(N)}if(!S.lexemsRe){var R="("+S.lexems[0];for(var P=1;P<S.lexems.length;P++){R+="|"+S.lexems[P]}R+=")";S.lexemsRe=g(F,R,true)}var M="";var Q=0;S.lexemsRe.lastIndex=0;var O=S.lexemsRe.exec(N);while(O){M+=m(N.substr(Q,O.index-Q));keyword_match=B(S,O);if(keyword_match){z+=keyword_match[1];M+='<span class="'+keyword_match[0]+'">'+m(O[0])+"</span>"}else{M+=m(O[0])}Q=S.lexemsRe.lastIndex;O=S.lexemsRe.exec(N)}M+=m(N.substr(Q,N.length-Q));return M}function K(N,O){if(O.subLanguage&&b[O.subLanguage]){var M=c(O.subLanguage,N);z+=M.keyword_count;v+=M.relevance;return M.value}else{return G(N,O)}}function J(N,M){if(N.returnBegin){A+='<span class="'+N.className+'">';N.buffer=""}else{if(N.excludeBegin){A+=m(M)+'<span class="'+N.className+'">';N.buffer=""}else{A+='<span class="'+N.className+'">';N.buffer=M}}q[q.length]=N}function H(P,O,N){var S=q[q.length-1];if(N){A+=K(S.buffer+P,S);return false}var Q=s(O,S);if(Q){A+=K(S.buffer+P,S);J(Q,O);v+=Q.relevance;return Q.returnBegin}var M=x(q.length-1,O);if(M){if(S.returnEnd){A+=K(S.buffer+P,S)+"</span>"}else{if(S.excludeEnd){A+=K(S.buffer+P,S)+"</span>"+m(O)}else{A+=K(S.buffer+P+O,S)+"</span>"}}while(M>1){A+="</span>";M--;q.length--}q.length--;q[q.length-1].buffer="";if(S.starts){for(var R=0;R<F.modes.length;R++){if(F.modes[R].className==S.starts){J(F.modes[R],"");break}}}return S.returnEnd}if(y(O,S)){throw"Illegal"}}var F=l[C];var q=[F.defaultMode];var v=0;var z=0;var A="";try{var w=0;F.defaultMode.buffer="";do{var t=r(E,w);var u=H(t[0],t[1],t[2]);w+=t[0].length;if(!u){w+=t[1].length}}while(!t[2]);if(q.length>1){throw"Illegal"}return{relevance:v,keyword_count:z,value:A}}catch(I){if(I=="Illegal"){return{relevance:0,keyword_count:0,value:m(E)}}else{throw I}}}function h(s){var q="";for(var r=0;r<s.childNodes.length;r++){if(s.childNodes[r].nodeType==3){q+=s.childNodes[r].nodeValue}else{if(s.childNodes[r].nodeName=="BR"){q+="\n"}else{throw"No highlight"}}}return q}function a(s){var r=s.className.split(/\s+/);for(var q=0;q<r.length;q++){if(r[q]=="no-highlight"){throw"No highlight"}if(l[r[q]]){return r[q]}}}function n(t){try{var A=h(t);var w=a(t)}catch(x){if(x=="No highlight"){return}}if(w){var C=c(w,A).value}else{var B=2;var v=0;for(var z in b){var q=c(z,A);v=q.keyword_count+q.relevance;if(v>B){B=v;var C=q.value;w=z}}}if(C){var y=t.className;if(!y.match(w)){y+=" "+w}var s=document.createElement("div");s.innerHTML='<pre class="'+y+'">'+C+"</pre>";var u=t.parentNode;u.replaceChild(s.firstChild,t)}}function g(t,r,q){var s="m"+(t.case_insensitive?"i":"")+(q?"g":"");return new RegExp(r,s)}function j(){for(var r in l){var s=l[r];for(var q in s.modes){if(s.modes[q].begin){s.modes[q].beginRe=g(s,"^"+s.modes[q].begin)}if(s.modes[q].end){s.modes[q].endRe=g(s,"^"+s.modes[q].end)}if(s.modes[q].illegal){s.modes[q].illegalRe=g(s,"^(?:"+s.modes[q].illegal+")")}s.defaultMode.illegalRe=g(s,"^(?:"+s.defaultMode.illegal+")");if(s.modes[q].relevance==undefined){s.modes[q].relevance=1}}}}function f(){function q(v){if(!v.keywordGroups){for(var u in v.keywords){if(v.keywords[u] instanceof Object){v.keywordGroups=v.keywords}else{v.keywordGroups={keyword:v.keywords}}break}}}for(var s in l){var t=l[s];q(t.defaultMode);for(var r in t.modes){q(t.modes[r])}}}function p(){if(p.called){return}p.called=true;j();f();if(arguments.length){for(var q=0;q<arguments.length;q++){if(l[arguments[q]]){b[arguments[q]]=l[arguments[q]]}}}else{b=l}var r=document.getElementsByTagName("pre");for(var q=0;q<r.length;q++){n(r[q])}}function d(){var q=arguments;languages=i;p.apply(null,q)}this.LANGUAGES=l;this.ALL_LANGUAGES=o;this.initHighlightingOnDnnReady=d;this.highlightBlock=n;this.IDENT_RE="[a-zA-Z][a-zA-Z0-9_]*";this.UNDERSCORE_IDENT_RE="[a-zA-Z_][a-zA-Z0-9_]*";this.NUMBER_RE="\\b\\d+(\\.\\d+)?";this.C_NUMBER_RE="\\b(0x[A-Za-z0-9]+|\\d+(\\.\\d+)?)";this.APOS_STRING_MODE={className:"string",begin:"'",end:"'",illegal:"\\n",contains:["escape"],relevance:0};this.QUOTE_STRING_MODE={className:"string",begin:'"',end:'"',illegal:"\\n",contains:["escape"],relevance:0};this.BACKSLASH_ESCAPE={className:"escape",begin:"\\\\.",end:"^",relevance:0};this.C_LINE_COMMENT_MODE={className:"comment",begin:"//",end:"$",relevance:0};this.C_BLOCK_COMMENT_MODE={className:"comment",begin:"/\\*",end:"\\*/"};this.HASH_COMMENT_MODE={className:"comment",begin:"#",end:"$"};this.C_NUMBER_MODE={className:"number",begin:this.C_NUMBER_RE,end:"^",relevance:0}}();var initHighlightingOnLoad=hljs.initHighlightingOnLoad;hljs.SQL_KEYWORDS={add:1,all:1,alter:1,and:1,any:1,as:1,asc:1,authorization:1,backup:1,begin:1,between:1,"break":1,browse:1,bulk:1,by:1,cascade:1,"case":1,check:1,checkpoint:1,close:1,clustered:1,collate:1,column:1,commit:1,compute:1,constraint:1,contains:1,"continue":1,create:1,cross:1,current:1,current_date:1,current_time:1,cursor:1,database:1,dbcc:1,deallocate:1,declare:1,"default":1,"delete":1,deny:1,desc:1,disk:1,distinct:1,distributed:1,"double":1,drop:1,dump:1,"else":1,end:1,errlvl:1,escape:1,except:1,exec:1,execute:1,exists:1,exit:1,external:1,fetch:1,file:1,fillfactor:1,"for":1,foreign:1,freetext:1,from:1,full:1,"function":1,"goto":1,grant:1,group:1,having:1,holdlock:1,identity:1,identity_insert:1,identitycol:1,"if":1,"in":1,index:1,inner:1,insert:1,intersect:1,into:1,is:1,join:1,key:1,kill:1,left:1,like:1,lineno:1,load:1,national:1,nocheck:1,nonclustered:1,not:1,of:1,off:1,offsets:1,on:1,open:1,option:1,or:1,order:1,outer:1,over:1,percent:1,pivot:1,plan:1,precision:1,primary:1,print:1,proc:1,procedure:1,"public":1,raiserror:1,read:1,readtext:1,reconfigure:1,references:1,replication:1,restore:1,restrict:1,"return":1,revert:1,revoke:1,right:1,rollback:1,rowcount:1,rowguidcol:1,rule:1,save:1,schema:1,securityaudit:1,select:1,set:1,setuser:1,shutdown:1,some:1,statistics:1,table:1,tablesample:1,textsize:1,then:1,to:1,top:1,tran:1,transaction:1,trigger:1,truncate:1,tsequal:1,union:1,unique:1,unpivot:1,update:1,updatetext:1,use:1,user:1,values:1,varying:1,view:1,waitfor:1,when:1,where:1,"while":1,"with":1,writetext:1};hljs.SQL_DATATYPES={bigint:1,binary:1,bit:1,"char":1,cursor:1,datetime:1,decimal:1,"float":1,image:1,"int":1,money:1,nchar:1,ntext:1,numeric:1,nvarchar:1,real:1,smalldatetime:1,smallint:1,smallmoney:1,sql_variant:1,table:1,text:1,timestamp:1,tinyint:1,uniqueidentifier:1,varbinary:1,varchar:1,xml:1};hljs.SQL_FUNCTIONS={abs:1,acos:1,app_name:1,ascii:1,asin:1,assemblyproperty:1,atan:1,atn2:1,avg:1,cast:1,ceiling:1,"char":1,charindex:1,checksum_agg:1,coalesce:1,col_length:1,col_name:1,collationproperty:1,columnproperty:1,columns_updated:1,containstable:1,convert:1,cos:1,cot:1,count:1,count_big:1,current_timestamp:1,current_user:1,cursor_status:1,databaseproperty:1,databasepropertyex:1,datalength:1,dateadd:1,datediff:1,datename:1,datepart:1,day:1,db_id:1,db_name:1,degrees:1,dense_rank:1,difference:1,error_line:1,error_message:1,error_number:1,error_procedure:1,error_severity:1,error_state:1,exp:1,file_id:1,file_idex:1,file_name:1,filegroup_id:1,filegroup_name:1,filegroupproperty:1,fileproperty:1,floor:1,formatmessage:1,freetexttable:1,fulltextcatalogproperty:1,fulltextserviceproperty:1,getansinull:1,getdate:1,getutcdate:1,grouping:1,host_id:1,host_name:1,ident_current:1,ident_incr:1,ident_seed:1,identity:1,index_col:1,indexkey_property:1,indexproperty:1,is_member:1,is_srvrolemember:1,isdate:1,isnull:1,isnumeric:1,left:1,len:1,log:1,log10:1,lower:1,ltrim:1,max:1,min:1,month:1,nchar:1,newid:1,ntile:1,nullif:1,object_id:1,object_name:1,objectproperty:1,objectpropertyex:1,opendatasource:1,openquery:1,openrowset:1,openxml:1,original_login:1,parsename:1,patindex:1,permissions:1,pi:1,power:1,quotename:1,radians:1,rand:1,rank:1,replace:1,replicate:1,reverse:1,right:1,round:1,row_number:1,rowcount_big:1,rtrim:1,schema_id:1,schema_name:1,scope_identity:1,serverproperty:1,session_user:1,sessionproperty:1,sign:1,sin:1,soundex:1,space:1,sql_variant_property:1,sqrt:1,square:1,stats_date:1,stdev:1,stdevp:1,str:1,stuff:1,substring:1,sum:1,suser_id:1,suser_name:1,suser_sid:1,suser_sname:1,system_user:1,tan:1,type_id:1,type_name:1,typeproperty:1,unicode:1,upper:1,user_id:1,user_name:1,"var":1,varp:1,xact_state:1,year:1};hljs.LANGUAGES.sql={case_insensitive:true,defaultMode:{lexems:[hljs.IDENT_RE],contains:["string","number","comment","atatfunction","variable"],keywords:{keyword:hljs.SQL_KEYWORDS,datatype:hljs.SQL_DATATYPES,"function":hljs.SQL_FUNCTIONS,literal:{"true":1,"false":1,"null":1}}},modes:[hljs.C_NUMBER_MODE,hljs.C_BLOCK_COMMENT_MODE,{className:"atatfunction",begin:"@@[@$#_\\w]{1,128}",end:"^"},{className:"variable",begin:"@[@$#_\\w]{1,128}",end:"^"},{className:"comment",begin:"--",end:"$"},{className:"string",begin:"'",end:"'",contains:["escape","squote"],relevance:0},{className:"squote",begin:"''",end:"^"},{className:"string",begin:"`",end:"`",contains:["escape"]},hljs.BACKSLASH_ESCAPE]};