Lowell (4/17/2013)

---

well based on how i read your description, it sounds like a simple calcuated column could be used;

ALTER TABLE [dbo].[GV_STNDetails]ADD STN AS RIGHT('0000' + CONVERT(VARCHAR,[From_StoreCode]),4) +RIGHT('000000' + CONVERT(VARCHAR,[STNID]),6) PERSISTED

if...

Kingston Dhasian (4/17/2013)

---

The scenario that you have mentioned is not very clear.

It would be good if you can explain your issue with some DDL and...

Please help me on this...

Hugo Kornelis (4/17/2013)

---

Good question. Not perfect, though.

When I read the question in the daily newsletter, I expected the answer options to be "yes" or "no", and I was fully ready...

New thing to learn... 🙂

Hugo Kornelis (4/16/2013)

---

COUNT(*) returns the...

Sean Lange (4/16/2013)

---

kapil_kk (4/15/2013)

---

For the last query:

select COUNT(convert(int,NULL)) from #temp

It will return 0 because when you execute the query:

SELECT CONVERT(int,NULL) it will return NULL and as the return type of...

--Variable Delaration

Declare @keytosearch varchar(max), @Database_Selected varchar(50)

set @keytosearch ='%london%'

set @Database_Selected= 'Northwind'

Declare @Table varchar(100), @Table_Name Cursor, @Count_Column int,

@Result nvarchar(4000),@ID int,@ID_inserted int,@Count_Table int, @data_type varchar(10)

set @ID_inserted=0

set @Count_Table=0

DECLARE @column...

Hugo Kornelis (4/16/2013)

---

Good question, mediocre explanation - no errors, but complicating things more than needed.

There are three variations of COUNT:

* COUNT(*) - returns the number of rows, regardless of content.

*...

L' Eomot Inversé (4/16/2013)

---

Nice question, but as only one list of values ended with 0 it was easy to get the answer without checking anything else, so much easier than...

VegasL (4/15/2013)

---

Hello,

I have in select statement select t1.A/t1.B but get divide by zero error

when I used with isnull isnull(t1.A/t1.B,'-')

I get error Error...

For the last query:

select COUNT(convert(int,NULL)) from #temp

It will return 0 because when you execute the query:

SELECT CONVERT(int,NULL) it will return NULL and as the return type of COUNT is INT...

really good basic question Yogi 🙂

Thanks for it:-)

GilaMonster (4/15/2013)

---

Except that would also match entries such as...

great explanation Jeff 🙂