Viewing 15 posts - 1 through 15 (of 66 total)
Yes, it is offhours but not in single-user mode.
Steve
August 6, 2007 at 4:05 pm
Not quite sure of what you want to do. But to return the Identity value you can you @@IDENTITY or Scopy_Identity() after your insert statement. Like this
June 21, 2007 at 8:55 am
For me, what would be interesting is people responding with their best practice to solve this situation.
Here's what I think,
The DBA receives from Development the scripts to update...
June 21, 2007 at 8:04 am
This is not to confuse the original post-er.
I ran the example above on Query Analyzer connected to SQL Server 2000 and then on the same machine Enterprise Studio connected...
December 22, 2006 at 9:36 am
Here is a sample of the two options
CREATE TABLE [dbo].[T_Money_Test] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[moneyField] [money] NULL ,
[DECField] [DECIMAL] (10,2)...
December 22, 2006 at 7:58 am
I agree Money is the way to go. Float is just trouble should be used only for Scientific data and even then maybe. It seems Microsoft put Money datatype in...
December 22, 2006 at 6:33 am
What is the application? What does the column represent?
Steve
December 21, 2006 at 12:48 pm
We are a very small shop and SQL Server 2000 is very stable. There is no compelling reason to convert. At this point - no plans - no budget. I...
July 21, 2006 at 10:16 am
Can you redefine the column to be type datetime. It makes calculations simpler.
July 19, 2006 at 3:32 pm
The article you posted although interesting is for SQL Server 2005. Is there anything like it for 2000?
Steve
July 17, 2006 at 1:44 pm
Thanks Matt... I had thought of DTS, but I would have to pass the Path and Filename from the Access Application to the DTS Package. Is there a method to...
May 11, 2006 at 6:47 am
My Colleague, who I still owe a dinner, came up with this solution (I just coded it) But we both like the previous one...
SELECT
April 28, 2006 at 2:54 pm
Yes, we were running sp3a and then add sp 4 but the problem persisted. We worked around it by using a bcp command to export the file.
Steve
April 4, 2006 at 2:33 pm
That's close but not quite what I want to do. I have a drop down where row 1 is active and should be in black and row 2 is inactive and...
February 3, 2006 at 1:05 pm
Viewing 15 posts - 1 through 15 (of 66 total)