Viewing 15 posts - 8,416 through 8,430 (of 11,678 total)
Put an expression on that variable you mentioned and use those two date variables there. Make sure you convert those dates to string if you want to include them in...
December 21, 2011 at 12:56 am
Triality (12/20/2011)
Haha, I forgot to map the new derived column to the table column. Looks like that method did work!
I think that implicit conversion also works. If you insert...
December 21, 2011 at 12:54 am
Oh yeah, I forgot:
a few years ago, the SharePoint team published a white paper with "advice" on how to administer those databases. It was full of bad practices and the...
December 21, 2011 at 12:52 am
I don't know a lot of SharePoint databases (lucky me!), but I know the following:
* they are fond of using GUIDS (bleh)
* they have very cryptic names for their databases
*...
December 21, 2011 at 12:51 am
According to MSDN, indexes are not transferred:
"Indexes, constraints, and triggers defined in the source table are not transferred to the new table, nor can they be specified in the SELECT...INTO...
December 21, 2011 at 12:48 am
Coolroof (12/21/2011)
I want Change windows authendication user to sql server windows authentication user..because that user is main user. this user only create db and maintenace plan and jobs.pls steps
What is...
December 21, 2011 at 12:45 am
Dev (12/20/2011)
Koen Verbeeck (12/20/2011)
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're locked in...
December 20, 2011 at 11:56 pm
Dev (12/20/2011)
... the psychologist use ink blot cards (Rorschach test) to read the minds.
I'm not locked in here with you! You're locked in here with me!
Ahem...
10 bonus points...
December 20, 2011 at 11:43 pm
Greg J (12/20/2011)
fast-load... never saw it have such a dramatic effect.
It's because it does it inserts in bulk mode, while the regular mode does it inserts row by row (yup,...
December 20, 2011 at 11:37 pm
There is no easy answer for that.
It depends on those user defined functions: how complex are they, can they be translated into SSIS or not et cetera. You can call...
December 20, 2011 at 6:01 am
Charmer (12/20/2011)
i have column name CrossStreets in an excel sheet which will be having datas like "W MENOMONEE RIVER PKWY"....
i need to split the records into 3 columns...
December 20, 2011 at 5:43 am
ramyours2003 (12/20/2011)
thanks for sending i want all the databases in percentage growth instead of getting one db result .
What have you done so far?
December 20, 2011 at 5:19 am
Henrico Bekker (12/20/2011)
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but being able...
December 20, 2011 at 1:48 am
forsqlserver (12/20/2011)
Thanx Koen,But I just want to be precise and solid confirmation.
Actually, then you should check MSDN (or the F1 page), or call Microsoft support.
I can tell whatever I want...
December 20, 2011 at 1:44 am
Viewing 15 posts - 8,416 through 8,430 (of 11,678 total)