Viewing 15 posts - 2,176 through 2,190 (of 2,469 total)
Suri - I forgot to add - "and what Remi says...." <;-)
June 13, 2005 at 9:44 pm
You should be able to do this with a case statement...
eg:"ORDER BY CASE @sort WHEN 'Col1' THEN Column1 WHEN 'Col2' THEN Column2 ELSE Column3 END"....or some such!
June 13, 2005 at 5:31 pm
Far as I know - there does exist a vss/sql server integration for version control - seem to remember reading about it quite a few months back...maybe someone else can...
June 13, 2005 at 2:24 pm
Erik - here's where I was hoping that someone who's actually used zip codes in an application would be able to help out with specific names/tools etc..
However, until then just...
June 13, 2005 at 7:33 am
Point taken Paul...however validations could still have been put in place to ensure this!
"XML is like violence...If it doesn't solve your problem, you are not using enough of it" -...
June 13, 2005 at 7:29 am
The developers should have put a validation check to begin with so this cleanup operation wouldn't have been needed...as Lowell said - the "not null" constraint should definitely be added...
June 13, 2005 at 7:14 am
There are so many areas of Sql Server that one may never get to use on the projects that the developers are working on....Replication, linked servers to name just a...
June 13, 2005 at 7:04 am
Erik - hopefully someone who's worked on something similar will respond to this soon, but here's my 2 cents..
Your best route would be to buy a "zip database" - something...
June 13, 2005 at 6:48 am
C'est le pays le plus peuplé au monde après la Chine - dead giveaway huh!!!
BTW - if you think of it as "sue" + "sheila" (some concatenation here...) it's easier!
June 8, 2005 at 4:49 pm
If it's just one single user for one single table (how odd! maybe I don't understand correctly..) then the GUI is easy...
Otherwise I would create a role - grant/deny permissions...
June 8, 2005 at 4:39 pm
Know what Remi - I think you should - maybe that's the only way you'll get people to respond!
ps: Maybe Frank will respond by morning...or Chris...or anyone else in European...
June 8, 2005 at 3:24 pm
Amazingly no one wants to pick up on the challege Remi - not even Ron!
As for "it's only the 3rd one I start. I can't understand how the other 1720+...
June 8, 2005 at 2:19 pm
Dale - I wasn't really planning on coming back to this post and picking up the thread but I just finished reading the response to the "Ron Reagan" one...WHAT A...
June 8, 2005 at 1:54 pm
Remi - point taken - though if you start out with a flawless design like I do (ya right!!!!!!) and never have to make schematic changes then this won't be...
June 8, 2005 at 11:14 am
Viewing 15 posts - 2,176 through 2,190 (of 2,469 total)