Description:
Microsoft's SQL Server and related products.
|
|
|
How to add xml to a column in a Database table
|
| |
Hello!
I have defined a table like this. It's just for learning.
Create table MyTable (MyIntColumn int Primary KEY, MyXmlColumn xml)
The table is created fine but it's not possible to add any xml to the MyXmlColumn
it's like the column is read only ?
//Tony
|
|
|
Select affected rows
|
| |
Hi,
is there an option to get the identities of the affected rows and not
only a counter that mention the number of the affected rows?
Another question, is there an (NOLOCK) equivalent option for update
statement?
|
|
|
Custom agregation in Sql server 6
|
| |
I know it is legacy database, but i have been looking how can i get
Input data
Col1, col2
1, 'nebraska'
1, 'boston'
2, 'new york'
3, 'pekin'
results desired:
Col1 col2_concatenated
1 'nebraska,boston'
2 'new york'
3 'pekin'
The problem i find is using sql server 6 (sql server 2000 with... more »
|
|
|
Break Up Large Table Query Into Results of N Rows
|
| |
Hi.
I am working in SQL Server 2005 and want to break up a table of 1M
rows into distinct results of 80,0000.
I feel like this is basically
use [database]
select * from [table]
where email_address like '%gmail.com'
group by ????
I am messing up with the group by (if this is the right way to go).... more »
|
|
|
ODB C++ ORM 1.8.0 released, adds support for SQL Server
|
| |
Hi,
I am pleased to announce the release of ODB 1.8.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.... more »
|
|
|
Worth the wait?
|
| |
This question is for those who are MS SQL Server MCTS or MCTIP certified.
I'm currently doing exam prep for a couple of MCTS certs in SQL Server 2008. Given MS's new "expiration policy" for MCTS/MCTIP (ie. certs expire with the
"next major release" of the product), and with the pending release of SQL... more »
|
|
|
transaction
|
| |
Hello!
Here is a text in a book.
"To ensure that you don't leave your transaction open for too long, consider using sqltransaction object in a Using block. The longer the transaction remain open, the longer the database needs to maintain the locks for the rows. If the SqlTransaction has not been committed or rolled back at the end... more »
|
|
|
SQL Server Query Analyzer
|
| |
Hello!
I read a book and here they mentioned Microsoft SQL Server Query Analyzer
I wonder where can I find it =.
//Tony
|
|
|
