http://technet.microsoft.com/en-us/library/ms175106.aspx

Please elaborate.

select * from information_schema.columns

where column_name like '%col1%'

OR column_name like '%col2%' OR column_name like '%col3%'

kapil_kk (9/16/2013)

---

This time I used new column also in the SELECT statement but it gives an error that NULL values not allowed in that column instead I was not getting...

what made you to think that this query is behaving bad ?

i will second Jeff here. Do the NULL handling in all the vairables (ISNULL(@variable, ''))

Also Before sendin it to DBmail

Print the Text for @Subj =...

Thanks a ton for help ..to all guys here 🙂

Need help ..please .......

DBA_Learner (3/15/2013)

---

I have a teradata environment with database aroudn 3TB. This server has around 40 core processors. Microsoft suggested to Use only 32 processors instead of 40 as there was...

Now people would be looking for exec plan here 😀 like me .

No. Truncation command dosent touch the indexes.Thats the another reason why truncate is faster....

Minnu (3/21/2013)

---

Table_1: ID | CHARACTER

1A

2B

3C

4D

5E

Tabe_2 : ...

kk.86manu (3/21/2013)

---

We currently have a backup and restore job which runs on a weekly basis and the database size is more than 10TB.Split backup method is followed for taking the...

Kwisatz78 (3/21/2013)

---

My question is, in this case, would that be the best way to code this or would splitting the string first and placing it in a temp table before...

declare @max-2 int , @cnt int

declare @t table (id int ,Company varchar(50),Site nvarchar(20),TransDate Datetime)

set @cnt =1

--select * from #TransDetail

select @max-2 = MAX(Number) from #TransDetail

while ( @max-2 >...