 | |
Use SQL 2005 sqlcmd on a SQL 2008 server?
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Use SQL 2005 sqlcmd on a SQL 2008 server? -
09-25-2008
, 04:57 PM
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#22
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#23
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#24
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#25
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#26
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#27
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#28
| |||
| |||
|
|
As long as you stay away from SQL Server 2008 features like spatial and hierarchy data types. |
they are CLR types and just binary values as far as SQLCMD is concerned.
New native types like date etc are another matter, but since all you do
is to receive values, there is no big issue. SQL Server will return
the values as strings instead as the native values.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.