wendy elizabeth (8/31/2014)

---

In a sql server 2012 database, I have a field called date of birth that is stored in a tha that is stored in a datetime format. I...

Good function.

Thanks Steve, for the question.

I can see more right answers.

Now it seems good.

Thank you admin.

Good basic question.

Thanks for it.

anoosha.konaparthi (8/20/2014)

---

im getting this error while executing

"DBCC CheckDB('test') WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLOCK"

Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid...

Lee Linares (8/19/2014)

---

For my users, they would expect the same answer either way. One way to handle that would be that if the @Fromdate is greater than the @Todate, simply...

Lee Linares (8/19/2014)

---

I see your point. But the end-user would be confused by the output.

In reality if I were deploying this I would likely disallow the user from inputting...

Lee Linares (8/19/2014)

---

Sure, here are the results of 2 calls using your posted code:

Select [dbo].[fn_TotaltimeBetweendates] ('06/13/1990', '08/18/2014') -- Returns 24 Years :2 Months :5 Days

Select [dbo].[fn_TotaltimeBetweendates] ('08/18/2014', '06/13/1990') -- Returns...

Use this link to prepare :

https://www.microsoft.com/learning/en-in/sql-certification.aspx

XML Queries may be yuck,

But you have to prepare this for 70-461, 8 to 10 question comes on exam...

smatu (8/17/2014)

---

Has anyone successfully installed and maintained multiple versions of SQL Server instances on a single server?

What disadvantages have you encountered maintaining multiple versions of SQL Server instances on...

I didn't find any error with the code :

DECLARE @i TABLE( mychar VARCHAR(50)

,deriv as SUBSTRING(mychar,1,3) --Use this

,newderiv as left(mychar,3));--Or use this

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

, ('Sterling'), ('Steppenwolf'),('Ab'),('Abc')

SELECT * FROM...

Lee Linares (8/14/2014)

---

Thanks for taking the time to create and share your code. I found that when the @FromDate was more recent than the @ToDate the returned answer was incorrect....