please provide me the equivalent statement which is written in SQL7.0 to SQL6.5
The statment in 7.0 is
set @combined = @combined + ','
set @actualins = @actualins + @combined
The variables ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10266861.html
Zones:
MS SQL ServerDate Answered: 01/29/2000 Rating: 7.8 Views: 0
I have the followng SP :
Alter Procedure AddEntry
@lname varchar(255),@fname varchar(255),@session numeric,@sex char(1), @title varchar(255) ,@email varchar(255),@phone varchar(255),@day varcha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20242883.html
Zones:
MS SQL ServerDate Answered: 12/06/2001 Rating: 7.0 Views: 0
I have a stored proc.
CREATE PROCEDURE getMachineCalcExpr
@AVal float,
@BVal float,
@CVal float,
@DVal float,
@EVal float,
@FVal floa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20306551.html
Zones:
MS SQL ServerDate Answered: 05/31/2002 Rating: 9.8 Views: 0
I used tomcat as servlet container and connect to a MSSQL DB.
When query using servlet, the result returns null.
If
Data type = nvarchar, result returns null.
Data type = varchar, result r...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20366717.html
Zones:
Java,
ServletsDate Answered: 10/14/2002 Rating: 6.8 Views: 0
I have 2 varchar2(4000) variables that I am concatenating. I want to store that value in a clob variable. How can I do this. Below is what I've tried
declare
myclob clob;
var1 va...
http://www.experts-exchange.com/Database/Oracle/Q_20381599.html
Zones:
OracleDate Answered: 10/28/2002 Rating: 9.0 Views: 0
Is there a simple way of making varchar fields longer, i have a table with over 1 million records in it, and i need to lengthen 2 of the fields, problem being i have found that the server can't han...
http://www.experts-exchange.com/Database/Interbase_Firebird/Q_20677614.html
Hi,
I'm currently trying to extract part of postcode data to do searches on customer location. The postcode data in my database is in the form of a varchar and is in the foramt "345 34". What ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20692239.html
Zones:
MS SQL ServerDate Answered: 07/28/2003 Rating: 9.0 Views: 0
I have a store proc. that makes a series of inserts. I need to know how I can return a varChar string back to my ASP page for processing. The store proc. will insert new records and append the iden...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20863339.html
Zones:
MS SQL ServerDate Answered: 02/03/2004 Rating: 9.8 Views: 0
what isthe difference betaween char and varchar
http://www.experts-exchange.com/Database/MySQL/Q_21333112.html
Zones:
MySQL ServerDate Answered: 03/01/2005 Rating: 9.4 Views: 0
456530 C-, E+, C+, E-, P1+, M-, N+, S-, S+, K-, K+, FYA+, FYB+, JKA-, JKB+
MRN (i.e. 456530) has many values (i.e. C-, E+, C+, E-, P1+, M-, N+, S-, S+, K-, K+, FYA+, FYB+, JKA-, JKB+) in VARCHAR...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21612386.html
Zones:
MS SQL ServerDate Answered: 11/03/2005 Rating: 6.8 Views: 0
