Viewing 15 posts - 196 through 210 (of 375 total)
I have been on both sides of the fence.
Developnig being one and guarding the DB against the developers being the other.:D
I think I still am, on both, at the...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 9:52 am
I guess everybody is missing my point. I even submitted a short article on this subjects few days ago and it is under review - I guess I did not...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 8:36 am
Yes Steve
string like column
It works and several times saved me a lot of coding. It is just another tool to be used. I understand that in many cases the performance...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 7:57 am
ALZDBA
I think the
where '%,'+thecolumn+',%' like '%,' + @theCSVstring + ',%'
in your post should be the other way around
where '%,' + @theCSVstring + ',%' like '%,'+thecolumn+',%' 😛
I...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 7:38 am
ALZDBA is probably right and the 1=1 is because of the dynamically generated SQL Select by the user interface.
My comment is that such a technique is a BAD, BAD...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 7:11 am
I do not think the sysmessages table structure changed since at least version 7
Plus I am not linking to sysmessages but using FORMATMESSAGE function so I do not care much...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 19, 2009 at 12:43 pm
I do not know if everyone here is going to agree with me but I got two comments
1. Try to avoid 1:1 relationships - make it into one table =...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 19, 2009 at 12:14 pm
I have to admint I did not spent too much time reading all the posts carefully but I think I did not find anyone suggesting the usage of the sysmessages...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 19, 2009 at 11:56 am
There is one problem with your script: it will not find all instances of the text in SPs, Views or functions that are larger then 4000 characters and the searchabe...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 19, 2009 at 7:49 am
One time I was faced with an old database system and had to figure out which SPs are not being used.
There is no easy and nice way of getting...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 18, 2009 at 8:47 am
Try this:
SELECT *
FROM User_Detail
WHERE ',' + @Temp + ',' LIKE '%,' + NAME + ',%'
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 18, 2009 at 8:24 am
OK. I am assuming the data type is VARCHAR because if it was numeric a simple SUM and a subquery would work.
What you may want to do is this:
create a...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
May 22, 2008 at 10:20 am
What is the data type in TABLE3.FIELD2A and TABLE1.FIELD1 ?
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
May 22, 2008 at 9:58 am
The order was supposed to be maintained by the IDENTITY field. Unfortunatelly the DB was not fast enough so we had to log into a file.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
May 22, 2008 at 7:24 am
Please remember that this encryption is quite simplistic and is not bullet proof. There are tools to crack this encryption.
I wish Microsoft built the encryption a much better way.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
May 22, 2008 at 7:14 am
Viewing 15 posts - 196 through 210 (of 375 total)