Viewing 15 posts - 136 through 150 (of 163 total)
quote:
Also, there is a problem in SQL Server with identity column when recovering from crashes. This has existed in SQL Server...
July 14, 2003 at 12:07 pm
You can try this if you want a cross tab like result
Select
Sum(Case Region When 1 Then (xvalues) Else 0 End) As Region1,
Sum(Case Region When 2 Then (xvalues) Else 0...
July 14, 2003 at 11:28 am
Is this what you want?
Select region, sum(salesAmt) from MySalesTables
Group By region
Compute SUM(SUM(SalesAmt))
One word of warning.
If you are using the result for client side usage. you may get an error....
July 13, 2003 at 3:01 am
I think this topic is answered already in another thread.
However please use this script and run
http://www.sqlservercentral.com/scripts/contributions/458.asp
After storing the script from query analyser run
sp_Compare2Tables Table1, Table2
If you are using...
July 13, 2003 at 2:47 am
Good article.
Some more things could be elaborated more.
Surrogate key is another issue.
Why we need another key, etc. may be another very usefull
Preethi
G.R. Preethiviraj Kulasingham
July 13, 2003 at 2:33 am
quote:
TABLE OWNER, ‘DBO’3. Table owner will be ‘dbo’ by default. Applications and queries must specify ‘dbo’ as the owner of...
July 9, 2003 at 9:25 pm
quote:
Select credcardno, ccname, Count(*) from findets Group by credcardno, ccname
Please check whether you have proper indexes. I suggest you to on credcardno
July 3, 2003 at 9:54 pm
quote:
Update syscolumns Set Colstat=0 Where id = object_id(<your table Name>) and name =<Identity Column Name>
July 3, 2003 at 9:44 pm
Why don't you try to get the distinct entries first
Select credcardno, ccname, Count(*) from findets Group by credcardno, ccname
Please check whether you have proper indexes. I suggest you to on...
July 3, 2003 at 7:33 am
Try this:
Update syscolumns Set Colstat=0 Where id = object_id(<your table Name>) and name =(,Identity Column Name>)
Warning: Microsoft does not recommend directly modifying the system tables
July 3, 2003 at 7:23 am
there are a few scripts available at SQLServerCentral.com
try one (It is mine so that I may help you)
http://www.sqlservercentral.com/scripts/contributions/221.asp
There are a few other scripts as well. Please try some...
July 3, 2003 at 7:16 am
1. identity columns can't have null values
2. To change an identity column into another one add another column with same data type, update the new columns value and remove the...
June 27, 2003 at 10:03 pm
In most of the cases I handle this type of situation from the client.
If you use ADO connection to connect to the database It has a Commandtimeout property
You can set...
June 27, 2003 at 6:03 am
--Try this Procedure
Create Procedure CreateTable (@Table sysname, @Target sysname, @Condition varchar(1000))
As
Declare @SQL varchar(8000)
Select @SQL =''
Select @SQL = @SQL +', '+
Case
when AutoVal is NOT NULL then 'cONVERT(int, ' +...
June 19, 2003 at 12:57 am
I use a different method.
I use one temporary table with an additional field (Session_ID)
This Session ID isgenerated by the application.
June 17, 2003 at 6:25 am
Viewing 15 posts - 136 through 150 (of 163 total)