Impressive how you use dynamic sql exec() function to have tsql resolve expressions within parentheses. It looks like your work was mainly in finding the innermost parentheses and working...

Maybe create a database with a few synonyms and run the sql statements. You'll get failures until you have added synonyms for all references.

mar.ko (8/18/2015)

---

Guys - is there a better way to do this ?

INSERT INTO @TESTTAB SELECT * FROM dbo.UTIL_TABLE_FROM_STRING(@szDelimit)

Note....The stored function returns a table.

Why doesn't this work ?:

SET @TESTTAB = (SELECT...

My replacer function above is fairly generic and you could probably make it more so. Without going to dynamic sql you're pretty limited. Sql Server doesn't have a...

Are you looking for something like this?

IF EXISTS

(

SELECT *

FROM sys.objects

WHERE name = 'Replacer'

AND type in (N'FN', N'IF', N'TF')

AND objects.schema_id = SCHEMA_ID('dbo')

)

DROP FUNCTION dbo.Replacer

GO

CREATE FUNCTION Replacer

(

@Template varchar(max),

@Find1 varchar(10),

@Replace1 varchar(100),

@Find2...

Find a host with lots of cheap disk and restore there, and shrink, and backup to get a good bak file.

Check the autogrowth settings while you're at it. I've...

There are plenty of situations where GO is required. Some CREATE/ALTER/DROP statements must be the first in the batch. And the word "EXEC" is optional for the first...

A neat feature of GO is that you can specify a number after it and SSMS will run the batch of statements that many times:

delete top (10) from mytable;

GO 25

One...

I think a much faster algorithm would be to select a few identifying columns for the duplicate row and the binary_checksum(*) and group by those few columns having count(*) >...

If you are hiring for a programmer job the priorities should be to get a competent and emotionally stable person. I think finding someone who can drink with you...

This is for the dependent procs:

IF EXISTS

(

SELECT *

FROM sys.procedures

WHERE name = 'DropUdttDependentProcs'

AND type = N'P'

AND schema_id = SCHEMA_ID('dbo')

)

DROP PROCEDURE dbo.DropUdttDependentProcs

GO

CREATE PROCEDURE DropUdttDependentProcs

@UdttName varchar(128)

AS

DECLARE

@ProcedureName varchar(128),

@drop varchar(MAX),

@sql varchar(MAX)

;

SET @drop =...

There is a best way to change UDTTs; unfortunately it requires a good standard operating procedure the same as for changing Tables. Database objects are intricately connected in a...

I rely heavily on Logical file names. My customers all have their IT departments and naming conventions so I use Logical names to find instances of my databases I...

Very interesting!

A Group By on a set of columns is technically creating a Primary Key out of those so access will be faster for later steps.

I know in SS 6.5...

The largest tables in a database tend to be user "transactional" data. My rule is generally never allow deletes on these tables. So, I never create indexes on...