Alan.B (7/24/2013)

---

I say it...

...

While I generally agree lets not go off on a rant.. Perhaps I read that wrong, but we don't need to be testy.

As a rule you should never use...

So, if you have no choice, but to rename database (as your client/employer requires you to do), you must go inside...

RAISERROR cause transaction to rollback, so your log insert is rollbacked as well as delete...

Check use of self-linked server in order to simulate autonomous transaction in SQL Server.

NineIron (7/24/2013)

---

Thanx. So, if I were to copy a db and rename it from PROD to TEST, the sp's would run the same way on TEST without any code changes?...

Unless it's not in dynamic SQL, which is absolutely fine:

CREATE PROC...

dan-572483 (7/24/2013)

---

I'm not sure what the point of this interview question would be, since in the real world if you needed a query that always returned 1 you would use...

Sean Lange (7/24/2013)

---

I would have to say that is an absolutely horrid interview question. It is not testing your skills with sql server. I have seen the binary AND around...

Yep, does look like. However...

Correct concatenation of string values (eg. accumulating of numeric values)...

tommyh (7/24/2013)

---

I accidently had an unfinished piece of SQL code in my query window during execution. The code was

select count(*)

Now to my supprise it returned 1. Anyone know why it...

Obviously very wrong choice for storing dates, as it allows to contain any string.

Now, the best way to fix all possible issues...

if your column is of DATETIME or DATE datatype, it doesn't have any format. So you cannot change the format of it!

The way SQL Server stores dates internally has nothing...

Here is one of the short form which can be used for ITV function

RETURN SELECT ISNULL(CASE WHEN ISDATE(@value) = 1 THEN CASE WHEN CAST(YEAR(@Value) AS CHAR(4)) = LEFT(@Value,4) THEN 1...

Ananth@Sql (7/22/2013)

---

How To Validate a year, month,and date and totaldate?Year should be in yyyy format,month should be between

1 and 1 to 12 and date should be between 1 to...

If system architecture wants to use ORM methodology (eg. Entity Framework, NHibernate and any other) then, as DBA, you should provide relevant permission/access model.