Hi Sori, but how is possible to open a DBF file with MSDE. The server MSDE is already instaled, but I d'ont know how atache the Teste.mdb file? Is necessary to run same script? Please urgent. H.S. ...more >>

How can I setup backups with MSDE? I have the DBAMGR2 but don't know how to set up backups for it. What is the best strategy. The people who are using it with my app have a tape backup on the machine, but I'm not sure how to set up backups. And they are not super users or anything. Wha...more >>

Q1. I have to create a table with new schema which has 10 billion rows. Which is faster? method 1: select ...... into alter table NEW alter column c1 char(5) NOT NULL alter table NEW alter column c2 char(5) NOT NULL alter table NEW alter column c3 char(5) NOT NULL ... alter table ...more >>

Hi, I've a SQl 2000 Standard Editon on 2K Server. I've a VB program that run locally. Recently I got Timeout probelm where the command timeout = 90. Then I tried on other PC to call reomtely. It's worked fine. Is there any differences for SQL to react on local and remote query and update. ...more >>

Greetings, here's my table --DROP TABLE Tbl2toe CREATE TABLE Tbl2toe (ThisID int IDENTITY(1,1), NameID int, myName varchar(20), myPhone varchar(20)) INSERT INTO Tbl2toe (NameID, myName, myPhone) VALUES (1,'Droof', '233-2223') INSERT INTO Tbl2toe (NameID, myName, myPhone) V...more >>

Hello, I am using a cursor but getting my results doubled, Trippled etc.. DECLARE some_cursor CURSOR FOR SELECT C1S, C2S, FROM SomeTable WHERE OST= @OST -- this has some value OPEN some_cursor FETCH NEXT FROM some_cursor WHILE @@FETCH_STATUS = 0 BEGIN Insert TargetTable(C1...more >>

Hi All, I would like to use the smallint as the primary key for some tables which is enough. Is there any impact for the performance issues? If compare with integer fields? Will it be slower when I use it as the primary key? Thanks and Regards Alex ...more >>

Could anyone help me with this Please. I want to write an SQL statement in VB. A user enters a start date using inputbox. Sql statement searches database with two fields, BeginField and EndField. If date entered by the user exist within the range BeginField and EndField, prompt user(Dates not a...more >>

I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

I am trying to compile the sample program genwin.sqc, using nsqlprep which is used to precompile embedded sql in C. I am getting weird errors and that is because windows.h is included in the genwin.sqc file. I am using Setting the lib and include path: set INCLUDE=C:\Program Files\Microso...more >>

How can I start a SQL Server loca user group (community) that is recognized by MicroSoft? -- TIA Roji. P. Thomas ...more >>

Hi, I have used "SELECT * FROM INFORMATION_SCHEMA.SCHEMATAS" to give me the names of all databases on the SQL-server. The problem is that I just realized that the list is not allways complete. I have 30+ databases and there are 6 or 7 who is missing. I have seen this happen from different com...more >>

is the collation of the field effective when i use the nvarchar for the field as the datatype. sorting properties may be still effective but the charakter set? i can't understand exactly what happens when i use the nvharchar although i use it successfuly. i need any description about this poi...more >>

Hi, I have added a field to the Customers table called TotalValue with a type of Currency. I want to populate this field with the total value of all sales to that customer, so I tried this: UPDATE Customers SET TotalValue = ( SELECT SUM( Quantity * UnitPrice * ( 1 - Discount ) ) FROM O...more >>

We have an application where we create two databases in SQL Server. The data is seperated for a reason, however, there are some stored procedures that need to reference the other database for some business rules. Lets say I have DB_ONE and DB_TWO. In a stored procedure in database DB_ONE ...more >>

I am having a difficult time accomplishing the following. I have a text file that contains fields containing dates with and without the time stamp. ie; 1/12/2003 1/12/2003 12:30:00 AM 11/1/2003 11/1/2003 12:01:00 PM etc. I am trying to import the text file using DTS, but it will only ...more >>

I read a comment someone made that it is better to use a stored procedure thans a T-sql if possible, to this end im trying to write a stored prodedure to create a recordset from several tables, is it possibel t 1. create two temporary tables from two different select statments 2. join the two ta...more >>

I have a database that is being replicated to a server. I am finding that some UDFs are running very slow in the replicated version of the database. If I run the same query against a non-replicated version of the database on the SAME server, the query runs quite fast - 3 seconds compared to 59 s...more >>

I have numerous datetime fields that are times when something was done. I would like to convert these to smalldatetime but can't because SQL has put in 1/1/1900 or whatever it uses for a date if nothing is specified and whatever date that is is apparently outside the smalldatetime range. How c...more >>

I'm would like to import records I select with a SELECT from one database to another but maintain the identity column values. I've read where I can do this by setting IDENTITY_INSERT ON. From the Import wizard on the enterprise manager, I am selecting 'import using a query', then specifying: ...more >>

hello, is there a way to reset @@rowcount to zero if I have multiple inserts one after another I can't rely on @@rowcount because it does not always reflect the last insert if one of inserts fails then the @@rowcount keeps its value from the previous Insert Am I wrong?? SAM ...more >>

Hello, How do I know that an Insert has succeeded? Should I check both @@rowcount and @@Error like if @@rowcount <>0 and @@Error <>0 or what Does an If statement affect the @@RowCount or the @Error during the check. I know it could effect afterwards? because set @error = @@Error a...more >>

Which are the correct service packs for SQL Server 2000 Developer Edition? ...more >>

Hello, I have on SP that calls another ChildSP What is your recommendation on: having a Tran in ChildSP or just send back an error and rollback in Parent SP What happens if I have a Tran in ChildSP and I roll it back does Trans in ChildSP Bubble up to Parent SPs and then what?? Al...more >>

Hello, I have one table (TableC) that has one row and one column to supply couple of tables an Id Table 1 1 3 4 5 8 9 Table2 2 6 7 10 etc... What happens when multiple users are using the system What happens if one transaction is rolledback so by the time I get the ne...more >>

I have a table that contains about 450K records that represents sales leads. Within this table there are a set of columns (26 to be exact) that indicate the industry the lead is in. For eaxample, lets say: A = Transportation B = Telecommunications C = Utility .. .. .. Z = Other This ...more >>

I have a computer setup next to a receipt printer. I want the query results to print directly to the receipt printer. i have asp pages that take the input from the users, but at the end of their transaction, i want to print a report (receipt). Thanks...more >>

Dear All, Having just had this little gotcha seared into my memory, ( within 5 minutes of causing a $10k/minute shutdown ), I thought I'd post a refresher, as it is not recently in any archives that I can see. isnumeric('.') = 1 yet cast( '.' as int ) errors isnumeric(',') = 1 ...more >>

I am designing some tables for an application and I have an instance where I have a many to many relationship between two tables. I have an EMPLOYEE table and a BENEFIT table. Each EMPLOYEE can have more than 1 benefit and each BENEFIT can be held by more than one EMPLOYEE. I know I need to...more >>

Hi there. I have a problem with my sql statement. The data refers to an electronic answering form. People are asked questions "KANT_KRIT_ID" and their answers are stored in "KANT_ANTWORT". Now I would like to sort out those people that answered 1 for question KANT_KRIT_ID=1 and at the same tim...more >>

Hi Everybody, I'm joining four tables in a Stored Procedure and returning a result based on an input parameter passed in from ADO.NET's OLEDB provider. My question is.... Would it be more efficient to join the tables ahead of time in a View instead and then call the View from the Stored P...more >>

I have a column in the following select startement called displayvalue. Displayvalue is a varchar column. Primary everything entered into this column is numeric, but there are times when NR is entered. In the select query if it sees NR, I would like to have NR changed in the resultset t...more >>

Hai all, I'm working on a project that has around 25 tables of which around 10 tables contains 4 million records. All are culstered indexed. When we issue a select query that joins these tables (at a time 4 0r 5 joins),it creates locks in the database or sometimes it will take too long a ti...more >>

Hi...we recently ran a simple query "select * from tableA where columnA is null". ColumnA was not null, but instead a byte (''). But the query still returned records where ColumnA = ''. The ANSI NULL option for the database is not checked. Am I missing something in comparisons of null valu...more >>

I'm trying to remember how I use to place ' in my strings so they were picked up set @WhereClause = ' where ap_basicmodel = '823' '. I've tried the''' and the " ' " but ??? TIA -- Stephen Russell S.R. & Associates Memphis TN 901.246-0159 Steve says get rid of the notat_ to send hi...more >>

Just getting dirty w/ relations for the first time. I hit a rad block already. Consider these tables Prod_Main [ ProdId(pk) ] Prod_Accessories [ ProdId(fk) ][ AccId(fk) ] so, a basic 1-many relationship, right? Is this what is called a "self referencing table"? Now conside...more >>

I have column name called SendToQIP/ERS, and I'm trying to ADD DEFAULT to column like this ALTER TABLE tblQuality /* sets default to 0 (zero) * ADD CONSTRAINT Def_SendToQIP/ER DEFAULT '0 FOR SendToQIP/ERS This was an ACCESS Database file once before and naming conventions are not good. My e...more >>

I have a few questions I donnot know exact answer.Can someone help explain ? (1) What are some common causes of Unavailability for a SQL database ? (2) What is Perfmon ? Where can I find more info about it? (3) In a multi-user or multi-threaded SQL environment what issues may arise? Than...more >>

I'm trying to write a vbscript that connects to an oracle stored procedure and then sends two variables to the stored procedure. I'm connecting to the oracle database via ADO. Can anyone share sample code that would demonstrate connecting to the SP and then sending it two variables from th...more >>

Hi all, I have a table which resembles the following: Dept VP Director Manager Marketing Smith Smith Jones HR Thompson Haskins Packard IT Johns Peterson Jones And I need to somehow combine VP, Director, and Manager to get one un...more >>

Is there an SP that will show you table size as far as allocated and data similar to the sp_spaceused for dbs? Thanks in advance Offey...more >>

I have a VB application that I do a select statement to return a table (it is actually only one row that is being returned). This process takes about 30 seconds. Would it be faster to create a function that returns a table that does the same thing as the select statement? Aren't functions "com...more >>

How can extract only records from a table where the value of a field equals to its default? I mean something like select field1, field2 from table where field1 = defaultValue(field1) I have used user defined functions as default value, so if I query information_schema.columns ...more >>

I am begining to look at learning more about analyzing our servers performance. Understanding the profiler is a little overwhelming. For now I want to find poor performing queries which are all views now. Can I somehow set up profiler to track performance on all views ran from a datab...more >>

Hi, is exists some feature in SQL Server se rownum in Oracle.? I do not want identity, I need select XX, YYY, rownum from dual transform to SQL server want to do it in one select not procedure ... T. ...more >>

Here's the procedure: CREATE PROCEDURE proc @id varchar(50),@acct_num varchar(10) OUTPUT,@no_go int OUTPUT AS SET NOCOUNT ON SET @acct_num = '00' + @id SELECT first_name,last_name FROM $table WHERE account_number = @acct_num IF @@ROWCOUNT = 0 BEGIN SET @no_go = 1 RETURN END ELSE BEGI...more >>

I have a series of about 30 queries that need to be run. The where criteria contains many warehouse locations and status codes. Rather that repeat the code 30 times, I would like to place it in two vaiables and reference the variables in the where clause. I have tried using double and singl...more >>

I have some values that I need to convert a varring number of spaces between words and letters to one space. Is there a way to do this other than running an update similar to the following until no more rows are updated? Update tblX Set colX = replace(colX, ' ', ' ') Thanks much Carl ...more >>

I have an Access 2002 database running off SQL 2K advance server back end. Within this database I need to have column A (example column or field A) upon selection of a specific criteria have column B or field B become a automatically filled column with whatever criteria I specify. Basically making...more >>

Hello everyone, I have a field value like this: "RQ1234LN1". It comes from my receipts table and makes reference to the requisition on which that part appears and the line number. Is there a way to extract the numbers between "RQ" and "LN" and to extract the numbers following "LN"? The al...more >>