Showing posts with label utility. Show all posts
Showing posts with label utility. Show all posts

Friday, February 24, 2012

convert keywords to UpperCase

I don't know if this is in the correct forum, but is there a simple utility to convert all reserved words to upper case in SQL Server 2005?

The find and replace is not the best option as there could be some field values/comments that would get converted.

With > 100 stored procedures/views something like this would be very beneficial. :)

Thanks
I don′t know of any tool like this, you could sure write one on your own if you have the bunch of reserverd words. But pro-actively you could use some other tool which keeps track of writing the keyword upper case while you are typing, like SQLPrompt which is free now:

http://www.sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/8/Default.aspx

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Friday, February 10, 2012

Convert Crystal RPT to Reporting Services?

Is there a utility to convert a Crystal v9 RPT to SQL Reporting Services?
David StevensonDavid Stevenson wrote:
> Is there a utility to convert a Crystal v9 RPT to SQL Reporting
> Services?
> David Stevenson
Check out the partner's page at:
http://www.microsoft.com/sql/reporting/partners/default.asp
Kenneth Weeks
"Failing to aerate the brain and rejuvenate the creative juices leads
to an atrophy of spirit and an inbreeding of thought" - Clay Shannon|||There is no native support in RS 2000 to do this. However, take a look at
the consulting partners site and contact them direcrlt for a service/product
combination to help you with this:
http://www.microsoft.com/sql/reporting/partners/consulting.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Stevenson" <david@.topstrategies.com> wrote in message
news:ONIDxWXdEHA.3616@.TK2MSFTNGP10.phx.gbl...
> Is there a utility to convert a Crystal v9 RPT to SQL Reporting Services?
> David Stevenson
>

Convert COM objects to Stored Procedure

Is there a 3rd party utility program that can convert complex COM objects
and DLLs to SQL Server stored procedures?
Thanks,
I doubt it. Are you asking about SQL Server 2000 or 2005? In SQL Server 2000
stored procedures are primarily for data manipulation. Data manipulation
should generally be set-based and declarative so the most efficient approach
to implementing procedural code in Transact SQL is usually to rewrite it as
set-based SQL - not something that is ever likely to automate well. As for
calling external COM code from SQL Server 2000, your main options are to
write an extended stored procedure or to use the sp_OA procs to invoke COM
objects from your procs.
SQL Server 2005 is a different matter. You can now catalogue .NET2.0 CLR
assemblies and call them directly as stored procedures. If you can implement
your COM as CLR code then in principle you may be able to run that code in
SQL Server 2005. That's not to say that it would always be a good idea to do
so. Data manipulation stuff will generally still be best implemented in SQL.
David Portas
SQL Server MVP

Convert COM objects to Stored Procedure

Is there a 3rd party utility program that can convert complex COM objects
and DLLs to SQL Server stored procedures?
Thanks,I doubt it. Are you asking about SQL Server 2000 or 2005? In SQL Server 2000
stored procedures are primarily for data manipulation. Data manipulation
should generally be set-based and declarative so the most efficient approach
to implementing procedural code in Transact SQL is usually to rewrite it as
set-based SQL - not something that is ever likely to automate well. As for
calling external COM code from SQL Server 2000, your main options are to
write an extended stored procedure or to use the sp_OA procs to invoke COM
objects from your procs.
SQL Server 2005 is a different matter. You can now catalogue .NET2.0 CLR
assemblies and call them directly as stored procedures. If you can implement
your COM as CLR code then in principle you may be able to run that code in
SQL Server 2005. That's not to say that it would always be a good idea to do
so. Data manipulation stuff will generally still be best implemented in SQL.
David Portas
SQL Server MVP
--

Convert COM objects to Stored Procedure

Is there a 3rd party utility program that can convert complex COM objects
and DLLs to SQL Server stored procedures?
Thanks,I doubt it. Are you asking about SQL Server 2000 or 2005? In SQL Server 2000
stored procedures are primarily for data manipulation. Data manipulation
should generally be set-based and declarative so the most efficient approach
to implementing procedural code in Transact SQL is usually to rewrite it as
set-based SQL - not something that is ever likely to automate well. As for
calling external COM code from SQL Server 2000, your main options are to
write an extended stored procedure or to use the sp_OA procs to invoke COM
objects from your procs.
SQL Server 2005 is a different matter. You can now catalogue .NET2.0 CLR
assemblies and call them directly as stored procedures. If you can implement
your COM as CLR code then in principle you may be able to run that code in
SQL Server 2005. That's not to say that it would always be a good idea to do
so. Data manipulation stuff will generally still be best implemented in SQL.
--
David Portas
SQL Server MVP
--