if you're planning to learn then aim for the OCP qualification, you'll pick up a lot more if you aim at passing the exam

https://blogs.oracle.com/certification/entry/0118

littlelisa1111 (5/4/2012)

---

SELECT l.Id, CRM.dbo.fn_ConvertSFDateTime(e.CreatedDate) AS lastevaluationdate__c, e.ProductId__c AS lastevaluationproduct__c

FROM Customers.dbo.Evaluation__c AS e INNER JOIN

...

capn.hector (5/4/2012)

---

Eugene Elutin (5/4/2012)

---

Jeff Moden (5/3/2012)

---

BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview...

Steve Thompson-454462 (5/3/2012)

---

I think thats fine if you are only storing the role and thats as far as you go with it, so I'm ok with this. If you are...

rabisco (5/3/2012)

---

From the following string.....

<p style="text-align: justify;">Embedded link <a class="productLink href=";" macro="productLink" code1="1055288" uid="_13360741834971941">code1</a>sku</p>

I'm trying to detemine the position of "<a class="productLink" working backwards from the position of "code1="

Thanks

...

nice - not sure it's got too many practical implementations other than showing a junior how to run and correct checkdb, but it's still nice to have in your arsenal

Cadavre (5/2/2012)

---

michael vessey (5/2/2012)

---

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice small (low...

mohan.bndr (5/1/2012)

---

Hi,

If the current buffer hit cache ration is consistently above 99% then, Is it benefit to adding RAM to a server to boost hardware performance of sql server? why?

And...

+1 GSquared - he beat me to it

to find the first instance of a character in a string use "charindex"

to find the last instance use a combination of charindex and REVERSE

select LEN(col3) - CHARINDEX('A',REVERSE,col3)) as last_a, CHARINDEX('B',col3))...

does the following count as a loop?

INSERT INTO dbo.yourTable default values

go 100

??:-P??

you might want to have a look at a few...

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice small (low resource) version

wouldn't this be easier to do with a recursive CTE?

declare @start bigint=99;

declare @end bigint=147;

with x (num) as

(

select @start as num

UNION ALL

SELECT num+1 from x

where num <@end

)

select * from x...

for example

why does the following not work for you ?

insert into table2 (Number,

reference,

Quantity,

UnitPrice,

Supplier)

select

Number

reference

Quantity

UnitPrice

Supplier

from table 1

where .....

this is the standard syntax for copying data from one table to another