<div>
Use this syntax where you specify what the source column should appear as in your result set.<br />
<br />
Select <br />
PackageID<br />
, Name AS OLD_Name<br />
, Version, Manufacturer, Language, Description,<br />
PkgSourcePath , LastRefreshTime, ...<br />

</div>


Use this syntax where you specify what the source column should appear as in your result set.

Select
PackageID
, Name AS OLD_Name
, Version, Manufacturer, Language, Description,
PkgSourcePath , LastRefreshTime, ...


<div>
<div class="content wysiwyg-content">
Hey<br />
<br />
I have this query (SQL)<br />
<br />
Select PackageID, Name, Version, Manufacturer, Language, Description,<br />
PkgSourcePath , LastRefreshTime,<br />
(SELECT COUNT(PkgID) FROM vPkgStatusSummaryDistPts WHERE PkgID = v_Package.PackageID) AS [No of DP]<br />
FROM v_Package<br />
WHERE<br />
PackageID NOT IN (SELECT PackageID FROM v_Advertisement) AND<br />
PackageID NOT IN (SELECT ReferencePackageID FROM v_TaskSequenceReferencesIn<wbr />fo) AND<br />
PackageType = 0 AND<br />
ORDER BY Name<br />
<br />
....<br />
<br />
How to I make the query rename all &quot;Name&quot; in the result to &quot;OLD_Name&quot;? (add &quot;OLD_&quot; to the record).<br />
<br />
Thanks in advance.<br />
<br />
Mike
</div>
</div>


Hey

I have this query (SQL)

Select PackageID, Name, Version, Manufacturer, Language, Description,
PkgSourcePath , LastRefreshTime,
(SELECT COUNT(PkgID) FROM vPkgStatusSummaryDistPts WHERE PkgID = v_Package.PackageID) AS [No of DP]
FROM v_Package
WHERE
PackageID NOT IN (SELECT PackageID FROM v_Advertisement) AND
PackageID NOT IN (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) AND
PackageType = 0 AND
ORDER BY Name

....

How to I make the query rename all "Name" in the result to "OLD_Name"? (add "OLD_" to the record).

Thanks in advance.

Mike

SQL Query rename/update

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.