Viewing 15 posts - 2,641 through 2,655 (of 7,429 total)
Lots of ways to strip the time. Here is how I would do
DATEADD(hh,5,DATEADD(d,DATEDIFF(d,0,GETDATE()),0))
July 31, 2003 at 11:16 am
Sorry the short name looks odd but found
quote:
DB:db_id[BULK-OP-LOG], which identifies the lock taken by the backup log for that particular database....
July 31, 2003 at 6:48 am
Ah, I understand. However if the columns datatype to begin with is a datetime type you will not have to worry about corruption. Only if you are storing in a...
July 31, 2003 at 6:41 am
Can you give me an example of how the query is structured? And exactly how you are working it.
July 31, 2003 at 5:58 am
quote:
DB: 17 [BULK-OP-LOG]
DB = Database
17 = is the database id which you can find out...
July 31, 2003 at 5:37 am
Or alternately
UPDATE Table1
SET Table1.NumOfImages = SubQ.Cnt
FROM Table1
INNER JOIN
(SELECT
COUNT(IQ.KeywordID) Cnt,
IQ.KeywordID
FROM
Table2 IQ
GROUP BY
IQ.KeywordID
) SubQ
WHERE Table1.KeywordID = SubQ.KeywordID
July 31, 2003 at 5:31 am
In this situation either BREAK or GOTO will work.
BREAK will simple stop the LOOP it is in and continue processing beyond that loop so it is inline processing.
GOTO however...
July 31, 2003 at 5:27 am
Has he provided a specific reason for not wanting to upgrade? There is no way to get UDF's in SQL 7 you either write the logic in the client or...
July 31, 2003 at 5:09 am
I generally use UDFs but only in the capacity of the columns output for the select statement. So
SELECT col, col, udf(col) as x, col... FROM tbl
I tend to avoid them...
July 31, 2003 at 5:06 am
quote:
Is the following statement a valid example of the checksum-statement ? I've read about the * on msdn (-which does not...
July 31, 2003 at 4:21 am
quote:
If MSSQLSERVER is running under an admin account you certainly can.Reminds me of the time I used it (for security...
July 30, 2003 at 5:21 am
Ared you getting an error?
Also you state for Northwind but you conenction has pubs as the initial catalog.
July 30, 2003 at 5:16 am
No secret there. I just ran it on my testbox here to see what happens when. The only thing that is confusing is that it gives the following error