BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  SQL 2005 Goto page 1, 2, 3  Next          BorlandTalk.com Forum Index -> Delphi Non-Technical View previous topic :: View next topic   Author Message Phil Barber Guest Posted: Thu Jun 30, 2005 12:02 am    Post subject: SQL 2005 I recently attended a VS2005 road show, they talked about how in SQL 2005 the CLR is now supported in stored procedures and triggers. it looks like it has real possibilities. the guy created a stored procedure from within the IDE which had C# classes and procedures right in the stored proc code. He went on to say the Delphi.Net would support this as well. I was wondering if anyone has heard if Borland will have this feature in the next version of Delphi? Phil. Back to top Dan Palley Guest Posted: Thu Jun 30, 2005 12:11 am    Post subject: Re: SQL 2005 "Phil Barber" <pbarber1 (AT) houston (DOT) rr.com> wrote Quote: I recently attended a VS2005 road show, they talked about how in SQL 2005 the CLR is now supported in stored procedures and triggers. it looks like it has real possibilities. the guy created a stored procedure from within the IDE which had C# classes and procedures right in the stored proc code. He went on to say the Delphi.Net would support this as well. I was wondering if anyone has heard if Borland will have this feature in the next version of Delphi? I don't think anything in Delphi needs to be done except maybe support Net 2.0, which is already planned, I believe. Was the presenter Euan Gardner, by any chance? Dan Back to top Dave Nottage [TeamB] Guest Posted: Thu Jun 30, 2005 12:25 am    Post subject: Re: SQL 2005 Dan Palley wrote: Quote: Was the presenter Euan Gardner, by any chance? I believe you mean Euan Garden <g> -- Dave Nottage [TeamB] Back to top Phil Barber Guest Posted: Thu Jun 30, 2005 12:31 am    Post subject: Re: SQL 2005 "> I don't think anything in Delphi needs to be done except maybe support Net Quote: 2.0, which is already planned, I believe. Was the presenter Euan Gardner, by any chance? Dan I did not jot his name down and I do not recall it. Don't you think they would have to enchance the database explorer quite a bit? I mean you would need the ability to add/edit Sp's and triggers. Phil Back to top Dan Palley Guest Posted: Thu Jun 30, 2005 12:32 am    Post subject: Re: SQL 2005 "Dave Nottage [TeamB]" <davidn (AT) n0sp4m (DOT) please.radsoft.com.au> wrote in message news:42c33bde$1 (AT) newsgroups (DOT) borland.com... Quote: Dan Palley wrote: Was the presenter Euan Gardner, by any chance? I believe you mean Euan Garden Yes, thanks. My apologies to Mr. Garden. Dan Back to top Dan Palley Guest Posted: Thu Jun 30, 2005 1:32 am    Post subject: Re: SQL 2005 "Phil Barber" <pbarber1 (AT) houston (DOT) rr.com> wrote Quote: "> I don't think anything in Delphi needs to be done except maybe support Net 2.0, which is already planned, I believe. Was the presenter Euan Gardner, by any chance? Dan I did not jot his name down and I do not recall it. Don't you think they would have to enchance the database explorer quite a bit? I mean you would need the ability to add/edit Sp's and triggers. Well, I would imagine you would write and compile the code in Delphi and then integrate the compiled units into SQL Server using their admin tools. I agree that having that level of integration in the database explorer would be nice, but it in no way prevents you from creating the triggers and SP's in Delphi. Dan Back to top Wayne Niddery [TeamB] Guest Posted: Thu Jun 30, 2005 3:05 am    Post subject: Re: SQL 2005 Phil Barber wrote: Quote: I recently attended a VS2005 road show, they talked about how in SQL 2005 the CLR is now supported in stored procedures and triggers. it looks like it has real possibilities. the guy created a stored procedure from within the IDE which had C# classes and procedures right in the stored proc code. He went on to say the Delphi.Net would support this as well. I was wondering if anyone has heard if Borland will have this feature in the next version of Delphi? This was shown at last year's BorCon using Delphi. -- Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com) RADBooks: http://www.logicfundamentals.com/RADBooks.html SpaceShipOne; GovernmentZero Back to top John Kaster (Borland) Guest Posted: Thu Jun 30, 2005 4:06 am    Post subject: Re: SQL 2005 Phil Barber wrote: Quote: I was wondering if anyone has heard if Borland will have this feature in the next version of Delphi? This has already been demonstrated at BorCon last year. Also, NDataStore (working name), the version of JDataStore for .NET, has support for Delphi/C#/<your favorite .NET language> stored procedures as well, and was demonstrated last year at BorCon. Hopefully, it will be released by this year's DevCon ;) -- John Kaster http://blogs.borland.com/johnk Features and bugs: http://qc.borland.com Get source: http://cc.borland.com If it's not here, it's not happening: http://ec.borland.com Back to top Deepak Shenoy (TeamB) Guest Posted: Thu Jun 30, 2005 5:36 am    Post subject: Re: SQL 2005 Dan Palley wrote: Quote: I don't think anything in Delphi needs to be done except maybe support Net 2.0, which is already planned, I believe. I'm not sure about this, but perhaps the IDE will need to be modified to support some of the SQL Server 2005 features. There's a different sandbox for the stored procedures, and the code insight etc. would probably need to take that into consideration. But then this is not yet the final avatar of SQL Server 2005 - still beta 2 IIRC. There might be more architectural changes. -- Deepak Shenoy (TeamB) Agni Software (http://www.agnisoft.com) Blog: http://shenoyatwork.blogspot.com Back to top Kyle A. Miller Guest Posted: Thu Jun 30, 2005 6:25 am    Post subject: Re: SQL 2005 Phil Barber wrote: Quote: I recently attended a VS2005 road show, they talked about how in SQL 2005 the CLR is now supported in stored procedures and triggers. it looks like it has real possibilities. I saw SQL Anywhere do this with Java many, many moons ago. It didn't seem to catch on. With Microsoft's approval, it might get noticed now. Back to top James K Smith Guest Posted: Thu Jun 30, 2005 6:48 am    Post subject: Re: SQL 2005 What kind of advantage would this provide over extended stored procedures? "Phil Barber" <pbarber1 (AT) houston (DOT) rr.com> wrote Quote: I recently attended a VS2005 road show, they talked about how in SQL 2005 the CLR is now supported in stored procedures and triggers. it looks like it has real possibilities. the guy created a stored procedure from within the IDE which had C# classes and procedures right in the stored proc code. He went on to say the Delphi.Net would support this as well. I was wondering if anyone has heard if Borland will have this feature in the next version of Delphi? Phil. Back to top Oliver Townshend Guest Posted: Thu Jun 30, 2005 8:20 am    Post subject: Re: SQL 2005 Quote: What kind of advantage would this provide over extended stored procedures? Maybe it will only allow managed code, reducing the chance of errors and memory leaks. Oliver Townshend Back to top Craig Stuntz [TeamB] Guest Posted: Thu Jun 30, 2005 2:01 pm    Post subject: Re: SQL 2005 Oliver Townshend wrote: Quote: Maybe it will only allow managed code, reducing the chance of errors and memory leaks. It's not just memory leaks you need to worry about. Even just allocating memory in a non-ideal way can negatively impact your server: http://blogs.msdn.com/khen1234/archive/2005/05/08/415501.aspx Using the CLR lets SQL Server itself handle the memory allocations. There are also large security issues with xprocs. -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz How to ask questions the smart way: http://www.catb.org/~esr/faqs/smart-questions.html Back to top Mike Swaim Guest Posted: Thu Jun 30, 2005 2:23 pm    Post subject: Re: SQL 2005 James K Smith wrote: Quote: What kind of advantage would this provide over extended stored procedures? In the example I saw, they accessed the file system. There are also some things that I find a lot easier to do in a procedural language than SQL, like parsing strings. -- Mike Swaim [email]swaim (AT) hal-pc (DOT) org[/email] at home | Quote: "Boingie"^4 Y,W & D MD Anderson Dept. of Biostatistics & Applied Mathematics [email]mpswaim (AT) mdanderson (DOT) org[/email] or [email]mswaim (AT) odin (DOT) mdacc.tmc.edu[/email] at work ICBM: 29.763N 95.363W|Disclaimer: Yeah, like I speak for MD Anderson. Back to top James K Smith Guest Posted: Thu Jun 30, 2005 3:47 pm    Post subject: Re: SQL 2005 You can use dlls with extended stored. "Mike Swaim" <mswaim (AT) odin (DOT) mdacc.tmc.edu> wrote Quote: James K Smith wrote: What kind of advantage would this provide over extended stored procedures? In the example I saw, they accessed the file system. There are also some things that I find a lot easier to do in a procedural language than SQL, like parsing strings. -- Mike Swaim [email]swaim (AT) hal-pc (DOT) org[/email] at home | Quote: "Boingie"^4 Y,W & D MD Anderson Dept. of Biostatistics & Applied Mathematics [email]mpswaim (AT) mdanderson (DOT) org[/email] or [email]mswaim (AT) odin (DOT) mdacc.tmc.edu[/email] at work ICBM: 29.763N 95.363W|Disclaimer: Yeah, like I speak for MD Anderson. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Non-Technical All times are GMT Goto page 1, 2, 3  Next Page 1 of 3   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.