I'd argue this IS a bug.

If you pass a normal nvarchar LITERAL you get truncation. If you pass an nvarchar(max) you don't.

Thus there ARE two overloaded...

See, this is proof T/SQL is insane and full of gotchas. There is no reason replicate() shouldn't convert its arguments to nvarchar(max) since it can return nvarchar(max). 

MS REALLY needs to...

I tend to use triggers as audit log writers--and NOTHING else...

>> First of all, and IDENTITY is not a column. It is a table property. That means, strictly speaking, it can never be a key, because keys are made up...

Gotta agree with Jeff.

Open office plans SUCK.

I've worked with tall walls, small walls, offices with doors and offices without.

Give me an office where...

Steve, did you make a mistake in the question?

In the intro you said the file was called setsql.py but in the REPL you imported sample.

Made figuring...

Ouch. My sympathies.

When I encountered a similar situation my solution was to replace not only the back end but the front end as well. In other words a...

I've been an application developer for over 40 years and I'm a rabid supporter of the "database design is FIRST" philosophy.

But I take a bit of exception to...

SSMS with SQL Prompt makes a pretty good editor, mix that with Explorer to navigate SP creation scripts and a home grown tool that lets me generate stored procedure creation scripts/permissions...

Shades of Pascal...bleh

I actually have started using semi-colons to terminate lines, but I have to say T/SQL syntax is a nightmare mish mash of 1960s era design that somehow...