Good question kapil.

But if you execute this T-Sql in single batch, then it will give an error like "Procedure vw_customer, Line 9 Incorrect syntax near the keyword 'Create'."

In...

Hugo Kornelis (7/23/2013)

...

In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an INTO keyword....

Good question. I learn something new. 🙂

Today's QtD is worthwhile.

thanks hugo and kapil 🙂

Great one !!!

:w00t::crazy::laugh::laugh::laugh:

For see SSDTBI, you need to install SQL Server 2014 CTP. Remember that you can not install SQL Server 2014 CTP with other SQL server instance, or side by side...

Great knowledge sharing. reference article is also great.

[https://www.simple-talk.com/sql/database-administration/transparent-data-encryption/]

Learn new thing. Thanks carlo 🙂

Thanks for easy one 🙂

Danny Ocean (7/14/2013)

---

kapil_kk (7/14/2013)

---

When I checked the BOL i found that there is a line stating:

If a table name is aliased in the FROM clause, only the alias name can...

kapil_kk (7/14/2013)

---

When I checked the BOL i found that there is a line stating:

If a table name is aliased in the FROM clause, only the alias name can be used...

Thanks for start Monday with easy one 🙂

Good one. Actually whenever we try to convert any number data type (int, float, money, decimal,...) in Character format (char, varchar, nchar, nvarchar) and Character format length is less then...

Good question and straightforward explanation 🙂

Quite easy, Really very good question. Still 36% people are wrong. It shows important of this question.

Keep it up man !!! 🙂