PatrickDinh

For our reporting services, we need to convert a lot SQL tables to HTML. This is the SP that can convert any table to HTML based on a SP created by Ian Atkin ([email protected]) The original post can be found here

The modified version supports converting tables having NULL cells & better styling

create PROCEDURE [dbo].[SqlTableToHtml] (
@TABLENAME  NVARCHAR(500),
@OUTPUT   NVARCHAR(MAX) OUTPUT,
@TBL_STYLE NVARCHAR(1024) = '',
@TD_STYLE NVARCHAR(1024) = '',

thirukkural2022

Default File Manager in Ubuntu is nautilus

To open the current directory in File Manager:
nautilus . 

To open current user documents folder:
nautilus ~/Documents


Alternative File Manager : thunar

boyron

$("#tblId tr").each(function(i, obj) {
  if($(obj).attr('id') =='idBreakHere' ){
    return false; //this is equivalent of 'break' for jQuery loop
  }
}


$("#tblId tr").each(function(i, obj) {
  if($(obj).attr('id') =='idToFind' ){
    return; //this is equivalent of 'continue' for jQuery loop

maxbeatty

<label for="addressCountry">Country</label>
                    <select name="addressCountry">
                        <option></option>
                        <optgroup label="North America">
                            <option value="US">United States</option>
                            <option value="UM">United States Minor Outlying Islands</option>
                            <option value="CA">Canada</option>
                            <option value="MX">Mexico</option>
                            <option value="AI">Anguilla</option>
                            <option value="AG">Antigua and Barbuda</option>