Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but I'm putting...

Grant Fritchey (4/10/2015)

---

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but...

Especially when it's pushed forward to the day of the publication,...

maurer.martina (4/10/2015)

---

new thought: a kind of syntax-check

Example-Statement: delete from mytable

allowed characters between "delete" and "from" and "myTable" are only blanks, right?

If I erase the blanks in the definition, there must...

yusufm 48726 (4/10/2015)

---

Hi Guys,

I am trying to create a report from view and I am stuck on dates and Value.

I have got scenario like

Date ...

dlsilsbury 63952 (4/10/2015)

---

Hi,

I'm new to the forums. So Hello, hello.

Quick question! Is this syntax valid?

"FOR XML AUTO, RAW"

I can't see that it is but I'm due to take my 70-461...

Escaping the quotation marks produces the correct output

😎

INSERT INTO dbo.Staging_Temp_1 fnGetFirstOcurrences(col001, '¯',@Columns),LoadDate...

vipin_jha123 (4/10/2015)

---

Hi,

I am getting error in my below sql statement

Declare @sqlquery varchar(max)

Set @sqlquery='INSERT INTO dbo.Staging_Temp_1 fnGetFirstOcurrences(col001, '¯',@Columns),LoadDate FROM dbo.Staging_Temp'

Select @sqlquery

error:-

Msg 102, Level 15, State 1, Line 11

Incorrect syntax...

Try this

😎

SELECT

OBJECT_NAME(ASM.object_id) AS OBJ_NAME

,OBJECT_SCHEMA_NAME(ASM.object_id) AS OBJ_SCHEMA_NAME

,CASE WHEN ASM.definition LIKE N'%UPDATE%' ...

Slightly different approach, only scans each table once

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @vehicle table(id int, vehiclemake varchar(10), vehiclemodel varchar(10));

declare @vehicleclass table(id int, vehiclemake varchar(10), vehiclemodel varchar(10), classtype varchar(1));

insert into @vehicle values

...

Thanks Steve!

😎

BTW, the leading "#" is included in the count, BOL does not mention that.

Jeff Moden (4/9/2015)

---

Eirikur Eiriksson (4/9/2015)

---

tcronin 95651 (4/9/2015)

---

I have baselines, just stunned to see this happen, I have been a dba for 20 years and 99% of the time this happens...

Sigerson (4/9/2015)

---

ZZartin (4/3/2015)

---

In my last job I managed...

Sean Lange (4/9/2015)

---

My workplace participates in the “Take Your Daughters and Sons to Work Day” and I have to give a 10-15 minute presentation about how important technology is to...

MMM (Many Mountains Moving)