Forum Replies Created
Viewing 15 posts - 36,961 through 36,975 (of 39,720 total)
-
RE: Returning Rows That Dont Contain any NULLS!
You'd have to include in the where clause
where cola is not null
and colb is not null
...
Steve Jones
-
RE: getdate question
use coldate < dateadd('d', 1, getdate())
Steve Jones
-
RE: Forcing SQL delete SA user, and create a new user
I agree that a password should be created. We delete sa? Doesn't make sense.
Steve Jones
-
RE: Comparing varchar datatypes with values like x.x.x
Antares has the best solution.
Steve Jones
-
RE: Need to force proper case of sentence
Of every word? If the first word, use substring and upper() and lower()
select upper(substring(col,1,1)) + substring( col,2)
Steve Jones
-
RE: Is T-SQL enough to be a valuable Yukon DBA?
I think it will be enough. Nice to know the others, but not necessily needed. Last I saw, Yukon wasn't completely set, so not sure how much .NET will be...
-
RE: Read from Text File Into Table?
DTS can do this. Bulk Copy can, but you'd probably want to do a DOS find and get the lines you need into a separate table.
Or load hte whole thing...
-
RE: Lost SQL Server Registration during pass change
Running XP Pro, using Domain (AD Native mode) and no issues changing passwords. Do it every 30 days (4 so far).
Steve Jones
-
RE: Archiving Data.
I'd agree. Depends if you need it. You could also denormalize and include some of the FK stuff into the table.
Steve Jones
-
RE: Forum Search
no, it's a bug. I've seen it disappear on some pages. Always on the home page though.
Steve Jones
-
RE: Truth about Oracle and MSSQL...Help needed
I'm an MS user and have been working with SQL Server for 12 years. I've only developer (briefly) against Oracle, and that was 7, so I'll admit first off that...
-
RE: Change Screen Colors
That's a bug with the forum that only occurs some of the time. We use the Snitz forums (forum.snitz.com) and are testing their upgrade as well as another forum. We...
-
RE: Forum Search
The Search button on the top menu will search articles and / or forums.
We know we need to enahance this, just haven't had time.
Sorry.Steve Jones
-
RE: Sql Mail Error
Check and see if something may have changed on the Exchange server.
Steve Jones
-
RE: Table size
Thanks for the update.
Steve Jones
Sorry.Viewing 15 posts - 36,961 through 36,975 (of 39,720 total)