1 / 8

SQL Server “Denali” CTP3 Le novità del comando EXECUTE

User Group Italiano SQL Server. Sergio Govoni. segovoni@gmail.com. SQL Server “Denali” CTP3 Le novità del comando EXECUTE. Speaker. 10+ years on ERP software developer 6+ years on SQL Server MCP, MCTS SQL Server Microsoft SQL Server MVP Speaker, Editor and Publisher @ UGISS

briar-richardson
Download Presentation

SQL Server “Denali” CTP3 Le novità del comando EXECUTE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. User Group Italiano SQL Server Sergio Govoni segovoni@gmail.com SQL Server “Denali” CTP3 Le novità del comando EXECUTE

  2. Speaker 10+ years on ERP software developer 6+ years on SQL Server • MCP, MCTS SQL Server • Microsoft SQL Server MVP Speaker, Editor and Publisher @ UGISS • User Group: www.ugiss.org • Blog: http://community.ugiss.org/blogs/sgovoni Co-Author • MVP Deep Dives Volume 2 Sergio Govoni UGISS - User Group Italiano SQL Server

  3. Agenda • MetadataDiscovery • 2 Stored procedure • 2 DMF • EXECUTE • WITH RESULT SETS UGISS - User Group Italiano SQL Server

  4. New EXECUTE syntax EXECUTE< proc | clr proc | remote proc | function > [WITH <execute_option>[,...n ]] { RESULT SETS { UNDEFINED| NONE | (<result_sets_definition>) } }  <result_sets_definition> ::= { <result_set_definition> | AS OBJECT [<object_location>.]{ table_name | view_name | tvf } | AS TYPE [schema_name.]table_type_name | AS FOR XML | (…) [,...n ] } UGISS - User Group Italiano SQL Server

  5. RESULT SETS definition • Garantisce metadati specifici per i result set restituiti da una SP o da un batch T-SQL • Richiesta corrispondenza nel numero delle colonne • Conversioni di tipo • Errore: resultsets non compatibili • Opzioni supportate • RESULT SETS UNDEFINED (default) • RESULT SETS NONE • RESULT SETS (…) • Gestisce resultsets multipli UGISS - User Group Italiano SQL Server

  6. Demo • RESULT SETS definition UGISS - User Group Italiano SQL Server

  7. Le novità del comando EXECUTE EXECUTE WITH RESULT SETS • EXECUTE (Transact-SQL) • About WITH RESULT SETS clause in SQL Server Code-Name "Denali" Presentazione e demo • http://www.ugiss.org Informazioni sul prodotto SQL Server • http://www.microsoft.com/italy/sql • http://www.microsoft.com/sql Supporto sviluppo ed professionisti IT • http://www.microsoft.com/technet/prodtechnol/sql • http://msdn.microsoft.com/sql Comunità SQL Server • http://www.ugiss.org Newsgroups pubblici via NTTP • microsoft.public.it.sql • microsoft.public.sqlserver.* Newsgroups pubblici via WEB • http://www.microsoft.com/italy/communities/newsgroups/default.mspx • http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx Formazione • http://www.microsoft.com/italy/traincert Risorse Generiche UGISS - User Group Italiano SQL Server

  8. SQL Server “Denali” CTP3 Le novità del comando EXECUTE

More Related