Hello there I have two tables. Offer, Rates Offer table have primary key and the rates table have foreign key related to the Offer table When i open the query anlyser in the index list of the offers key suddenly one of the fields with index is shows at first As a result of that simple Se...more >>

what you suggest me for this situation: I maintenance flat tables with sums fields etc. that improve performance for some report. I don't want to do that on trigger. instead i want to run another thread with low priority to do it. This process is update only the flat table. There for I do...more >>

Hi, I would like to import and export a file into a ntext column using T-sql commands only (without using the textcopy.exe). In some environments the textcopy.exe produces instabilities of an Access 2000 adp frontend which is used to drive the server resulting in abrupt death of the applicatio...more >>

hi, can any one help me in this i have to format the column in a select statement like this Format(CONTRACTSCLOSED.BADLACHARGE,""0.00"") what type of function is there in sql server to format.. -- Thanks & Regards Sa ...more >>

Hi, can any one help me out in this problem.. EXEC SP_GenerateForm 'FORM6793','','',' FORMTYPE IN ('N4','UC','UD','ND','N5','U2','N2','I4','S1')OR','0', '0','','','1','','31-03-2003','31-03-2003','31-03-2003' when i execute this statement in query analyzer it gives incorrect systax near ...more >>

Is it possible (if so, how) do I write a query that tells me all tables that have a column of type MONEY - or just list all columns of type money (I can tell the table just from the column name). TIA Darin *** Sent via Developersdex http://www.developersdex.com *** Don't just participate...more >>

Hello, I have seen different types of table schemas employed in applications and I would like to get the opinions of the SQL experts... First some definitions: LU = Lookup IP = Index Person IA = Index Account Background sample info: Fred has two accounts number 9999 and 8888 Joe...more >>

I want to modify my Identity columns and primary Key of mytable and add "Not For Replication" to it. Please let me know if i could do this using Alter Table statements. Juno...more >>

Hi I'm working on a program, that uses ms sql database. I would like to get exactly what the DBCC CHECKIDENT returns: current identity. But I don't know, how to get the value using stored procedure. I used this function in Query Analizer and it works fine, but I really don't know how to use it ...more >>

In 2002 was reported a bug in SQL Server 2000 that would not allow to run a distributed query on a remote server. This bug report was posted at the following URL: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us% 3B323711 I wanted to check if the bug was fixed but I did not find...more >>

Hi, I'm trying to execute this query with adodb connection and get the following error:Incorrect syntax near 'GO' adconn.Execute(sSql) my sSql string is: USE master if not exists (select * from dbo.sysDatabases where name = 'Test') CREATE DATABASE SOLUTIONNAME ON ( NAME = 'Test...more >>

I have a "users" table, containing a list of usernames, date registered and date they were last online (active). I'm trying to find the best method to produce the following statistics: Number of distinct, active users between daterange. This poses a problem, because a single "date last onl...more >>

Hiya. I need to construct a table of Items. The data will never change. Which of the two tables is the better design for searching for a keyword like water, fish, or crater? Each has 3 columns 1: 1 Item1 box, house, mail, grass, park, water 2 Item2 wat...more >>

Hiya. I need to construct a table of keywords. Which of the three is the better design? 1: keyword1 box, house, mail, grass, park, water keyword2 water, fish, shark, wet, moss, marina keyword3 moon, crater, cold, dust, dark, space 2: keyword1 box keyword1 house keyword1...more >>