Viewing 15 posts - 4,576 through 4,590 (of 5,685 total)
SQL Iron Chef (12/13/2010)
In my environment I've seen:
1. WHERE ISNULL(burgertype, 'Bison Burger') <> 'Cheese Burger'
2. WHERE (burgertype IS NOT NULL OR burgertype <> 'Cheese Burger'
I'm just curious if there is...
December 13, 2010 at 1:39 pm
Alright, I'll bite. Anyone know how to turn a column from a stream in an SSIS package into a non-nullable version of itself? Data Conversion seemed like the...
December 13, 2010 at 1:22 pm
Renzo, you need to backtrack this to the source.
First, open up the raw document in something that can display CR/LF characters, like Notepad++. See if it's missing a LF...
December 13, 2010 at 1:16 pm
only4mithunc (12/13/2010)
Is it like declare @sql1 ,@sql2 etc as NVARCHAR(4000) , then finally @sql = @sql1+@sql2
sp_executesql @sql ... ?
You can keep doing it in a similar way, Only4. The...
December 13, 2010 at 1:12 pm
David...
1) GilaMonster = Gail Shaw. Definate she.
2)
Here my doubt is in this case as we are not able to use sp_executesql (due to the vary large length of the...
December 13, 2010 at 1:08 pm
GSquared (12/13/2010)
You won't be able to use a checksum on text.
Hmm. Guess I shoulda double checked the older format. It will work for VARCHAR(MAX), however. Yet another...
December 13, 2010 at 11:38 am
CELKO (12/13/2010)
Why is it a good idea to use proprietary...
December 13, 2010 at 11:32 am
Paul White NZ (12/13/2010)
Craig Farrell (12/13/2010)
As I'm wrapping my head around this, your comment above concerns me. This approach is as valid in 2k5 as well, right?
Yes :laugh:
All things...
December 13, 2010 at 11:14 am
Paul White NZ (12/13/2010)
LutzM (12/13/2010)
December 13, 2010 at 9:58 am
You might try ALTER DATABASE SINGLE_USER ROLLBACK IMMEDIATE.
This will force the database to a single_user mode (the one running the process) and rollback all transactions when it occurs. Make...
December 13, 2010 at 12:31 am
Tom.Thomson (12/12/2010)
GilaMonster (12/12/2010)
I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?
I guess it depends what it's a photo of....
December 13, 2010 at 12:24 am
Little Nick (12/12/2010)
tq sir. i'll try. will let you know if me facing any problem.
Please do. I'm sorry if you feel I'm being vague or sending you off to...
December 13, 2010 at 12:23 am
Offhand, there shouldn't be. That said, the merge join in SSIS tends to be a bit difficult the first few times you use it.
If you post your actual query,...
December 13, 2010 at 12:21 am
GilaMonster (12/12/2010)
I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?
And Peppermint Patty's friend Marcy will now be stuck in...
December 12, 2010 at 5:36 pm
ALZDBA (12/12/2010)
Steve Jones - SSC Editor (12/12/2010)
Tom.Thomson (12/12/2010)
Steve Jones - SSC Editor (12/11/2010)
Tom.Thomson (12/11/2010)
Celko's been at it again, and Gus's response http://www.sqlservercentral.com/Forums/FindPost1032150.aspx is unfair to monkeys.
Excellent response from Lowell and...
December 12, 2010 at 1:33 pm
Viewing 15 posts - 4,576 through 4,590 (of 5,685 total)