Home > Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.
SQL Server error 80040e21 with browser Mozilla only
Hi, I developed a report tool which is working fine but a user got an error by using Mozilla FireFox browser. The error is: Microsoft OLE DB Provider for SQL Servererror '80040e21' Invalid character value for cast specification. The erro...
Hi, I developed a report tool which is working fine but a user got an error by using Mozilla FireFox browser. The error is: Microsoft OLE DB Provider for SQL Servererror '80040e21' Invalid character value for cast specification. The erro...
answer(1) view(188) status(
)
)
delete a field help?
I have a user who has submitted a survey twice, and I have to delete the second entry. But every user has a UserID and the data for the second submission has the same UserID (the only thing different is the fact she submitted data 5 seconds...
I have a user who has submitted a survey twice, and I have to delete the second entry. But every user has a UserID and the data for the second submission has the same UserID (the only thing different is the fact she submitted data 5 seconds...
answer(1) view(849) status()
)
Code Help
I am trying to figure out how to remove the ?00?from in front of a number, for example ?0012345678? I just want ?2345678? The table I have contains about 5000 row and all of the number start with ?00? I do not know what sql to use. Can s...
I am trying to figure out how to remove the ?00?from in front of a number, for example ?0012345678? I just want ?2345678? The table I have contains about 5000 row and all of the number start with ?00? I do not know what sql to use. Can s...
answer(1) view(863) status()
)
multiple left joins help?
Could somebody tell me what is the secret of being able to write a SELECT statement having mulitple LEFT or RIGHT joins, I seem to get in trouble as soon as I add the second LEFT join, as I am obviously doing it wrong. These are my tables...
Could somebody tell me what is the secret of being able to write a SELECT statement having mulitple LEFT or RIGHT joins, I seem to get in trouble as soon as I add the second LEFT join, as I am obviously doing it wrong. These are my tables...
answer(1) view(473) status()
)
SQL SERVER 7.0 Group by Problem w/ +1000 records
I have an application tool that has sql server 7.0 on the back end. the tool creates reports after querying the db. Right now It is having problems with a group by sql query that is selecting 4 fields, then grouping by those 4 fields alon...
I have an application tool that has sql server 7.0 on the back end. the tool creates reports after querying the db. Right now It is having problems with a group by sql query that is selecting 4 fields, then grouping by those 4 fields alon...
answer(1) view(873) status()
)
Urgent help needed.
Hi there, Can anyone help me out of my misery? This SQL statement does not work and i don't know how to fix it: "Select top 50 SID, count(Criteria) as A from ScoreResults where Criteria = -1 and ScoreResults.ID in (Select ID from Pl...
Hi there, Can anyone help me out of my misery? This SQL statement does not work and i don't know how to fix it: "Select top 50 SID, count(Criteria) as A from ScoreResults where Criteria = -1 and ScoreResults.ID in (Select ID from Pl...
answer(1) view(385) status()
)
Select Distinct
If I am returning more than one colimn, do I have to do a select distinct on every column? How can I output only unique records? Thanks
If I am returning more than one colimn, do I have to do a select distinct on every column? How can I output only unique records? Thanks
answer(3) view(357) status()
)
Write an email reminder/email scheduling procedure help?
I need to be able to send a reminder to my users who have not submitted data by a certain date,on the other hand need to be able to send data once gathered to a person analaysing it. I have strongly been advised to write a procedure for an...
I need to be able to send a reminder to my users who have not submitted data by a certain date,on the other hand need to be able to send data once gathered to a person analaysing it. I have strongly been advised to write a procedure for an...
answer(12) view(383) status()
)
NOLOCK and SQL Server... Perfect together?
I'm using NOLOCK on some search queries... some times I get this error message throught the day. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement Is there anything I should lookup...
I'm using NOLOCK on some search queries... some times I get this error message throught the day. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement Is there anything I should lookup...
answer(4) view(760) status()
)
Sub Query column problem
Hi I was wondering if anybody could help me out here. This is for an App in ASP(classic) and MS SQL A Quick explanation... I have 3 tables called ADMIN_SUB, ADMIN & STAFF. What I want to do is depending on a particular row value ...
Hi I was wondering if anybody could help me out here. This is for an App in ASP(classic) and MS SQL A Quick explanation... I have 3 tables called ADMIN_SUB, ADMIN & STAFF. What I want to do is depending on a particular row value ...
answer(1) view(276) status()
)
View over multiple databases
i have 2 databases (on 1 instance of sql server) i would like a view in database A bases on data in database B 1) is this possible ? 2) if yes, how do i do this ? 3) how are permissions and user involved ?
i have 2 databases (on 1 instance of sql server) i would like a view in database A bases on data in database B 1) is this possible ? 2) if yes, how do i do this ? 3) how are permissions and user involved ?
answer(1) view(381) status()
)
Updating image datatype
i have to update a field in table1 which is of image datatype with a field of table2 which is of the same type.problem is that the update stmt. doesn't work for these data types.neither can we create temp. variables. i tried retreiving th...
i have to update a field in table1 which is of image datatype with a field of table2 which is of the same type.problem is that the update stmt. doesn't work for these data types.neither can we create temp. variables. i tried retreiving th...
answer(1) view(231) status()
)
Calculation errors or MS bug in recursive functions ??
are there know problems with calculation errors in recursive function in sql server 2000 ? if not, please point out the error in the following: PHP Code: CREATE FUNCTION dbo.func_RecVerkoopprijs_bas...
are there know problems with calculation errors in recursive function in sql server 2000 ? if not, please point out the error in the following: PHP Code: CREATE FUNCTION dbo.func_RecVerkoopprijs_bas...
answer(0) view(297) status()
)
Query works in MS Access but not MS SQL Server
Code: strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName, orders.ordAuthNumber, orders.ordDate, orders.ordEmail, Last(status.Status) AS Status, Last(orderStatus.statPublic) AS statPublic FROM orderStat...
Code: strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName, orders.ordAuthNumber, orders.ordDate, orders.ordEmail, Last(status.Status) AS Status, Last(orderStatus.statPublic) AS statPublic FROM orderStat...
answer(4) view(230) status()
)
Sql locking tables on a select cause
Using Microsoft SQL Server 2000 over ODBC, I have a script wherein I am running into a locking problem. Here's what I'm doing, in pseudocode: Code: query = "SELECT keyCol1, col2 FROM t1"; dbConnection1....
Using Microsoft SQL Server 2000 over ODBC, I have a script wherein I am running into a locking problem. Here's what I'm doing, in pseudocode: Code: query = "SELECT keyCol1, col2 FROM t1"; dbConnection1....
answer(2) view(734) status()
)
MSSQL (b)locking problem
I just want to clarify the following I obtained from a source. Is this true regarding MSS ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~ "When using MSSQL a (b)locking problem can arise. When 1 user locks a row in a ...
I just want to clarify the following I obtained from a source. Is this true regarding MSS ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~ "When using MSSQL a (b)locking problem can arise. When 1 user locks a row in a ...
answer(6) view(49) status()
)
updating a field with an auto-seed
Hello I have a table with 300 records in it. I have a field called Loc_ID that will be my primary key. There are other fields in the table that have data in them. Since my table is already in alpha order, is there a way I can update...
Hello I have a table with 300 records in it. I have a field called Loc_ID that will be my primary key. There are other fields in the table that have data in them. Since my table is already in alpha order, is there a way I can update...
answer(3) view(789) status()
)
What does <> mean?
What does <> mean in an SQL statement, I've tried seach engines for an answer but get nothing. I'm stumped.
What does <> mean in an SQL statement, I've tried seach engines for an answer but get nothing. I'm stumped.
answer(2) view(379) status()
)
ASP not getting return value
I have a stored procedure like this: Code: BEGIN TRANSACTION update ............. Select @ErrorCode = @@Error If @ErrorCode = 0 COMMIT TRANSACTION Else ROLLBACK TRANSACTION return @ErrorCode The update s...
I have a stored procedure like this: Code: BEGIN TRANSACTION update ............. Select @ErrorCode = @@Error If @ErrorCode = 0 COMMIT TRANSACTION Else ROLLBACK TRANSACTION return @ErrorCode The update s...
answer(2) view(314) status()
)
sql stmt - urgent
hi everybody, as i need to display a list of departments, i want the word 'OTHERS' to b listed either top or bottom of the drop down list? isit possible?? as now my list is in alphabet order. I m using asp for my programming pls give me ...
hi everybody, as i need to display a list of departments, i want the word 'OTHERS' to b listed either top or bottom of the drop down list? isit possible?? as now my list is in alphabet order. I m using asp for my programming pls give me ...
answer(1) view(99) status()
)
Link request
Hi there, Does anyone have any website links related to SQL Server 2000 table relationships? I can't get my 1-n relationship to work properly plz help, thanks in advanceeeeeeeeee!!!! - SevenTh
Hi there, Does anyone have any website links related to SQL Server 2000 table relationships? I can't get my 1-n relationship to work properly plz help, thanks in advanceeeeeeeeee!!!! - SevenTh
answer(1) view(562) status()
)
SQL Server, Access or MSDE???
Hi folks. I've ecently buid an application with an Access database as data provider. Recently i had some performance problems, so i upsized it to SQL server. The problem is that it is to big for small businesses, so MSDE should be a good ...
Hi folks. I've ecently buid an application with an Access database as data provider. Recently i had some performance problems, so i upsized it to SQL server. The problem is that it is to big for small businesses, so MSDE should be a good ...
answer(1) view(735) status()
)
NT Authentication/SQL Srvr Auth
Is it possible to use NT Authentication on Database abc most of the time but use SQl server authentication from an ISQL command in a bat file? (I'm trying to avoid having the scheduling system that submits the batch file for execution havin...
Is it possible to use NT Authentication on Database abc most of the time but use SQl server authentication from an ISQL command in a bat file? (I'm trying to avoid having the scheduling system that submits the batch file for execution havin...
answer(1) view(593) status()
)
moved site and asp now pages show sql records twiceTWICE !!
Hey, We've just moved our site from a Win 2000 server to Win 2003. Some of the pages on the site pick up data from a couple of sql d/bs. Pages that display data from d/bA are fine - BUT - pages that use d/bB now display each record twic...
Hey, We've just moved our site from a Win 2000 server to Win 2003. Some of the pages on the site pick up data from a couple of sql d/bs. Pages that display data from d/bA are fine - BUT - pages that use d/bB now display each record twic...
answer(5) view(97) status()
)
Safest way to connect to DB ?
I have created a site with asp.net (vb.net) and sql server. For the moment I just use simpel sqlconnections, but I want to know what the safest way is. I heard about UDL, but that's not for SQL. Does anyone know the safest way ?
I have created a site with asp.net (vb.net) and sql server. For the moment I just use simpel sqlconnections, but I want to know what the safest way is. I heard about UDL, but that's not for SQL. Does anyone know the safest way ?
answer(1) view(574) status()
)
URGENT Help with SQL Server/IIS problem
Ok, heres the story I have a huge web application that I am trying to deploy Application 1 resides on same machine as sql Server Sql Server 2003 running IIS6.0 Application 2 resides on same machine as sql Server Sql Server 2003 ru...
Ok, heres the story I have a huge web application that I am trying to deploy Application 1 resides on same machine as sql Server Sql Server 2003 running IIS6.0 Application 2 resides on same machine as sql Server Sql Server 2003 ru...
answer(4) view(701) status()
)
scheduled updates
I'm going to have a large database, and I can't have 1000 people online at once all of them asking the database how many people are online and such... how can I have SQL server once every minute ro two run the stored procedure to count th...
I'm going to have a large database, and I can't have 1000 people online at once all of them asking the database how many people are online and such... how can I have SQL server once every minute ro two run the stored procedure to count th...
answer(1) view(28) status()
)
executing SQL from ASP.
Hi all, I have been stuck on ths issue for over a week. Here goes I have created a website using ASP and SQLServer. Users are all able to execute STored procedures on the site but as soon as they try to execute SQL from a ASP page they ge...
Hi all, I have been stuck on ths issue for over a week. Here goes I have created a website using ASP and SQLServer. Users are all able to execute STored procedures on the site but as soon as they try to execute SQL from a ASP page they ge...
answer(9) view(40) status()
)
SQL need halp.....
if i do not want to use MAX(score) what else can i use to look for max score? SELECT Name, MAX(Score) FROM MyClass
if i do not want to use MAX(score) what else can i use to look for max score? SELECT Name, MAX(Score) FROM MyClass
answer(2) view(745) status()
)
Asp/ado
I am a newbe to ASP and ADO. I am having a problem with an inner join SQL select statement. This is the eror: Error Type: Microsoft VBScript compilation (0x800A0409) Unterminated string constant /includes/navigation6.asp, line 10,...
I am a newbe to ASP and ADO. I am having a problem with an inner join SQL select statement. This is the eror: Error Type: Microsoft VBScript compilation (0x800A0409) Unterminated string constant /includes/navigation6.asp, line 10,...
answer(2) view(564) status()
)
Programming
Related Pages
- Syntax Join Error
- Limiting View To Distinct Records
- DTS package
- Login.asp page not responsing.
- SQL Server Authentication
- [General] Asp and sql,formatdate problem
- SQL server creates 2 records for a single insert SQL query
- SQL search statement Syntax
- How to truncate while doing "insert into"
- Connect to MSSQL db = SSL error ????
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved