concat_ws() in mssql

hey folks, im busy trying to make my script compatible with different types of databases

so, for mysql i use the function 'concat_ws()' in my sql query
but.. this function is not valid if u use mssql

so my question is, does anyone now a function in mssql that does the same as concat_ws() in mysql?Originally posted by bertwasbeer
hey folks, im busy trying to make my script compatible with different types of databases

so, for mysql i use the function 'concat_ws()' in my sql query
but.. this function is not valid if u use mssql

so my question is, does anyone now a function in mssql that does the same as concat_ws() in mysql?

Good question ;)
My question for you: What does the concat_ws() in mysql? I've never saw mysql.|||CONCAT_WS(separator, str1, str2,...)

CONCAT_WS() stands for CONCAT With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator can be a string as well as the rest of the arguments. If the separator is NULL, the result will be NULL. The function will skip any NULL values after the separator argument. The separator will be added between the strings to be concatenated:

mysql> SELECT CONCAT_WS(",","First name","Second name","Last Name");
-> 'First name,Second name,Last Name'
mysql> SELECT CONCAT_WS(",","First name",NULL,"Last Name");
-> 'First name,Last Name'|||Originally posted by bertwasbeer
CONCAT_WS(separator, str1, str2,...)

CONCAT_WS() stands for CONCAT With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator can be a string as well as the rest of the arguments. If the separator is NULL, the result will be NULL. The function will skip any NULL values after the separator argument. The separator will be added between the strings to be concatenated:

mysql> SELECT CONCAT_WS(",","First name","Second name","Last Name");
-> 'First name,Second name,Last Name'
mysql> SELECT CONCAT_WS(",","First name",NULL,"Last Name");
-> 'First name,Last Name'

I've never heard about function like this in MSSQL, may somebody else has. Anyway you could create User-Defined Functions for sql2000.|||What do you want to do with it?
If you are concatenating a column from selected rows you can

declare @.s varchar(8000)

select @.s = coalesce(@.s + ',') + fld
from tbl
where col2 = 'test'

This will concatenate all the values into @.s separated by a comma.

Compatiblilty

Is SQL Server 7 compatible with 2003 Server?
p.s could u give me a website with the answer to the
question as reference.
No, SQL Server 7.0 is not supported on Windows 2003 Server. Please have a
look at http://support.microsoft.com/?kbid=810391.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cr][mSoN" <anonymous@.discussions.microsoft.com> wrote in message
news:7cdf01c43155$9a9e8e00$a301280a@.phx.gbl...
> Is SQL Server 7 compatible with 2003 Server?
> p.s could u give me a website with the answer to the
> question as reference.

Compatiblilty

Is SQL Server 7 compatible with 2003 Server?
p.s could u give me a website with the answer to the
question as reference.
Hi,
SQL 7.0 is not supported on Windows 2003.
I donot have a supporting document for this.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Compatiblilty

Is SQL Server 7 compatible with 2003 Server?
p.s could u give me a website with the answer to the
question as reference.No, SQL Server 7.0 is not supported on Windows 2003 Server. Please have a
look at http://support.microsoft.com/?kbid=810391.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cr][mSoN" <anonymous@.discussions.microsoft.com> wrote in message
news:7cdf01c43155$9a9e8e00$a301280a@.phx.gbl...
> Is SQL Server 7 compatible with 2003 Server?
> p.s could u give me a website with the answer to the
> question as reference.

Compatiblilty

Is SQL Server 7 compatible with 2003 Server?
p.s could u give me a website with the answer to the
question as reference.Hi,
SQL 7.0 is not supported on Windows 2003.
I donot have a supporting document for this.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Compatiblilty

Is SQL Server 7 compatible with 2003 Server?
p.s could u give me a website with the answer to the
question as reference.No, SQL Server 7.0 is not supported on Windows 2003 Server. Please have a
look at http://support.microsoft.com/?kbid=810391.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cr][mSoN" <anonymous@.discussions.microsoft.com> wrote in message
news:7cdf01c43155$9a9e8e00$a301280a@.phx.gbl...
> Is SQL Server 7 compatible with 2003 Server?
> p.s could u give me a website with the answer to the
> question as reference.

Compatible?

I have been doing some research on SQL Server 2005 Express. We have recently purchased Visual Studio 2005 Professional Edition which comes with a copy of SQL Server 2005 Developer Edition. My question is this: Once we complete development using VS Pro + SQL Server DE, will we be able to load SQL Server Express on the client's machines and be able to have full functionality of the database that we have created to be used with the program? I have read that SQL Server Express IS in fact compatible and fully integrated with VS Express, but i have not read any information saying wheather or not it is integrated with VS Pro/SQL Server DE. Does anyone know if it is or not, and either way know the difficulty in converting it (ie. loss of data, tables, etc)?

Short answer: Yes, they are compatible.

Long answer: SQL Express has a smaller feature set than SQL Dev. If you've used functionality in your application that is not included in SQL Express, then it will fail on SQL Express. As far as the database though, the files are exactly the same and can be transfered from one Edition to another.

You can check out the SQL Server Feature Comparison to determine if you're using any features that are not available in SQL Express.

Compatible versions of Ms SQL Server, ODBC driver, Driver Manager and ODBC API s

Hi,

Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).

Any help will be appreciated.

Thanks,

vtluu.Instead of sweating bullets trying to juggle chainsaws, why not just use the current MDAC (http://msdn.microsoft.com/data/mdac/)?

-PatP

Compatible versions of compiler

Hi,
We are running Digital unix 4.0 and would like to upgrade to v5.1b. We need to find where C++ compiler v6.1-029 and C Compiler c5.6-071 are compatible with Digital unix 5.1b. If not, then what version of these compiler should I be usingWrong forum mate :-)

compatible ntwdblib.lib FOR ntwlib.dll in SQL Server 2000 SP4

Hi,
I have a old VC++ application using DB-Library for connection with sqlserver
6.5. Recently I have migrated the sqlserver from 6.5 to 2000. during
recompilation of the vc++ code, i have a problem with ntwdblib.lib file. I
think it does not match with the SQL 2000 version one.
The SQL 2000 installation CD ships with :-
- ntwdblib.lib | dated:Sunday, August 06, 2000, 8:30:29 AM | 31 kb
- ntwlib.dll | ver:2000.80.194.0 | dated: Sunday, August 06, 2000, 9:51:53
AM | 269kb
Post SQL 2000SP4 installation :-
- ntwlib.dll | ver:2000.80.2039.0 | dated: Wednesday, May 04, 2005, 12:02:26
AM | 284 kb
Currently, I have SQL 2000 SP4 installed.
Please advice me, where can i get the NTWDBLIB.LIB file correponding the
NTWDBLIB.DLL which ships with SP4
Regards,
--ChanduChandu (Chandu@.discussions.microsoft.com) writes:
> I have a old VC++ application using DB-Library for connection with
> sqlserver 6.5. Recently I have migrated the sqlserver from 6.5 to 2000.
> during recompilation of the vc++ code, i have a problem with
> ntwdblib.lib file. I think it does not match with the SQL 2000 version
> one.
> The SQL 2000 installation CD ships with :-
> - ntwdblib.lib | dated:Sunday, August 06, 2000, 8:30:29 AM | 31 kb
> - ntwlib.dll | ver:2000.80.194.0 | dated: Sunday, August 06, 2000, 9:51:53
> AM | 269kb
> Post SQL 2000SP4 installation :-
> - ntwlib.dll | ver:2000.80.2039.0 | dated: Wednesday, May 04, 2005,
> 12:02:26 AM | 284 kb
> Currently, I have SQL 2000 SP4 installed.
> Please advice me, where can i get the NTWDBLIB.LIB file correponding the
> NTWDBLIB.DLL which ships with SP4
What problem do you see? Since Microsofr hardly touches DB-Library at
all these days, I see no reason to assume that the RTM LIB file should
not be OK with the SP4 DLL. I checked on my machine, and I don't have
any newer version of NTWDBLIB.LIB that the one you mention.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks Erland for the reply,
You are right the NTWDBLIB has not changed, the problem is with the linker
of VC++5.0, it needed an upgrade. It works fine now.
thanks,
"Erland Sommarskog" wrote:

> Chandu (Chandu@.discussions.microsoft.com) writes:
> What problem do you see? Since Microsofr hardly touches DB-Library at
> all these days, I see no reason to assume that the RTM LIB file should
> not be OK with the SP4 DLL. I checked on my machine, and I don't have
> any newer version of NTWDBLIB.LIB that the one you mention.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>

Compatibility of SQL Server 7.0 with Windows 2K

Is SQL Server 7.0 compatible with the Windows 200 operating system? Are
there certain patches or service packs that need to be applied to SQL to
make this compatibility work? Thanks.

Larry"lmclaus" <lmclaus@.sandia.gov> wrote in message
news:bka37u$j4c$1@.sass2141.sandia.gov...
> Is SQL Server 7.0 compatible with the Windows 200 operating system? Are
> there certain patches or service packs that need to be applied to SQL to
> make this compatibility work? Thanks.
> Larry

http://www.microsoft.com/sql/evalua...datasheet.asp#E

Simon|||"lmclaus" <lmclaus@.sandia.gov> wrote in message
news:bka37u$j4c$1@.sass2141.sandia.gov...
> Is SQL Server 7.0 compatible with the Windows 200 operating system? Are
> there certain patches or service packs that need to be applied to SQL to
> make this compatibility work? Thanks.

Seems to be working fine here.

Ron.
--
Performance Intelligence, Inc.
Spy 4 DB2 - http://www.pireporting.com/spy4db2.html

compatability question

We have a Win 2000 Server running MS SQL Server 7.0.
The application using the SQL database is not compatible with SQL 2000.
We want to upgrade the OS on the server to Win 2003.
Is Win 2003 compatible with SQL 7.0?
Thanks
ccoatesI am pretty sure SQL 7.0 is not supported on Win2003. SQL 2000 is pretty
much backward compatible so you might want to just fix what the issue is
with 2000.
Andrew J. Kelly
SQL Server MVP
"Chris Coates" <ccoates@.gfs.com> wrote in message
news:OAd4jEc6DHA.3860@.tk2msftngp13.phx.gbl...

quote:

---

> We have a Win 2000 Server running MS SQL Server 7.0.
> The application using the SQL database is not compatible with SQL 2000.
> We want to upgrade the OS on the server to Win 2003.
> Is Win 2003 compatible with SQL 7.0?
> Thanks
> ccoates
>

---

compatability question

We have a Win 2000 Server running MS SQL Server 7.0.
The application using the SQL database is not compatible with SQL 2000.
We want to upgrade the OS on the server to Win 2003.
Is Win 2003 compatible with SQL 7.0?
Thanks
ccoatesI am pretty sure SQL 7.0 is not supported on Win2003. SQL 2000 is pretty
much backward compatible so you might want to just fix what the issue is
with 2000.
--
Andrew J. Kelly
SQL Server MVP
"Chris Coates" <ccoates@.gfs.com> wrote in message
news:OAd4jEc6DHA.3860@.tk2msftngp13.phx.gbl...
> We have a Win 2000 Server running MS SQL Server 7.0.
> The application using the SQL database is not compatible with SQL 2000.
> We want to upgrade the OS on the server to Win 2003.
> Is Win 2003 compatible with SQL 7.0?
> Thanks
> ccoates
>