Alvin Ramard (11/25/2009)

---

I can't say Jason. I only have ten fingers so these bigs numbers can be...

I generally use bit for that. Would use char(1) if it were to be Y/N.

I got used to using bit fields because my first app used Access as the...

To the two new people here, welcome aboard. Always remember, the most important rule of all, for this thread, is "it depends". We're sticklers for that one. ...

The -1 is what gets rid of the comma. Leave it in.

Glad you got what you need, and thank you for the compliment. 🙂

Lowell (11/24/2009)

---

ok here's another idea...besides the planned filtering, what if the application started a transaction, ran the script, and then rolled back the transaction?

if it was a valid SELECT statement,...

Add:

Where YourColumnName like '%,%'

to the end of the query.

select left(@String, charindex(',', @String)-1) as Col1,

right(@String, len(@String)-charindex(',', @String)) as Col2;

Replace "@String" with your column name, and add "From " and your table name. Replace "Col1" and "Col2" with your...

Someone went WAY overboard on that split.

If it'll always be just one comma, try something like this:

declare @String varchar(100);

select @String = 'first,last';

select left(@String, charindex(',', @String)-1),

right(@String, len(@String)-charindex(',', @String));

Charindex finds the position...

RegEx might help, but what happens if there's a table with a column named "ExecutionDate", for the execution date of a trade or sale? Will you block all queries...

Steve Jones - Editor (11/24/2009)

---

Well, I'm hoping you don't work for my bank, doctor, mortgage broker, etc.

I've seen similar things in many places. I have had to implement the "change...

Set up a read-only copy of the database and make it so it can only connect to that.

Permissions would be the best way to manage this, but if you really...

One of the dumbest things I've ever had to handle was being handed a laptop when I was hired, with a spreadsheet of all the sa passwords for all the...

Jeff, have you been to Atlanta recently?

Just saw this on Google news.

Why remove them? Just include that in the query.

If you really need to remove it, you'll need to convert to varchar(max), and use the Replace function, then convert back...

First, you need to fix your XML. It has things like a start-tag of "ID" and an end-tag of "/tradeID", and "name" with "/measure". That's not correct XML,...