Are you sure you want your users accessing the DB from SSMS? A much safer approach in your case might be to write a report which allows your users...

Jeff Moden (8/11/2012)

---

That's...

Abu Dina (8/9/2012)

---

Matt Miller (#4) (8/9/2012)

---

Abu Dina (8/9/2012)

---

Those in charge have told me that it would take...

Abu Dina (8/9/2012)

---

Those in charge have told me that it would take too long to enable database...

The article describing TDE is here:

http://technet.microsoft.com/library/cc278098(SQL.100).aspx#_Toc189384677

Based on its description - it's CBC.

JWOL (8/3/2012)

---

declare @xml xml

set @xml='<batch>

<statements>

<StmtSimple id="1"/>

<QueryPlan id="1"/>

<StmtCond id="2"/>

<QueryPlan id="1"/>

<StmtSimple id="8"/>

<StmtSimple id="16"/>

<StmtSimple id="32"/>

<StmtSimple id="64"/>

<StmtSimple id="128"/>

</statements>

...

Try this:

declare @xml xml

set @xml='<r><bill>

<bob id="1"/>

<bob id="2"/>

<bob id="8"/>

<bob id="16"/>

<bob id="32"/>

<bob id="64"/>

<bob id="128"/>

</bill>

...

hoseini_akram (8/3/2012)

---

Hi

How a float datatype (for example, 3.7854398123234) in 2008 Sql server2008R2 will Round (for example, be converted to 3.785)

in The following command:

update dbo.tblgas01g4c40

set DailyConsumption = Convert (float,Consumption)/convert(float,FindDiffRead)...

Yet another in a cast of many:

DECLARE @num INT

set @num= 102948092

DECLARE @numstr VARCHAR(100)

SET @numstr = @num

DECLARE @revstr VARCHAR(100)

set @revstr=replicate(' ',len(@numstr));

;WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1...

JWOL (8/3/2012)

---

Great, thanks for all the replies. I'll try these out.

Which sites do you use as a reference? I looked at w3schools but they just give...

One last one - this might help you figure out how to detect those children nodes:

declare @xml xml

set @xml='<r><bill>

<bob id="1"/>

<bob id="2"/>

<bob id="8"/>

<bob...

As to filtering out specific nodes with multiple names, try:

declare @xml xml

set @xml='<r><bill>

<bob id="1"/>

<bob id="2"/>

<bob id="8"/>

<bob id="16"/>

<bob id="32"/>

<bob...

Assuming you don't want to reset the count, and just want to count as you find them in the file, you can use the // trick. As in:

declare @xml...

To the best of my knowledge have to use a construct of this sort to find the position:

declare @xml xml

set @xml='<r><bill>

<bob id="1"/>

<bob id="2"/>

<bob id="8"/>

...

We use TFS rather than Redgate's SQL SourceControl, but I'd imagine there is some way to check where you still have things that are checked out.

From your description it sounds...