Viewing 15 posts - 31 through 45 (of 100 total)
#1 - You need to figure out why it is erroring, and code the trigger to handle it without generating that error. Otherwise the error will cause the implicit...
April 8, 2003 at 2:55 pm
The output file can be anything you want - it doesn't have to end with ".out". You also don't even need to specify an output file. Without one,...
April 8, 2003 at 2:41 pm
I know BOL says that only one set of double quotes are allowed, but I just tested it with two sets and it worked fine. Here's what I tested:
...
April 7, 2003 at 6:19 pm
I don't know a lot about ASP, but why not break the process down into smaller chunks, with one form per entity (driver, passenger, vehicle, etc.) For example, you've...
April 6, 2003 at 6:24 pm
I don't understand your comment "if someone goes back and edits an NAV from several weeks ago - I need to change ALL the performances from that time forward." ...
April 3, 2003 at 11:31 pm
I don't understand your question. If you mean how to resolve conflicts, use the Replication Conflict Viewer utility. Right-click on the database in EM and choose All Tasks...
April 2, 2003 at 9:32 pm
Chris's solution works just fine. Maybe you didn't understand how to use it. The entire sequence you are looking for would be:
--1st chunk of 25000 rows
select top 25000...
April 2, 2003 at 9:23 pm
DELETE tblCLTestScoresTEMP
FROM tblCLTestScoresTEMP CL LEFT outer join student_data_Main SD
ON CL.Permnum=SD.Permnum WHERE SD.permnum IS null
Jay Madren
April 2, 2003 at 12:20 pm
Yes, the AND works with IN. What racosta was getting at is even though each criteria (predicate) returns records on its own, there are obviously no records that satisfy...
April 1, 2003 at 2:23 pm
The CASE statement can only return expressions, not execute statements. It is intended to be used to return a value within a SELECT list. The IF..ELSE statement is...
March 31, 2003 at 4:44 pm
Actually, in ASCII 13 is carriage return, and 10 is new line (or line feed). They're usually paired together, but have seen some systems/files use only one or the...
March 27, 2003 at 12:26 pm
Another thing to note: The method I just posted compares the vaules as text strings. Don't use this method with between or < & > comparisons. Just use...
March 26, 2003 at 3:45 pm
Cheddar's suggestion of CONVERT(VARCHAR, @date, 111) will do what you want. The statement would be:
SELECT * from table
WHERE CONVERT(VARCHAR, when_dt, 101) = '03/26/2003'
I changed the style parameter to 101...
March 26, 2003 at 3:40 pm
The interpretation of '03/02/2003' depends on your server language settings. BOL say to use yyyymmdd format to ensure the same interpretation across all languages.
Jay Madren
March 26, 2003 at 2:46 pm
It's not the SQL Server Agent that needs restarting. It's the merge replication agent, which is started by a job. To have the merge agent restart (or rerun)...
March 26, 2003 at 8:27 am
Viewing 15 posts - 31 through 45 (of 100 total)