I have an XML column that has multiple siblings that I am trying to retrieve with a SELECT statement using nodes() and values(). The xml is shown below:
<Stores>
<Location LocationId...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23874240.html
I was running SQL Server Express 2005 with the SQL Server Management Studio for SQL Express 2005. I downloaded and installed SQLEXPRADV_x86_ENU (Advanced). After installation I have the SQL Server...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23851546.html
When installing 2008 SQL Express it fails with the following error in the sql_engine_core_inst_Cpu32_1.log file
Specified instance {B8E9F8A1-9F4D-43D5-ABD6-1DF067FAA469} via transform :InstID02...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2384...
I am trying to install SQL 2008 Express CTP and am getting an error that I have to have .net framework 2.0 SP1 and to download from microsoft.com/net. I go there to download it and it is not compa...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2340...
I have some very basic XML in an XML column in a SQL Express 2008 database:
<Parent>
<Child ChildName="ChildA">
<ChildType>Well Behaved</ChildType>
<OtheChildData>...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/XML/XPath/Q_238664...
I have a stored procedure in SQL Express 2008 that returns the value of an xml table column as varchar(max). This stored procedure has no parameters and executes the line below:
SELECT TOP (1) ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23871759.html
I would like to include images in a gridview from a SQL database. I created the Gridview with Microsoft Expression Web because I do not have the knowledge to program this myself (I'm a network adm...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_23845406.html
I'm tryng to install SQL Express 2008 and keep getting the error message bellow.
---------------------------
Microsoft SQL Server 2008 Setup
---------------------------
SQL Server 2008 Setup ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_2387...