Forum Replies Created
Viewing 15 posts - 25,486 through 25,500 (of 26,490 total)
-
RE: date functions
Just another way to do it. One benefit, you don't have to know a date in the past that falls on the day you want to start your week on...
-
RE: date functions
I realized after posting I could remove the modulo calculation (%). This produces the same result:
declare @saveDateFirst tinyint,
@curDate datetime
-
RE: date functions
This will also work:
declare
@saveDateFirst tinyint,
@curDate datetime,
@LowerBound datetime,
@UpperBound
-
RE: Should I drop and recreate a stored proc everytime?
>> BTW, you can't see when the procedure was last altered, but you can see "date created". So, for possible future searches when precisely it was last modified, DROP/CREATE gives...
-
RE: Performance of Joins Vs Functions
I would join the lookup tables to the core table. Using a function in this case could cause a potential performance problem.
-
RE: INSERT
set
dateformat dmy
select cast('2007-04-24' as
-
RE: receive emails from SQL Server 2000
Yes. You would use SQL Mail. This requires a mapi client to be installed on the server (Outlook, not Outlook Express).
-
RE: Does this problem require a loop?
You shouldn't need a loop. Look at writing the query using group by.
-
RE: Does this problem require a loop?
Are you looking for something like this:
School1 #enrolled #InAttendance
??
-
RE: Using SOUNDEX
You can also find some more information on SSC regarding metaphone, just go to the SSC search page and search on metaphone. I checked all three boxes for the search...
-
RE: How to Set Recovered DB back to restoring mode
Leaves the database available for read-only access and so ou can apply future t-log backups.
-
RE: How to Set Recovered DB back to restoring mode
A full and differential backup is consistant as of the end of the backup. Both backup enough of the transaction log to ensure the consistancy of the backup for restore...
-
RE: log file
If you are doing a backup log with truncate only, then that tells me you are in bulk-logged or full recovery mode. You should be running scheduled transaction log backup...
-
RE: How to Set Recovered DB back to restoring mode
You will need to restart your restore from the beginning. This means overwriting what you have already done.
-
RE: DTS and how do you edit in SQL 2005?
Yes, and I wish I had a better answer for you at this point.
Viewing 15 posts - 25,486 through 25,500 (of 26,490 total)