Comments
Sort by recent activity
Wow, I guess I've just never tried to name something that. I just tried to create a file prn.txt and it did not work. Good catch!
Thanks! / comments
Wow, I guess I've just never tried to name something that. I just tried to create a file prn.txt and it did not work. Good catch!
Thanks!
David, did this make sense? This would be really helpful if it's possible using SQL Prompt or Refactor. We have hundreds of existing stored procs that will not compile in our new case-sensitive SQL server without touching each one of them and making all the variables/stored proc/table name references match in case to the objects and declerations. / comments
David, did this make sense? This would be really helpful if it's possible using SQL Prompt or Refactor. We have hundreds of existing stored procs that will not compile in our new case-sensitive S...
No, camel-casing was just example. It's just basically making case-sensitive any custom code. The variable/stored proc/table name/etc. could have been previously been declare like this @..., and in a case-insenstive environment used later on like this @..., but I need all references to a variable/stored proc/table name/etc. to match their decleration or definition case. / comments
No, camel-casing was just example. It's just basically making case-sensitive any custom code. The variable/stored proc/table name/etc. could have been previously been declare like this @..., and ...
Correction:
--original
SELECT @var = aCol FROM linkedServer.dbo.aTablename --case corrected from linkedServer.dbo.aTablename to linkedServer.dbo.aTablename
--auto-format
SELECT @Var = aCol FROM LinkedServer.dbo.aTableName --case corrected from linkedServer.dbo.aTablename to LinkedServer.dbo.aTableName / comments
Correction:
--original
SELECT @var = aCol FROM linkedServer.dbo.aTablename --case corrected from linkedServer.dbo.aTablename to linkedServer.dbo.aTablename
--auto-format
SELECT @Var = aCol FROM Lin...
Yes, my apologies for not doing that originally. This is a really simple example, but basically we have 100s of stored procs that were built in a case-insensitive SQL environment that need to be corrected to work in a case-sensitive environment. It would be great if there was some script that could be run to fix it, but it's not a problem to open each one up and click an auto-format button and ALTER the stored proc. Thanks for your time.
--original
DECLARE @Var AS INT
SET @var = 1234
SELECT @var = aCol FROM linkedServer.dbo.aTablename --actually looks like this in database LinkedServer.dbo.aTableName
EXEC dbo.aStoredProc --actually looks like this in database dbo.aStoredPROC
--auto-format
DECLARE @Var AS INT
SET @Var = 1234 --case corrected from @var to @Var
SELECT @var = aCol FROM linkedServer.dbo.aTablename --case corrected from linkedServer.dbo.aTablename to linkedServer.dbo.aTablename
EXEC dbo.aStoredPROC --case corrected from dbo.aStoredProc to dbo.aStoredPROC / comments
Yes, my apologies for not doing that originally. This is a really simple example, but basically we have 100s of stored procs that were built in a case-insensitive SQL environment that need to be c...