Hi, I am getting an "8624 - Internal SQL Server Error" on SQL Server 2000 SP3 when inserting into a table which is used as the source of an indexed view. Without the indexed view being defined, the INSERTs work fine. I believe this is a bug in SQL Server. How can it be reported to Microsof...more >>

I've created a temp table with an int type field on which I am then trying to perform an AVG. I get: Server: Msg 8115, Level 16, State 2, Line 1 Any ideas?...more >>

Could someone please advise me on the syntax in Transact SQL to execute a stored procedure (that returns records) and then place the results in a temporary table Thankyou - Alastair...more >>

I have ten tables. There is an ASP web front end. This is a work order and each table represents a page of the work order. They fill out the first form which is all of the customer info. There is an identity field that autoincrements the work order number. When they are done fil...more >>

Hi all, I have some problem when selecting records starting with chinese characters in my SQL Server All records can be displayed when I type 'Select * from [Table]', But when I just want to select some chinese records and I typed 'Select * from [Table] where [Field1] like '中&#...more >>

i just came across the "intersect" function and can't get it to work. i'm familiar with "union". i've copied the example from books online and i get the following error: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation i've tried to substitute "union" with "inter...more >>

I'm trying to write/find a script that will copy all data from a table in database1 to the same table in database2. The databases are on the same server and the destination table already exists and is identical in design. I need to overwrite the destination table data if it already exists Thanks...more >>

I have been trying for some time to capture a part of a string to convert and sum a number accross my result set. The string looks like this: "abc,1 def,10 R-@@,xyz". I have been looking for a way to split the field or extract a part of it specifically "10 R-@@" but the problem lies in t...more >>

I am using VB 6.0 with SQL 8.0. I want to convert string to number one of my field in table. I am doing something like this. EMPNo is string in table, i want it to be numeric. I cannot change EMPNO field as numeric in table coz , raw data i get some of fields have PQ in front of it.. "select job...more >>

Hi all, Can somebody tell me how to use SQL server from command line (i.e. sql's command line commands) thanx and regards Manoj Singh...more >>

I'm trying to port access DB to Sql Server database. With access I can insert several rows also if someone are present in the destination table. For example if I have 20 rows in the dest table and I want to insert 30 rows from orig table to dest table, but 20 rows are present in the dest table, ...more >>

Dear All Please help me, i am using sql 7 and NT back office ver 4. my Auto shrink option was not selected hence the log file has increased by HUGE amount. i have tried with shrink database option but still it didnt worked. i am getting the following error message while restoring the bac...more >>

in my database the Auto Shrink option was not selected hence the Log file has grown into 8 GB .... Now the db cannot be restored from Backup reports error on insufficient disk space where as my disk have 30 GB of free space. Now how can i (1) reduce the log file size, (2) restore the db f...more >>

Is there a way to return "0" instead of "NULL" in a query? several columns that are from other views and are linked to a table where it returns all records from my main table. I need the NULLs to be 0s. Kole...more >>

Can we run a new program using SQL Server 2000 and an older program still running an SQL Version 7 database on the same network? We want to run both programs concurrently, but it appears that after we install SQL 2000 Client on the workstation, the SQL version 7 client can access the SQL ...more >>

While I am connecting to SQL server 2000 EE from a different client machine using Query Analyzer it gives me the following error message . Unable to connect to server > Server : MSG 18452 Level 16 state 1 [Microsoft ODBC ][SQL Server Driver][SQL server] Login failed for user '(null)...more >>

Hi All Just a quick thing can someone tell me what the format is when you want to convert the getdate() result to something like '11 Feb 2004' Thanks Phil...more >>

I have a three tables: computer, accessory, monitor Each table contains a location and value. I want to write a query that will list all records in each of the three tables in one result set. The purpose of this is so I can generate a report that will give the dollar value of computer...more >>

Hello Some replacement tables have been copied into the database therefore breaking the joins that where there I wanted to recreate the contraints on these tables, and am trying with the following SQL Code? However it does not work. ErrMsg: Incorrect syntax near the keyword 'FOREIGN ALTER TABL...more >>

Hi all, I am having problems with refrencing a table on a seperate server than the one that I am working on (if that makes any sense) I have never had this problem before. It keeps saying that it cannont find that database name in the sysdatabase table, which I know it shouldn't do as this ...more >>

In the statement below, the function name need's to be prefixed with "dbo." to work. Is there anyway to make a User Function visible without specifying the user? Meaning is there a way to make "SELECT Answer = fnPlusOne(2)" a valid statement? CREATE FUNCTION fnPlusOne( @Value int ) RETUR...more >>

i want to select distinct rows from a table... can i use like this... select distinct * from table i need all columns of the table to be retrieved.... it will be greatful if anybody can help me.. ...more >>

Table has 6 columns. One of the column say date contains date and null values. The same column I want to print in two columns as date and null headers with the values (if there is a date I want to print date as a date with date header, the null columns in a separate column with null heade...more >>

I'm running a query with a where clause that uses a "BETWEEN '1/1/04' and '1/31/04'", and I'm not getting any rows returned for Jan 31. I thought BETWEEN was inclusive? Anyone know what's going on here? ...more >>

Hi, I have a field that uses "," to separate items Eg apple, pear, orange Monday, Tuesday, Wednesday, Thursday How can I split this into columns based on where the "," appears ie. Expected Result apple pear orange Monday Tuesday Wednesday etc ...more >>

I have a multiuser application where the users will be asking to see and then update any record in a table. They will ask for the next available record in the table. They will then view the data in the record and update it with some info. My problem is: How do I prevent someone from getting...more >>

Hi All It's getting to the end of the day and there is something that I just dont seem to be able to figure out. I have a number of address Example Below 3 High Street, Chester, 4 The Main Road, Liverpool, and they have trailing comma's, is there a easy way to get rid of these. ...more >>

For the data type varchar, if I have the length set to "50" in the table design mode, what exactly does this mean? The field will hold a string of up to 50 alphanumeric characters?...more >>

I am trying to extract the binary string representation of the data pointer in a binary type column in a SQL 7 database. I can't convert this number to an int with Cast or Convert and it does not always convert the correct infromation. I have used programs such as MS query from a client ma...more >>

Error Massage: ODBC error 2812(42000)could not find stored procedure 'sp_setuser by login'. Exceute query is: USE master EXEC xp_sendmail 'SQLAdminX@NWTraders.msft', @subject = 'Query Result: Total Products', @query = 'select count(*) from northwind..products' Thanks reply. ...more >>

Hi I want to be able to find all the tables where a particular column name exists i.e Result = table names where column 'OrderNo' exists How do I do this? Thanks ...more >>

How can I find the Primary Keys for each table in a database? I tried (as suggested in an earlier post): select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE = 'PRIMARY KEY' but this doesn't give me the field names that make up the PK What should it be? ...more >>

Hi All, I have asked this question before but I am un-able to find the response that I was given. I have a selection of fileds in a table and one one the fields look's like this 4 bed, semi-detached 5 bed, terraced 2 bed, house I need to break this down into 2 fields, is there a way ...more >>

Hi I want to be able to delete the records that are selected using the following SQL SELECT AR.OrderNo FROM tblarOrder AR LEFT OUTER JOIN tblOrder FO ON AR.OrderNo = FO.OrderNo WHERE (FO.OrderNo IS NULL) ORDER BY AR.OrderNo I have tried changing SELECT to DELETE * but it ...more >>

hello sir I am using MS sql7.I am using a transaction table of having 10 columns A,B,C,D-char(15), E,F-varchar(30), G,H,I-numeric(15,3),J-datetime, each.Yearly approximtelly 15-20 lakhs of records will enter init,also index columns are there.For 2-3 years if i am keeping data like this i...more >>