-- TheTimeIs Script

-- start script

CREATE PROC TheTimeIs AS

SELECT CREATED FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'TheTimeIs';

GO

EXEC TheTimeIs;

DROP PROC TheTimeIs;

GO

-- end script

Lynn Pettis (11/19/2015)

---

Jeff Moden (11/19/2015)

---

Eirikur Eiriksson (11/19/2015)

---

So to recap, here are 9 different methods for getting the current time, any additions anyone?

😎

SELECT

GETDATE()

,SYSDATETIME()

...

Just for fun and practice:

DECLARE @x varchar(100) = 'AB_CD_EF_GH_IJ';

WITH L1 AS (SELECT N=1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))X(x)), -- 10 rows

iTally(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) FROM L1...

Sean Lange (11/17/2015)

---

Alan.B (11/16/2015)

---

The Dixie Flatline (11/16/2015)

---

Without using specific examples to test, it is hard to explain why set-based processing outperforms cursor-based code. ..."It depends" to coin a...

Brandie Tarvin (11/17/2015)

---

Ed Wagner (11/17/2015)

---

Brandie Tarvin (11/17/2015)

---

Ed Wagner (11/17/2015)

---

Lynn Pettis (11/16/2015)

---

Ed Wagner (11/16/2015)

---

Lynn Pettis (11/16/2015)

---

And then you this type of question:

************(11/16/2015)

---

How can i round off decimal number. E.g if i...

The Dixie Flatline (11/16/2015)

---

Without using specific examples to test, it is hard to explain why set-based processing outperforms cursor-based code. ..."It depends" to coin a cliche. ...

I thought more people would jump on this. :Whistling:

Anyhow I took a few minutes to throw some stuff together for you. Perhaps this will be helpful.

USE tempdb

GO

/****************************************************************************************

(1) Create Sample...

I'm not at a PC so I can't test this but...

Jeff beat me to it. Tables are either HEAPS or Clustered Tables (e.g. a table with a clustered index which means it's a B-Tree).

I would add, you could run this...

Though STUFF is an insignificant and...

This should get you started.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

+1 😉

SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) by Grant Fritchey is a...

MonkSup (11/10/2015)

---

Thanks for your response. I've been digging around the MSDN documentation...

Is OPENXML something I should look into?

https://msdn.microsoft.com/en-us/library/ms187897(v=sql.110).aspx

I can find plenty of examples for importing and creating structures for XML...

How about ISNULL? ISNULL(<whatever>,'') for blank values, ISNULL(<whatever>,0) to get a 0.