Thanks for an easy question .... now a question of my own "Is this QOD an Xmas present ?"

Snow

+100

Here is an adhoc method, to run when you want ... uses just the basics

http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/

There are three (3) versions of SQL Express

Express

Express with Advanced Services

...

From:

http://glennberrysqlperformance.spaces.live.com/default.aspx

Try this

SELECT TOP 100 qt.text AS 'SP Name', qs.execution_count AS 'Execution Count',

qs.execution_count/DATEDIFF(Second,...

Try reading this:

http://gavindraper.com/2012/02/18/sql-server-isolation-levels-by-example/

Yes you can. To obtain the latest patch and how to use it go here:

http://www.microsoft.com/en-us/download/details.aspx?id=20610

Nice QOD to start the week ---- Thanks

Nice question on the fundamentals ..

declare @count int

declare @charvaluefront varchar

declare @charvalueback varchar

declare @frontpos int

declare @backpos int

select @count=len('ABC')

...

Too simple .....

So nice to be reminded of the fundamentals ... Thanks

A very back to basics question ...... Thanks

The temp table - I only selected it, since I do NOT have...