Viewing 15 posts - 31 through 45 (of 177 total)
quote:
In particular, I don't think you can use a table variable in an INTO clause of a SELECT statement.
December 31, 2003 at 4:22 pm
I just did the same with Access 2003 (don't have Access 2000). It worked perfectly for me.
December 31, 2003 at 4:10 pm
quote:
dbo is the owner of both the view and the table. The logged in user only has update permissions on the...
December 31, 2003 at 11:13 am
quote:
Does putting SET CONCAT_NULL_YIELDS_NULL ON at the begining of the query set the value for that query only? Or, will it...
December 30, 2003 at 7:59 pm
What kind of activity has been going on on your database?
In any case, 2 days is a pretty long time between transaction dumps. I would recommend that you dump...
December 30, 2003 at 7:46 pm
I'm not sure what your question is. Are you saying that you want the sum to be rounded to an integer? You can use cast or convert:
select cast(sum(x)...
December 30, 2003 at 12:05 pm
quote:
It is ODBC and OLEDB which by default change the connection’s setting to ON. If you are counting on this behavior, you...
December 30, 2003 at 10:44 am
quote:
We use a table named LNUs (LastNumbersUsed) with an integer value for LNU. There is a trigger on the table to update...
December 30, 2003 at 10:38 am
As this is one statement, there's no need to use any explicit transactions.
That's true. But the calling procedure generally has lots of statements, one...
December 30, 2003 at 10:36 am
As this is one statement, there's no need to use any explicit transactions.
That's true. But the calling procedure generally has lots of statements, one...
December 30, 2003 at 10:36 am
quote:
Can anyone shed any more light on this and maybe let me know if you allow dirty reads at your company?...
December 30, 2003 at 10:33 am
You probably want to take a full backup, switch to simple recovery, run the job, switch back to full recovery and then take another full backup. All of this...
December 30, 2003 at 8:08 am
quote:
yes u r right abt profiler.but we had a problem with a user .he says he did not login yesterday at...
December 30, 2003 at 8:03 am
quote:
jxflagg, could you show me how to use temp table and update lock?
Not a...
December 30, 2003 at 8:00 am
quote:
so you r saying there is no system table/proc to query, right?
Noeld is correct....
December 29, 2003 at 8:16 pm
Viewing 15 posts - 31 through 45 (of 177 total)