Great idea but I think they really want a custom error message and a check constraint won't do it. Ran into the same problem with permissions... no custom error message.Switching gears...Remi knew what I meant when I said a "before" trigger... it's really called an "Instead of" trigger in BOL which, unlike the standard or "after" […]
2005-01-06
Not causing any trouble by making suggestions. We think on them, sometimes the time is right, sometimes not. Also a matter of time and resources - isn't most everything?! We're doing some ground work now on some internal changes, our data model has sprawled a bit, we aim to clean that up and finish the […]
2005-01-06
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
At the risk of being accused of being facetious, here are the differences between C# and VB.NET:- C# uses { and } to delimit blocks, whereas VB.NET generally uses new lines and tokens that are English wordseg if (condition) { true-block } else { false-block }versusIf condition Then true-block Else false-block End If- […]
2004-12-16
To be fair, SQLTeam is also an interesting site. A comparison between the method suggested by Scott and another one can be found here on the blog of SQL Server MVP Adam Machanic:http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=trueHTH
2004-12-06
We've found that we have certain problems when using new unformatted tapes. Unfortunately I've written stuff to all of our tapes during the testing process and no longer have any to test with. Is there a method to restore an LTO tape back to 'in the box' condition? Would a bulk-eraser work on these tapes […]
2004-11-23
4 reads
Farrel,No worries mate. Don't forget though: If you declare the variable within an sql string and exec it, it will generate a new spid and the variable will only have the lifespan of the new spid. It won't be useable anywhere else in your sproc - thats when you get the variable declaration error messages. […]
2004-11-10
Hi Steve,we do monitor all the servers with CA TNG Unicenter. That work perfectly by the way. So the DBA-on-24/7-call guy gets the call when something happens to one of the servers and takes care of business.What we really would like is make checking the jobs and logs quicker. Now it takes quite some time to surf […]
2004-11-10
Okay, makes sense, but does not explain why the text suddenly appears when I remove the photo field...?? As I mentioned above it works fine when the text datatype is VARCHAR - what confuses me is that I have used the same datatypes on earlier websites with no problems... Luckily the propertyDescription will not be […]
2004-11-09
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-08
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers