THE WHATIS.COM WORD-OF-THE-DAY September 17, 2003 (Launched on this date in 1996, today whatis.com is exactly 7 years old!)
dynamic SQL ________________ SPONSORED BY: Microsoft The Quick Guide to Windows Server 2003. Get the latest information on installation, new features and training. Click here! http://WhatIs.com/r/0,,18393,00.htm?microsoft ________________ TODAY'S WORD: dynamic SQL See our complete definition with hyperlinks at http://searchoracle.techtarget.com/sDefinition/0,,sid41_gci927933,00.html Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements. This can be helpful when it is necessary to write code that can adjust to varying databases, conditions, or servers. It also makes it easier to automate tasks that are repeated many times. Dynamic SQL statements are stored as strings of characters that are entered when the program runs. They can be entered by the programmer or generated by the program itself, but unlike static SQL statements, they are not embedded in the source program. Also in contrast to static SQL statements, dynamic SQL statements can change from one execution to the next. Dynamic SQL statements can be written by people with comparatively little programming experience, because the program does most of the actual generation of the code. A potential problem is reduced performance (increased processing time) if there is too much dynamic SQL running at any given time. _________________________ RELATED TERMS: Structured Query Language http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci214230,00.html _____________________ SELECTED LINKS: Oracle has published a tutorial called "Using Dynamic SQL." http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58233/dynsql.htm Erland Sommerskog discusses "The Curse and Blessings of Dynamic SQL." http://www.algonet.se/~sommar/dynamic_sql.html SearchDataBase.com provides links to more information about SQL and dynamic SQL. http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281606,00.html ______________________ TODAY'S TECH NEWS: SECURITY FEARS STILL DOMINATE WLAN SPACE According to experts at the TechXNY conference, wireless LAN security fears are still hindering the rate of corporate deployments, even though the industry has made significant security strides as of late. http://searchnetworking.techtarget.com/originalContent/0,289142,sid7_gci928093,00.html LICENSING 6.0 AND SOFTWARE ASSURANCE: WHO SHOULD RENEW? It's decision time for many companies wondering whether to renew their volume-licensing agreements with Microsoft. http://searchwin2000.techtarget.com/originalContent/0,289142,sid1_gci927989,00.html DATA CENTERS TO HIKE ISERIES SKILL REQUIREMENTS As an iSeries pro you're going to have to learn new tools and languages, including Java and WebSphere. You might want to get some business planning experience under your belt, too. http://search400.techtarget.com/originalContent/0,289142,sid3_gci927915,00.html >> Catch up on all the latest IT news at http://searchtechtarget.techtarget.com/ _____________________ Quiz #42 | Shopping on the Internet If you've ever shopped at Amazon.com, bid on an auction at eBay, or done some B2B purchasing online, we invite you to take our latest quiz. Find out how much you really know about the language of e-business! >> Click to take the quiz http://whatis.techtarget.com/definition/0,,sid9_gci926124,00.html ______________________ Secret Word-of-the-Day | What is IT? Essentially etiquette for artificial intelligence, these three rules were developed to guide the behavior of robots and smart machines. Hint: They were originally published in the 1940s, in a story by a popular science fiction writer. >> See if you're right! http://searchcio.techtarget.com/gDefinition/0,294236,sid19_gci520366,00.html ______________________________ RECENT ADDITIONS AND UPDATES [1] Monte Carlo method http://whatis.techtarget.com/definition/0,,sid9_gci922393,00.html [2] virtual organization http://whatis.techtarget.com/definition/0,,sid9_gci213301,00.html [3] watchdog timer http://searchmobilecomputing.techtarget.com/sDefinition/0,,sid40_gci781540,00.html [4] DIME http://searchwebservices.techtarget.com/sDefinition/0,,sid26_gci921975,00.html [5] metropolitan area network http://searchnetworking.techtarget.com/sDefinition/0,,sid7_gci214083,00.html ____________________________________________________________________ ::::::::::::::::::: WHATIS.COM CONTACTS ::::::::::::::::::: LOWELL THING, Site Editor ([EMAIL PROTECTED]) MARGARET ROUSE, Associate Editor ([EMAIL PROTECTED]) IVY WIGMORE, Assistant Editor ([EMAIL PROTECTED]) ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com Copyright 2003 TechTarget. All rights reserved. ____________________________________________________________________ To unsubscribe from "Word of the Day": Reply to this e-mail with REMOVE in the Subject line - OR - Go to unsubscribe: http://WhatIs.com/u?cid=468575 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed.
