Are you over 18 and want to see adult content?
More Annotations
A complete backup of https://geekprank.com/blank.php
Are you over 18 and want to see adult content?
A complete backup of https://kudaplay.tv/blog/tag/iptvsmarterspro/
Are you over 18 and want to see adult content?
A complete backup of https://turfgagnant1.blogspot.com/
Are you over 18 and want to see adult content?
A complete backup of https://ura99.com/dream9/
Are you over 18 and want to see adult content?
A complete backup of https://webslon.info/www/latistor.blogspot.gr
Are you over 18 and want to see adult content?
A complete backup of http://sattamatka.net.in/minakshi-day-jodi-chart.php
Are you over 18 and want to see adult content?
A complete backup of http://hrfog.com/
Are you over 18 and want to see adult content?
A complete backup of https://www.urajp.eu/category/urajp/page/1109/
Are you over 18 and want to see adult content?
A complete backup of https://isoroms.com/category/ps2/page/89/
Are you over 18 and want to see adult content?
A complete backup of https://www.burrisoptics.com/reticles/ballistic-ar
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of datingbuzz.co.za
Are you over 18 and want to see adult content?
A complete backup of putainei.blogspot.com
Are you over 18 and want to see adult content?
A complete backup of disciplesofflight.com
Are you over 18 and want to see adult content?
Text
PRIYANKARA
Now, based on the identified functional dependencies, see whether you can make determinants as candidate keys. If you take the first one, we can clearly say that Course + Subject is a candidate key.Second one that is Course + Lecturer is also a candidate key as we can identify tuples uniquely using it.However the determinant of the third one cannot be used as a candidate key because DINESH'S BLOG :::: BEING COMPILED ::::: TYPES OF SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO REPLACE Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: UNDERSTANDING SQL This is the main container that holds backup sets using backup devices. Generally we take a backup of the database without mentioning the name of Media Set, hence the device we used is attached to a media set that has no name. DINESH'S BLOG :::: BEING COMPILED ::::: RELATIONAL ALGEBRA Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVER BCP Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SSIS: REPLACING Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: REPORTING SERVICES Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED Azure Synapse Analytics - Part I. This video speaks about the latest in data warehousing and big data analytics: Azure Synapse Analytics. This is the first part of it and it explains; - The way we have been creating on-premise data solutions. - The way we have been creating data solutions in Azure before Azure Synapse Analytics. DINESH'S BLOG :::: BEING COMPILED ::::: DATABASEAUTHOR: DINESHPRIYANKARA
Now, based on the identified functional dependencies, see whether you can make determinants as candidate keys. If you take the first one, we can clearly say that Course + Subject is a candidate key.Second one that is Course + Lecturer is also a candidate key as we can identify tuples uniquely using it.However the determinant of the third one cannot be used as a candidate key because DINESH'S BLOG :::: BEING COMPILED ::::: TYPES OF SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO REPLACE Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: UNDERSTANDING SQL This is the main container that holds backup sets using backup devices. Generally we take a backup of the database without mentioning the name of Media Set, hence the device we used is attached to a media set that has no name. DINESH'S BLOG :::: BEING COMPILED ::::: RELATIONAL ALGEBRA Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVER BCP Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SSIS: REPLACING Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: REPORTING SERVICES Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: TYPES OF SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: UNDERSTANDING SQL This is the main container that holds backup sets using backup devices. Generally we take a backup of the database without mentioning the name of Media Set, hence the device we used is attached to a media set that has no name. DINESH'S BLOG :::: BEING COMPILED ::::: WHAT IS LRU (LAST The LRU, or Last Recent Used algorithm determines the data pages to be dropped from the cache when Data Cache section, which is the largest part of the Buffer Pool needs space.. Data Cache section is used for caching database data pages. In order to satisfy users’ requests, SQL Server loads data pages to this section and then fulfills the requirements such as SELECT, INSERT, UPDATE and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVER Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: WHAT ARE DBMANAGER Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO ADD A WATCH Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVER Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database is an OLTP database or a data warehouse based on dimensional modeling.Partitioning requires a Partition Function that describes boundary values and number of partitions required, and Partition Scheme that assigns File Groups to partitions. DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO CHECK Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: CANNOT LOGIN TO Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED Azure Synapse Analytics - Part I. This video speaks about the latest in data warehousing and big data analytics: Azure Synapse Analytics. This is the first part of it and it explains; - The way we have been creating on-premise data solutions. - The way we have been creating data solutions in Azure before Azure Synapse Analytics. DINESH'S BLOG :::: BEING COMPILED ::::: WHAT IS LRU (LASTAUTHOR:DINESH PRIYANKARA
The LRU, or Last Recent Used algorithm determines the data pages to be dropped from the cache when Data Cache section, which is the largest part of the Buffer Pool needs space.. Data Cache section is used for caching database data pages. In order to satisfy users’ requests, SQL Server loads data pages to this section and then fulfills the requirements such as SELECT, INSERT, UPDATE and DINESH'S BLOG :::: BEING COMPILED ::::: UNDERSTANDING SQL This is the main container that holds backup sets using backup devices. Generally we take a backup of the database without mentioning the name of Media Set, hence the device we used is attached to a media set that has no name. DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO REPLACEREPLACE BLANK WITH NULL SQLSQL REPLACE BLANK WITH TEXTSQL REPLACE PART OF STRINGSQLSERVER REPLACE NULL
Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: WHAT ARE DBMANAGER Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: RELATIONAL ALGEBRATHETA JOIN VS NATURAL JOINDIFFERENCE BETWEEN THETA JOIN AND NATURAL J…THETA JOIN EXAMPLETHETA JOIN IN DBMSTHETA JOIN SQLTHETA JOIN RELATIONALALGEBRA
Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: ANALYSIS SERVICES Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO FIND ALL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVERCHECK SQL SERVER STATUSSQL SERVER DATABASE STATUSAZURE SQL STATUSSUSPENDED STATUS SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED Azure Synapse Analytics - Part I. This video speaks about the latest in data warehousing and big data analytics: Azure Synapse Analytics. This is the first part of it and it explains; - The way we have been creating on-premise data solutions. - The way we have been creating data solutions in Azure before Azure Synapse Analytics. DINESH'S BLOG :::: BEING COMPILED ::::: WHAT IS LRU (LASTAUTHOR:DINESH PRIYANKARA
The LRU, or Last Recent Used algorithm determines the data pages to be dropped from the cache when Data Cache section, which is the largest part of the Buffer Pool needs space.. Data Cache section is used for caching database data pages. In order to satisfy users’ requests, SQL Server loads data pages to this section and then fulfills the requirements such as SELECT, INSERT, UPDATE and DINESH'S BLOG :::: BEING COMPILED ::::: UNDERSTANDING SQL This is the main container that holds backup sets using backup devices. Generally we take a backup of the database without mentioning the name of Media Set, hence the device we used is attached to a media set that has no name. DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO REPLACEREPLACE BLANK WITH NULL SQLSQL REPLACE BLANK WITH TEXTSQL REPLACE PART OF STRINGSQLSERVER REPLACE NULL
Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: WHAT ARE DBMANAGER Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: RELATIONAL ALGEBRATHETA JOIN VS NATURAL JOINDIFFERENCE BETWEEN THETA JOIN AND NATURAL J…THETA JOIN EXAMPLETHETA JOIN IN DBMSTHETA JOIN SQLTHETA JOIN RELATIONALALGEBRA
Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: ANALYSIS SERVICES Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO FIND ALL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVERCHECK SQL SERVER STATUSSQL SERVER DATABASE STATUSAZURE SQL STATUSSUSPENDED STATUS SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO FIND ALL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: POWER BI Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: DATABASE Now, based on the identified functional dependencies, see whether you can make determinants as candidate keys. If you take the first one, we can clearly say that Course + Subject is a candidate key.Second one that is Course + Lecturer is also a candidate key as we can identify tuples uniquely using it.However the determinant of the third one cannot be used as a candidate key because DINESH'S BLOG :::: BEING COMPILED ::::: TYPES OF SQL Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SQL SERVER Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: SSIS: REPLACING Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: HOW TO ADD A WATCH Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: TABLE VARIABLE Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: AZURE SQL DATA Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and DINESH'S BLOG :::: BEING COMPILED ::::: MICROSOFT ACCESS Dinesh Priyankara Colombo, Sri Lanka Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and dp.SyntaxHighlighter Version: {V} http://www.dreamprojections.com/syntaxhighlighter ©2004-2007 Alex Gorbatchev. ' }, ClipboardSwf : null, Version : '1.5.1' } }; // make an alias dp.SyntaxHighlighter = dp.sh; // // Toolbar functions // dp.sh.Toolbar.Commands = { ExpandSource: { label: '+ expand source', check: function(highlighter) { return highlighter.collapse; }, func: function(sender, highlighter) { sender.parentNode.removeChild(sender); highlighter.div.className = highlighter.div.className.replace('collapsed', ''); } }, // opens a new windows and puts the original unformatted source code inside. ViewSource: { label: 'view plain', func: function(sender, highlighter){ var code =
dp.sh.Utils.FixForBlogger(highlighter.originalCode).replace(/ m2.index) return 1; else { // if index is the same, sort by length if(m1.length < m2.length) return -1; else if(m1.length > m2.length) return 1; } return 0; } dp.sh.Highlighter.prototype.CreateElement = function(name) { var result = document.createElement(name); result.highlighter = this; return result; } // gets a list of all matches for a given regular expression dp.sh.Highlighter.prototype.GetMatches = function(regex, css) { var index = 0; var match = null; while((match = regex.exec(this.code)) != null) this.matches = new dp.sh.Match(match, match.index, css); } dp.sh.Highlighter.prototype.AddBit = function(str, css) { if(str == null || str.length == 0) return; var span = this.CreateElement('SPAN'); // str = str.replace(/&/g, '&'); str = str.replace(/ /g, 'Â '); str = str.replace(//g, '>'); str = str.replace(/\n/gm, ' '); // when adding a piece of code, check to see if it has line breaks in it // and if it does, wrap individual line breaks with span tags if(css != null) { if((/br/gi).test(str)) { var lines = str.split(' '); for(var i = 0; i < lines.length; i++) { span = this.CreateElement('SPAN'); span.className = css; span.innerHTML = lines; this.div.appendChild(span); // don't add a for the last line if(i + 1 < lines.length) this.div.appendChild(this.CreateElement('BR')); } } else { span.className = css; span.innerHTML = str; this.div.appendChild(span); } } else { span.innerHTML = str; this.div.appendChild(span); } } // checks if one match is inside any other match dp.sh.Highlighter.prototype.IsInside = function(match) { if(match == null || match.length == 0) return false; for(var i = 0; i < this.matches.length; i++) { var c = this.matches; if(c == null) continue; if((match.index > c.index) && (match.index < c.index + c.length)) return true; } return false; } dp.sh.Highlighter.prototype.ProcessRegexList = function() { for(var i = 0; i < this.regexList.length; i++) this.GetMatches(this.regexList.regex, this.regexList.css); } dp.sh.Highlighter.prototype.ProcessSmartTabs = function(code) { var lines = code.split('\n'); var result = ''; var tabSize = 4; var tab = '\t'; // This function inserts specified amount of spaces in the string // where a tab is while removing that given tab. function InsertSpaces(line, pos, count) { var left = line.substr(0, pos); var right = line.substr(pos + 1, line.length); // pos + 1 will get rid of the tab var spaces = ''; for(var i = 0; i < count; i++) spaces += ' '; return left + spaces + right; } // This function process one line for 'smart tabs' function ProcessLine(line, tabSize) { if(line.indexOf(tab) == -1) return line; var pos = 0; while((pos = line.indexOf(tab)) != -1) { // This is pretty much all there is to the 'smart tabs' logic. // Based on the position within the line and size of a tab, // calculate the amount of spaces we need to insert. var spaces = tabSize - pos % tabSize; line = InsertSpaces(line, pos, spaces); } return line; } // Go through all the lines and do the 'smart tabs' magic. for(var i = 0; i < lines.length; i++) result += ProcessLine(lines, tabSize) + '\n'; return result; } dp.sh.Highlighter.prototype.SwitchToList = function() { // thanks to Lachlan Donald from SitePoint.com for this tag fix. var html = this.div.innerHTML.replace(//gi, '\n'); var lines = html.split('\n'); if(this.addControls == true) this.bar.appendChild(dp.sh.Toolbar.Create(this)); // add columns ruler if(this.showColumns) { var div = this.CreateElement('div'); var columns = this.CreateElement('div'); var showEvery = 10; var i = 1; while(i 0; i++) { if(Trim(lines).length == 0) continue; var matches = regex.exec(lines); if(matches != null && matches.length > 0) min = Math.min(matches.length, min); } // trim minimum common number of white space from the begining of every line if(min > 0) for(var i = 0; i < lines.length; i++) lines = lines.substr(min); return lines.join('\n'); } // This function returns a portions of the string from pos1 to pos2 inclusive function Copy(string, pos1, pos2) { return string.substr(pos1, pos2 - pos1); } var pos = 0; if(code == null) code = ''; this.originalCode = code; this.code = Chop(Unindent(code)); this.div = this.CreateElement('DIV'); this.bar = this.CreateElement('DIV'); this.ol = this.CreateElement('OL'); this.matches = new Array(); this.div.className = 'dp-highlighter'; this.div.highlighter = this; this.bar.className = 'bar'; // set the first line this.ol.start = this.firstLine; if(this.CssClass != null) this.ol.className = this.CssClass; if(this.collapse) this.div.className += ' collapsed'; if(this.noGutter) this.div.className += ' nogutter'; // replace tabs with spaces if(this.tabsToSpaces == true) this.code = this.ProcessSmartTabs(this.code); this.ProcessRegexList(); // if no matches found, add entire code as plain text if(this.matches.length == 0) { this.AddBit(this.code, null); this.SwitchToList(); this.div.appendChild(this.bar); this.div.appendChild(this.ol); return; } // sort the matches this.matches = this.matches.sort(dp.sh.Highlighter.SortCallback); // The following loop checks to see if any of the matches are inside // of other matches. This process would get rid of highligted strings // inside comments, keywords inside strings and so on. for(var i = 0; i < this.matches.length; i++) if(this.IsInside(this.matches)) this.matches = null; // Finally, go through the final list of matches and pull the all // together adding everything in between that isn't a match. for(var i = 0; i < this.matches.length; i++) { var match = this.matches; if(match == null || match.length == 0) continue; this.AddBit(Copy(this.code, pos, match.index), null); this.AddBit(match.value, match.css); pos = match.index + match.length; } this.AddBit(this.code.substr(pos), null); this.SwitchToList(); this.div.appendChild(this.bar); this.div.appendChild(this.ol); } dp.sh.Highlighter.prototype.GetKeywords = function(str) { return '\\b' + str.replace(/ /g, '\\b|\\b') + '\\b'; } dp.sh.BloggerMode = function() { dp.sh.isBloggerMode = true; } // highlightes all elements identified by name and gets source code from specified property dp.sh.HighlightAll = function(name, showGutter /* optional */, showControls /* optional */, collapseAll /* optional */, firstLine /* optional */, showColumns /* optional */) { function FindValue() { var a = arguments; for(var i = 0; i < a.length; i++) { if(a == null) continue; if(typeof(a) == 'string' && a != '') return a + ''; if(typeof(a) == 'object' && a.value != '') return a.value + ''; } return null; } function IsOptionSet(value, list) { for(var i = 0; i < list.length; i++) if(list == value) return true; return false; } function GetOptionValue(name, list, defaultValue) { var regex = new RegExp('^' + name + '\\$', 'gi'); var matches = null; for(var i = 0; i < list.length; i++) if((matches = regex.exec(list)) != null) return matches; return defaultValue; } function FindTagsByName(list, name, tagName) { var tags = document.getElementsByTagName(tagName); for(var i = 0; i < tags.length; i++) if(tags.getAttribute('name') == name) list.push(tags); } var elements = ; var highlighter = null; var registered = {}; var propertyName = 'innerHTML'; // for some reason IEdoesn't find
by name, however it does see them just fine by tag name... FindTagsByName(elements, name, 'pre'); FindTagsByName(elements, name, 'textarea'); if(elements.length == 0)return;
// register all brushes for(var brush in dp.sh.Brushes){
var aliases = dp.sh.Brushes.Aliases; if(aliases == null)continue;
for(var i = 0; iDetails
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0