Viewing 15 posts - 3,646 through 3,660 (of 7,429 total)
Ok then how about a secound table with the PK value from the primary table when archived. Call it of course archived and when the user places a value in...
January 8, 2003 at 3:53 am
I see it now.
As ANdy states in the first it is a char compare not datetime. I forget this sometimes myself. In simple terms look at it this way.
You output...
January 8, 2003 at 3:50 am
Close EM and reopen, or try restarting SQL Server and see if problem persists.
January 7, 2003 at 4:21 pm
One thing to also keep in mind with Compound keys make sure when the index is created the most unique value column is listed first as the stats are based...
January 7, 2003 at 3:17 pm
Actually order of tables does not always work like you would assume. I find the joins faster when you start from the least resultset size to the larger since you...
January 7, 2003 at 3:13 pm
In the case of SQL 7 you will use @@IDENTITY as soon as the insert occurrs in your SP. However it may stil be affected by a later INSERT if...
January 7, 2003 at 3:03 pm
First what driver are you using to talk to SQL Server from mainframe thru COBOL as this will have berring on what you can do?
January 7, 2003 at 3:00 pm
Sorry here but, Steve did we have a wee bit too much of the nip for lunch today. As long as runs every Sunday then you will not have to...
January 7, 2003 at 2:57 pm
Why not pull the process within SP B into SP A so that you don't have to deal with this. Not sure if it will work but it may be...
January 7, 2003 at 2:53 pm
I guess that is more of a misconception than not. It is actually minimal logging that occurrs on some things such as Truncate Table and depending on your Recover Model...
January 7, 2003 at 2:42 pm
You could also do
WHERE convert(char,dates,101) BETWEEN '12/01/02' AND '12/31/02'
As for which is faster, it seems between is but when you look at the Execution Plan it reads back as "dates...
January 7, 2003 at 2:33 pm
Sorry no formual needed. If you are going to delete all records at one time then just do a
TRUNCATE TABLE and it will not log that much.
If you are...
January 7, 2003 at 11:52 am
I have never seen anything like this particularly. The names come from sysprocesses and those names are translated from the connecting machine. Odds are someone has a naming convention where...
January 7, 2003 at 9:13 am
The checkpoitn will not occurr until the operation completes or rolls back. So it will but only when done.
January 7, 2003 at 9:08 am
Because of this
update (@TableName)
you cannot substitute a table name in TSQL this way and thus it fails.
If the second failed then would have to have the error message to...
January 7, 2003 at 8:47 am
Viewing 15 posts - 3,646 through 3,660 (of 7,429 total)