Viewing 15 posts - 346 through 360 (of 562 total)
It is possible to set Language for a connection.
Or you can also set Language for an account.
But from experience I am familliar with a lot of problems when the format...
September 1, 2015 at 5:27 am
See :
http://www.karaszi.com/sqlserver/info_datetime.asp
The ultimate guide to the datetime datatypes.
This explains the datetime datatypes very extensively. Far better than I could anwser your question.
Ben
September 1, 2015 at 2:00 am
Used to generate a large number of rows.
L0..L9 are used to generate a large number of rows.
The lower parts are used to generate a specific 'code' in this case a...
August 24, 2015 at 5:30 am
A sepperate thread has been created, to 'continue' the discussion about how constraints can prevent certain actions to be performed.
See:
Ben
August 14, 2015 at 8:05 am
Luis Cazares (8/13/2015)
My condolences go out to you and your family. I hope that you find comfort and peace.
Thank you, Ben
August 13, 2015 at 7:05 am
Hello All, I have had a rough week*) and not the oppertunity to reply.
Sorry for that.
The original question how to delete a duplicate row has been answered extensively enough. In...
August 13, 2015 at 6:46 am
Gazareth (8/4/2015)
For cases where there are children, you can avoid violating constraints by deleting in child -> parent order as I specified.
No date gets deleted. All data has to move...
August 4, 2015 at 3:53 pm
Gazareth (8/4/2015)That's really really easy then, probably the best case scenario. Merge the duplicate top levels based on whatever rules you have for this situation then delete the one with...
August 4, 2015 at 5:26 am
Gazareth (8/4/2015)
Either of these should work, but you're back to the problem of determining column names:
Yes back to the problem of determining the column names. And then de solution becomes...
August 4, 2015 at 5:12 am
ChrisM@Work (8/4/2015)
ScottPletcher (8/3/2015)
You can cancel the identity property by using a union or union all:
select top (0) * into #D from D1 union all select top (0) * from d1
insert...
August 4, 2015 at 2:29 am
Sean Lange (8/3/2015)
In your example of being unable to move data it is easily solved by moving the bottom most level to one of the existing accounts. Do the same...
August 4, 2015 at 1:06 am
Luis Cazares (8/3/2015)
If a constraint prevents actions that are valid, it's a design fault. Can you give an example on a constraint that prevents actions which are functional?
We have clients,...
August 3, 2015 at 8:53 am
Grant and Jeff,
Next to showering this weekend I finished a book, and enjoyed that very much. It does anwser a lot of questions, most questions are anwsered extensively, none of...
August 3, 2015 at 8:32 am
Grant Fritchey (8/3/2015)
Don't get hung too much on PLE.
Thanks for you reply.
I do tend to get hung up to much by 'numbers' in general, and like to understand how these...
August 3, 2015 at 7:12 am
This weekend I have been away from the keyboard. And as often the best idea's occure when away from the keyboard. E.g. on my bike (pushbike) or under the shower....
August 3, 2015 at 1:50 am
Viewing 15 posts - 346 through 360 (of 562 total)