Quick suggestion, use the GETDATE() function in T-SQL

😎

For fun, yet another solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('dbo.TBL_SAMPLE_PARSE') IS NOT NULL

DROP TABLE dbo.TBL_SAMPLE_PARSE

CREATE TABLE dbo.TBL_SAMPLE_PARSE

(

SP_ID INT IDENTITY(1,1) NOT NULL ...

Quick solution, should be self explanatory (I'll add comments if I'll get the time;-))

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Test_ROADS') IS NOT NULL DROP TABLE dbo.Test_ROADS;

CREATE TABLE dbo.Test_ROADS

(

Hwy...

Jeff Moden (5/1/2015)

---

It's clever but I have to disagree with that being a good example of a "Read Only Try/Catch" because it returns two result sets instead of just one....

Skyr

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and Ed...

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses,...

diogo_1984 (5/1/2015)

---

I wish my transform variable, so that adding the OR operator, and the words within the quotes are not to put the OR.

ALTER PROCEDURE

@product = ' 'ORANGE LEMON'...

Raita

Venus

Celebration

Eric M Russell (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when...

PJ_SQL (5/1/2015)

---

I have a column A as 'text' datatype. This has CR-LF in between data.

How to remove it.

I am trying to copy result from SQL to Excel

Eg:

A CR LF

ABC CR...

djackson 22568 (5/1/2015)

---

david.gugg (5/1/2015)

---

We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can be tuned to...

Eric M Russell (5/1/2015)

---

Static code analysis doesn't know how many times the code is executed, how much data it accesses, or how it's impacted when running in parallel with other...