ankithimmatlalshah (4/10/2015)

---

Hello everyone,

I'm trying to export the data from SQL database to Flat file.

The data gets exported to the destination but it does not contain the header columns.

Can anybody advise...

philosophaie (4/10/2015)

---

I am trying to write a connection string that works for SQL Server 2012.

Here is my attempt but I am using data from:

http://www.connectionstrings.com/sql-server/

I believe the below is the...

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...