this one is tougher for me to test...at home i don't have another machine to connect to to test.

i think you might have issues if you don't grant permissions to...

phil 80558 (10/13/2011)

---

Thanks for the reply. No I'm not using SMMS 2005. It's all SQLServer 2008. WHy would a simple query to change a login password generate this error. Do...

are you sure you mean SQL injection?

SQL injection happens whenan app or a web page accepts input from the page without parameters or data cleansing...building a string like "SELECT...

the key is to full outer join the tables,a dn to then handle the nulls.

how does this work for you?

SELECT o. Id,

CASE

...

in SQL SErver Management Studio you are using...do help...About..

coul,d you be using 2005 SSMS when connecting to that 2008 instance?

i've seen issues where differences between GUI(and the code...

you need to simply join the two tables on the id , i think;

CREATE TABLE #TableA (

id int,

name varchar(30),

version varchar(30),

disposition varchar(30) )

CREATE TABLE #TableB (

id int,

name varchar(30),

version varchar(30),

disposition varchar(30) )

INSERT...

agreed.

@pveilleux has...

you guys completely forgot that you can use a check constraint that uses a user defined function...and that UDF can check mutiple columns, rows, values, other tables, whatever.

i've done several...

probably not the same situation Jayanth, but at our shop the developers email code to the DBA all the time...

but from there the code it tested agaisnt the dev version...

doesn't this have to be previewed by your company's attorney before you sign anything? in my shop, a lot of people above me would be involved before i ever...

done something very similar myself when porting our schemas to oracle equivilents.

i've always used NUMBER(10) for integers;

and here's the reference i used for my conversions:

http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/apa.htm

yeah, i think if your fields might be null, you'd get unexpected results, right?

if you wrap ISNULL into your concat, does it show where the issue lies?

...

part of a name...no, i don't think so.

you could split the list of names, and do a LIKE or charindex to see if whole words exist, by splitting on the...

but...but...aww...:w00t:

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:http://www.sqlservercentral.com/Forums/Topic1189017-1550-1.aspx