SQLRNNR (3/27/2015)

---

Yes you can certainly get a...

Luis Cazares (3/27/2015)

---

In a different order of ideas, I want to share with you my happiness.

Starting on April 21st I'll be working in the US. I'll make a stop at...

ChrisM@Work (3/27/2015)

---

Question of the day: what datatype is the Estimated Number of Rows (or Estimated Subtree Cost) displayed in the property sheet of the SELECT operator in the estimated plan...

Dandy

djj (3/27/2015)

---

jasona.work (3/27/2015)

---

I hate Fridays around this place...

Unless you've got some project going on that can be worked on when 50+% of the staff is off, you spend a good...

jasona.work (3/27/2015)

---

I hate Fridays around this place...

Unless you've got some project going on that can be worked on when 50+% of the staff is off, you spend a good chunk...

My Friday fun version:rolleyes:

IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n)) SELECT 1 FROM sys.all_columns X,sys.columns Y,sys.computed_columns Z

Ells (3/27/2015)

---

I have a datetime field that is just the date and zero for the time element. I also have a varchar field that is of the format 09:25:30

is there...

For fun, here is a slightly different way of constructing the desired XML output

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH XMLNAMESPACES

(

'http://www.example-namespace.com' AS ns

)

,SAMPLE_DATA AS

(

SELECT * FROM

...

Quite simple really, here are the two scripts side by side

😎

--SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; ...

Quick question, are you looking for a transparent encryption? Maybe its worth while looking at the likes of Corsair Flash Padlock 2 USB flash drive

Makes

Theory

Board

Dark