BUDAPEST, HUNGARY, January 27, 2011 (Press-News.org) Devart announced a new extended version of dbForge SQL Complete, a powerful SQL Server Management Studio add-in that introduces extended SQL code autocomplete and formatting for fastest writing SQL statements.
dbForge SQL Complete 2.0 will bring SQL Server database developers and DBAs around the world new speed in writing SQL statements to increase efficiency and code quality.
dbForge SQL Complete 2.0 Technical Advancements
Close collaboration with SQL Server database developers and DBAs resulted in the following new features:
- Working with large scripts
dbForge SQL Complete 2.0 provides sql code completion and formatting in scripts of any size. The first version supported the script size up to 150 000 symbols.
- Expanding a list of columns
Users can replace the * asterisk symbol with the list of columns from the required table or view on pressing the Tab key.
- Suggesting methods for columns and variables
dbForge SQL Complete suggests methods for columns and variables of varchar(max), nvarchar(max), varbinary(max), and xml data types.
- Extended support for statements
dbForge SQL Complete fully supports such statements as CREATE (for table, view, procedure, and function), EXEC, PRINT, and TRUNCATE TABLE. When TRUNCATE TABLE statement is used in a query, the tool suggests a list of databases, schemas, and tables.
- Suggesting conditions for JOIN statements
dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
- Automatic alias generation
The tool can generate an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of SQL document automatically.
- Inserting column names with prefixes
dbForge SQL Complete can insert column names with the name of table, schema, and database it belongs to.
- Sorting keywords by relevance
Keywords are sorted by relevance in the suggestion list.
- Expanded support for Transact-SQL statements
SQL Complete supports: DECLARE statements for local variables, cursor variables, and table definitions; cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements; context for such control-of-flow and T-SQL statements as BEGIN...END, GOTO, IF...ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY...CATCH, CASE, RAISERROR.
- Suggesting collations, data types, XML schema collections, and languages
dbForge SQL Complete can suggest collations, XML schema collections, languages and data types when writing SQL statements. For example, when creating columns in a table, dbForge SQL Complete will suggest possible data types for it, including user-defined types.
Pricing and Availability
dbForge SQL Complete now comes in two editions to better cater for the needs of SQL database developers and DBAs.
They can select a free Express edition to get free intellisense, or the Standard edition, which is available for a price of $49.95, to have surpassing sql code completion and formatting.
DbForge SQL Complete Express and free trial version of standard edition of dbForge SQL Complete are available for immediate download at http://www.devart.com/dbforge/sql/sqlcomplete/download.html
Users are welcome to write any comments and suggestions about dbForge SQL Complete on its support page — http://www.devart.com/dbforge/sql/sqlcomplete/support.html
About Devart
Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.
We specialize in providing comprehensive development and management tools as well as native connectivity solutions for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.
For additional information about Devart, visit http://www.devart.com/company/
New SQL Complete Brings Excellent Intellisense for SQL Server Management Studio
Extended version comes with rich autocomplete features, and keeps free intellisense for all SQL Server people.
2011-01-27
ELSE PRESS RELEASES FROM THIS DATE:
An Austin Apartments Locator Expands to San Marcos
2011-01-27
Habitat Hunters, an Austin apartments locator with complete real estate services since 1972 announces its expansion in San Marcos, Texas. With an office located at 109 E Hopkins, Suite 200c, now the same level of service and access from one of Austin's most established real estate companies is available to those who live and work in San Marcos, Texas.
"Central Texas is growing even in this economy, coupled with an existing strong university student population along with our experienced group of Realtors , Habitat Hunters has the ability help those who live and work in ...
NeuroSearch Sweden AB: Next Steps to Treat Parkinson's, Huntington's and Alzheimer's Disease.
2011-01-27
He discussed compound ACR16 or pridopidine, which is a generic name, that was developed in Carlsson Research about ten years ago. It belongs to a new class of compounds called dopidines which are developed from an in vivo screening method.
Carlsson Research started with the hypothesis that there is no target but rather you have to change the way the brain works, the system, the connectivity of the various brain areas associated with Huntingdon's disease.
''What we've found out is these compounds that can modulate dopamine transmission but also strengthen glutamartology ...
Key Helping to Get People & Businesses Fit for 2011
2011-01-27
January is always a time when we like to get our businesses, and our bodies, in shape for the coming year, and industrial supplies company Key are helping their customers to do both, with their 'Get in Shape for 2011' initiative.
The company wanted to encourage new and existing customers to think about their supplies needs for the coming year, as well as rewarding the individual buyers from these companies with gifts which would help them look after themselves.
So to help turn their customers' bodies into one less thing to worry about, Key have put together an incentives ...
Chiorino UK Automates Invoice Processing with PSI:Capture and DocuWare
2011-01-27
Datafinity and Document Dynamix announced today that Chiorino UK Ltd is achieving significant cost savings since deploying a new document management system to handle all accounting and HR documents. The system, which was installed at the end of last year and comprises of PSIGEN PSI:Capture software and DocuWare document management software, has reduced the amount of manual data entry required and improved access to documents across the company.
Datafinity, UK distributor of PSI:Capture, formed a partnership with Document Dynamix in 2010 to offer advanced document management ...
Cosworth Group Diversification Recognised by MIA Award
2011-01-27
British engineering specialist Cosworth Group has been named as the winner of the New Markets Award by the Motorsport Industry Association at its annual event to showcase business excellence.
Cosworth Group Chief Executive, Tim Routsis said the business was recognised for its diversification programme which has seen Cosworth Group apply their motorsport technology and engineering skills in other sectors including aerospace, defence and marine.
"To be acknowledged by the Motorsport Industry Association for our work in other sectors is a privilege for the Cosworth Group. ...
Equity market gains short lived ahead of UK GDP number - Spread Betting and CFD Trading
2011-01-27
Spread betting expert Sean Power of City Index (http://www.cityindex.co.uk/) takes a look at market activity on 25th January, including a positive start to the day for Europe's equity markets.
"Equity markets across Europe started the day in positive mood following a strong US session yesterday evening and better than expected results from Siemens this morning. However, gains were eroded shortly after the opening bell as commodity prices weighed heavily on the UK mining index.
Yesterdays US session saw intraday highs of 11,982 for the Dow and 1291 for the S&P, ...
Melbourne Cruise Deals Entice January and March Travelers Claim Expert Cruise Planners
2011-01-27
Cruise ship companies make about 35 % of the annual sales through the months of January to March. This booking period is traditionally considered the busiest for the cruise industry. It's also the time of the year when cruise liners compete with each other to grab the cruise traveler's attention with hard to resist cruise deals that may include irresistible perks. Cruise travel enthusiasts are sure to gain a lot from these appealing offers, provided they keep their eyes and ears wide open to deals announced in newspapers, email alerts, and newsletters.
Cruise travel ...
Attractive Hampton Road Cruise Vacations in 2011 For Cruise Travel Enthusiasts
2011-01-27
The travel industry, especially the cruise travel industry, is experiencing a revival from the recession days of 2009. Though unemployment rates haven't changed much, the overall atmosphere is much more positive than it was in 2009. In fact, the U.S Travel Association which represents airlines, cruise ships, rental cars, and hotels predicts that cruise vacations ( http://williamsburg.cruiseholidays.com/ ) are likely to rule the roost in 2011.* With major promotions like 'Sarah Palin's Alaska' (the TLC program where Sarah Palin discusses life in Alaska) and events like the ...
Crystal Pharmatech to Provide Solid State Characterization Training to Chinese Pharma Customers
2011-01-27
Crystal Pharmatech Co., Ltd has reached an agreement with Siber Hegner China (A Division of Siber Hegner Ltd.) to provide in-depth solid state characterization training to their large base of Chinese Pharmaceutical Customers.
Siber Hegner China is the exclusive distribution vendor for many solid state characterization instruments including particle size analyzers, density meters, polarimeter, contact-angle measurement devices, BET, in addition to many other professional analytical Instruments.
"The Chinese government is investing heavily in the pharmaceutical industry ...
New Rubber Seals for Demanding Valve Applications at Valve World 2010
2011-01-27
Precision Polymer Engineering (PPE), a unit of IDEX Corp. is driving up valve performance in demanding oil and gas, and chemical applications with the announcement of two new perfluoroelastomer sealing materials at Valve World 2010.
Perlast G75TX is the ultimate 'next generation' perfluoroelastomer, offering excellent chemical resistance and ultra-high temperature stability, simultaneously extending the elastomer's operating limits in all aspects. Resistance to temperatures up to +327OC (+621OF), G75TX has a compression set of just 8%, significantly increasing the efficiency ...
LAST 30 PRESS RELEASES:
Mayo Clinic study reveals hidden causes of heart attacks in younger adults, especially women
Target: BP initiative helps more than 10M adults with hypertension
New initiative launched to improve care for people with certain types of heart failure
You’ve never seen corn like this before
Mediterranean diet could reduce gum disease
Mount Sinai launches cardiac catheterization artificial intelligence research lab
Why AI is never going to run the world
Stress in the strands: Hair offers clues to children’s mental health
UCLA distinguished professor, CVD researcher to receive 2025 Basic Research Prize
UT San Antonio School of Public Health: The People’s School
‘Preventable deaths will continue’ without action to make NHS more accessible for autistic people, say experts
Scientists shoot lasers into brain cells to uncover how illusions work
Your ecosystem engineer was a dinosaur
New digital cognitive test for diagnosing Alzheimer's disease
Parents of children with health conditions less confident about a positive school year
New guideline standardizes consent for research participants in Canada
Research as reconciliation: Oil sands and health
AI risks overwriting history and the skills of historians have never been more important, leading academic outlines in new paper
The Lancet Diabetes & Endocrinology: Higher doses of semaglutide can safely enhance weight loss and improve health for adults living with obesity, two new clinical trials confirm
Trauma focused therapy shows promise for children struggling with PTSD
School meals could drive economic growth and food system transformation
Home training for cerebellar ataxias
Dry eyes affect over half the general population, yet only a fifth receive diagnosis and treatment
Researchers sound warning about women with type 2 diabetes taking oral HRT
Overweight and obesity don’t always increase the risk of an early death, Danish study finds
Cannabis use associated with a quadrupling of risk of developing type 2 diabetes, finds study of over 4 million adults
Gestational diabetes linked to cognitive decline in mothers and increased risk of developmental delays, ADHD and autism among children
Could we use eye drops instead of reading glasses as we age?
Patients who had cataracts removed or their eyesight corrected with a new type of lens have good vision over all distances without spectacles
AI can spot which patients need treatment to prevent vision loss in young adults
[Press-News.org] New SQL Complete Brings Excellent Intellisense for SQL Server Management StudioExtended version comes with rich autocomplete features, and keeps free intellisense for all SQL Server people.