Viewing 15 posts - 23,581 through 23,595 (of 26,490 total)
The sample databases pubs and NorthWind are gone. They were replaced with the AdventureWorks database.
As for creating your own user databases, I'd start with reading Books Online and the...
November 21, 2008 at 11:46 pm
Care to elucidate more on what you are trying to ask?
November 21, 2008 at 11:43 pm
Based on the following:
Backup & Restore example:
FULL Backup 1:00 am
DIFF # 1 5:00 am -- all changes between 1:00 am and 5:00 am
t-log #1 ...
November 21, 2008 at 11:36 pm
I don't know. You haven't shown me what you are talking about.
You might also want to read the first article linked in my signature block below. It will...
November 21, 2008 at 10:29 pm
This is actually simple, and I'm pretty sure you could find an example in Books Online. Why don't you check it out.
November 21, 2008 at 10:07 pm
Sergiy's question
Simple question.
Last payment date is 29 Feb 2008.
What must be the next payment date?
29 Mar, 30 Mar or 31 Mar?
Actually, quite reasonable, and I'd like to see your...
November 21, 2008 at 10:04 pm
Jack Corbett (11/21/2008)
Now there's a Hall of Fame answer! :D:P
What?? I didn't do nothin'. -- (inside joke, anyone interested in personal happens, PM me I'll fill you in)
November 21, 2008 at 5:46 pm
First, my first example was using a CTE called UneBookings to reduce what was Table B (original post, not modified) to one record per booking.
This wasn't needed when what was...
November 21, 2008 at 5:43 pm
Rod at work (11/21/2008)
November 21, 2008 at 4:08 pm
Just a suggestion, as I believe I read somewhere that 3 part naming of columns (schema.tablename.columnname) is being depreciated, you may want to look at dropping the dbo. from your...
November 21, 2008 at 3:58 pm
Just my opinion, but any function offered here, really should be able to return the same value regardless of setting on indiviual servers. For example, the first solution offered...
November 21, 2008 at 3:43 pm
How is the stored procedure inserting the data? Is it row by row or from another table?
November 21, 2008 at 3:39 pm
Also, from Books Online regarding sys.sysobjects:
Important:
If you use any of the following SQL Server 2005 DDL statements, you must use the sys.objects catalog view instead of sys.sysobjects.
CREATE |...
November 21, 2008 at 2:58 pm
Maybe not, but sysobjects is for backward compatibility with earlier versions of SQL Server and could easily go away in future versions of SQL Server. I think I read...
November 21, 2008 at 2:55 pm
Viewing 15 posts - 23,581 through 23,595 (of 26,490 total)