You can use INSTR, but it will be fairly efficient. It definitely works, but you really need to call it continuously until the entire string is parsed. This...

Unfortunately, it's usually done by not giving your developers CONTROL permission on the dbo schema in the first place. When best practices aren't followed, it usually takes more work...

You could use schemas. Put the tables in one schema and give SELECT permission to the developers. Give them another schema on which they have CREATE permission. ...

Either way you slice it, it's all going to start with that split function. It's simply one of the best ways to break apart a string like that. ...

How do you intend to do that unless there is a fixed number of columns? If you know how many columns there will be, you can PIVOT the data....

Here is a fairly common string split function that I use often:

CREATE FUNCTION strSplit (@arr AS NVARCHAR(MAX), @sep AS NCHAR(1))

RETURNS TABLE

AS

RETURN

WITH

L0 AS (SELECT 1 AS C...

Nadrek (7/21/2010)

---

'Will definately use more resources', as everyone else has said, is just wrong. CPU resources? Disk resources? Bandwidth, memory, or network resources? At design time,...

It may require a little bit of time initially to set it up, but those synronization and maintenance problems go away. You'll save time in the long run.

--J

Yes, you would install SQL Server to a machine. You can install it to the same machine or a different machine. Using a different machine means you can...

You could install another database instance (possibly even express edition), and copy the databases using the same names. I can't imagine your website code likes different database names any...

This may have been a trick question where they were actually looking for you to tell them that this is a undesirable backup solution (for several reasons). Or, perhaps...

Short answer: You wouldn't do this. It's rediculous.

Long answer: What?

What you are looking for is the INSERT...EXEC construct. Consider:

INSERT INTO @tablevariable

EXEC sp_MyRemoteTable

You will need to prepare the table variable (or a temporary table will work) ahead of time...

Consider dropping the cursors altogether. Especially in a trigger. A cursor is much slower than a set-based operation, and if you were to insert a large number of...

I spoke with my boss and we decided to get those objects out of the master database. I've opted instead for a database called "Global", which will store all...