Assuming also is required, the following 136 results were found.
-
of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep!...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the above has been addressed or we've tried casting as varchars all over the place, check the value that gets outputted is also a literal string. So here's some ok code but it will fail if my reference data has a non-numeric value in it: -- Initial...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein matched the TNSNAMES.ORA file located in "C:\ORACLE\product\11.2.0\client_1\network\admin"....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's calendar, so you actually have to adjust this twice a year....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web Statistics (awstats) but this was so that you could have your own country lookup script. The Download...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to be finalised (this is content that will exist on project closure) Instructions for modifying content (textual mostly but also image uploads) Create custom documentation for front-end use Create custom documentation for back-end (admin panel) use....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
potential customer to self-select the services they wish to subscribe to, and how any information they provide may be used. Also referred to as permission-based marketing. Section 508 Section 508 is an amendment to the United States Workforce...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
receives/returns) Anything to add? I welcome any suggestions/improvements to the above. Just add a comment to this page. Also if you want to share your nightmare project takeovers, they're always fun to hear about.
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
in a partner institution: "By the way my printer has stopped working, in fact it hasn't been working for ages, could you also look at that". "Is there a power light on when you switch it on?". "Yes it's definitely plugged in if that's what you're...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
horizontal scrollbar which is a bit annoying because you scroll to the right and theres nothing but some background image. Also the footer was at 100% so it got cut off if you scrolled horizontally. Aim / Objective To have a background of sky and grass...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS: body { background:red; } iframe { position: fixed;...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and compatible with smartphones.(Like Flash back in the days of Macromedia Flash :c) and works with apple...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla! displayed...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
$display_excerpt=search_highlight($result_Content, $terms_rx)."..."; I like to include a "Did-you-mean" section which I also use for any AJAX suggestion feature (be flexible with us as some customers have asked how does it get that word and why is it...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB