Viewing 15 posts - 20,791 through 20,805 (of 26,484 total)
Given the follwoing table:
create table dbo.MyTable (
DataCol1 int,
DataCol2 datetime,
DataCol3 varchar(25)
);
The new table would be like this:
create table dbo.MyNewTable...
May 26, 2009 at 10:28 am
middletree (5/26/2009)
I know this sounds weird, but I have...
May 26, 2009 at 10:23 am
Looks to me like the IDENTITY column should be a SID. It should have NO RELATION to the data being inserted other than providing a unique ID for each...
May 26, 2009 at 10:19 am
We are approaching the next big Party Time for The Thread. I suspect we'll hit 5,000 posts early in June with a possibility of it occuring by May 31st.
May 26, 2009 at 10:14 am
middletree (5/26/2009)
Helpful article, Lynn, but reading it makes me think we need to stay in Full Backup mode.
If you need point in time recovery, then yes you do.
Now that you...
May 26, 2009 at 10:11 am
Bob Hovious (5/26/2009)
They need a new how-to book: SQL for Window-Washers.I keep telling you Lynn, just don't look at his stuff and you will enjoy much more serenity.
😛
It's...
May 26, 2009 at 9:50 am
Damus (5/26/2009)
- real foreach loops through table rows.
Why use RBAR when set based solutions work much better and efficiently?
May 26, 2009 at 9:46 am
middletree (5/26/2009)
May 26, 2009 at 9:24 am
Damus (5/26/2009)
I withdraw all comments I previously posted on this discussion.I appologize to anyone who was offended. Did not mean anything wrong.
Peace (white flag)
I wasn't offended. I am...
May 26, 2009 at 9:19 am
Damus (5/25/2009)
May 26, 2009 at 8:16 am
David Burrows (5/26/2009)
SQL Server takes the numeric value up to the first Alpha character as a numeric value (SELECT 1.) and the alpha characters that follow are then the alias...
May 26, 2009 at 7:04 am
josephptran2002 (5/24/2009)
How are you doing? I am greatly appreciated your helps, I already solved the problem by using SSMS or Import/export wizard. You are very nice person, and may...
May 24, 2009 at 8:22 pm
You really have to be kidding, right?
I guess some people just don't get it, do they?
Time to wonder off back to the desert...
May 24, 2009 at 9:07 am
Paul White (5/23/2009)
What is this "soccer" everyone keeps referring to? :laugh:
Well, it is what the rest of the world calls football or futbol. Sorry, but us Americans call it...
May 24, 2009 at 12:26 am
David Burrows (5/23/2009)
but she who must be obeyed would have fit.
It's easier to ask for forgiveness than it is for permission. :w00t:
Would not matter, if she isn't happy, no one...
May 23, 2009 at 2:32 pm
Viewing 15 posts - 20,791 through 20,805 (of 26,484 total)