Have to agree with that one.

Can't hurt to find out...

I would probably encrypt and decrypt in the application, before it ever gets sent to the database. That way, it's not even plain-text on the network between the two....

Yes, I left out 0. Otherwise, I would use Like for the test.

Here's how I'd be likely to write something like this:

if object_id(N'tempdb..#T') is not null

drop table #T;

create table...

You write from left to write, right? Any idea how old that standard is?

As expected, this has turned into Boot Hill as far as postings from the OP go.

Lynn Pettis (1/8/2010)

---

Thankfully, NO! I (actually the family) did get a few good (IMHO) movies: Star Trek, GI Joe,...

You could convert using style 10, then wrap that in a replace that gets rid of the punctuation.

You could do this:

select

workstation,

date_entered

from

inventory

where

part_number = 'ABC'

and workstation >= 5

union all

select

...

Servers usually aren't all that loud, but the limit would really be...

Try a few of these to find the limits of IsNumeric:

select IsNumeric('1d10');

select IsNumeric('1e10');

select IsNumeric('0xF');

select IsNumeric('10');

select IsNumeric('Hello');

The only ones that are not "numeric" are the hex number and "Hello". The...

I just tested it to be sure. *= is left, =* is right.

I created a compat-80 database, and tested this:

create table dbo.L (

LNum int primary key);

go

create table dbo.R (

RNum...

Lynn Pettis (1/6/2010)

---

Not...

Whoah! "Queen Xeno"??? Where did you...

Create either a permanent or inline calendar table and join to that.

Here's an example using a Numbers table to generate an inline calendar. I've got an add that ran...

lmu92 (1/6/2010)

---

Beside your sample data are not wellformed xml data (name tag with spaces), I'd use XQuery instead of openxml:

SELECT

c.value('column1[1]','varchar(30)') as c1,

c.value('column2[1]','varchar(30)') as c2,

c.value('column1500[1]','varchar(30)') as c1500

FROM @xml.nodes('NewDataSet') a(b)

CROSS apply...