Nice question.Thanks 🙂

Eirikur Eiriksson (5/7/2014)

---

rhythmk (5/7/2014)

---

Can you please elaborate with more clarity as I am...

As you mentioned that in real scenario you can have more item type with many other attributes.So it is better to have separate tables for every item type instead of...

Can you please elaborate with more clarity as I am confused with above...

I did not get your requirement. Can you please explain bit more with example. Also...

Try to create a DDL trigger for the same.

Follw below link.

DDL Triggers

It is all about corporate politics that a person who should be ideal manager does not get the post while others get it :angry:

shima_khosravani (5/7/2014)

---

hi

I want a mechanism that search the content of all files in my upload folder,then return the address of the file that contains that keyword

plz pay attention that...

As suggetsed by Koen it may be because of loops you are creating.

Why don't you read this excellent article of Tally table from Jeff to avoid loop.

The "Numbers" or "Tally"...

+1. As I have also contributed the same question for QoTD and it is yet to published.However the nature of question is different 😉

Jeff Moden (5/6/2014)

---

rhythmk (5/6/2014)

---

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as...

raulggonzalez (5/6/2014)

---

Thanks for the question,

I guess the author goes more this way

--the smallest exact number integer data type that can't support a negative number

declare @bit bit

set @bit = -1

Command(s)...

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as a SUM(), I...

nice question.

dexdev (4/28/2014)

---

Hi everyone

We're looking into setting up a SQL cluster for our app.

Our current setup is based on a very high number of small databases.

We are looking into setting up...