great article!!

mcloney (8/4/2008)

---

>>My point was to take away the "IN" clause and use a join or like some one else pointed out use "exists".

I hate to be a "me too" kinda...

Hi

Only foreignkeys and check constraints can be "disabled". The syntax is - ALTER TABLE Table1

NOCHECK Constraint ForeignkeyConstraintName.

PrimaryKeys cannot be disabled, they can be dropped. Dropping them removes the...

My point was to take away the "IN" clause and use a join or like some one else pointed out use "exists".

Hi

When you disable the primary key all the related foregin keys will be disabled. Be carefull with this as data integrity may be lost. With the contraints and foregin keys...

maruf24 (7/30/2008)

---

select alias.id,alias.aaa,alias.colname,table1.id,

table1.ttt,table1.c_f_name,cy.cmd from table3 alias,

cm table1,table2 cy where alias.colname=table1.colname

and cy.colname = table1.colname and table1.id='354'and

alias.colname in (select colname from table2 where colname

like '365464') and colname='A' and...

i could'nt download the storedproc.

Hi

How big is the db you are trying to restore. How long did you wait before restarting sql service?

Hi

Are your protocols enabled. Check the sql server configuration manager for this.

This can also happen due to network issues. check that out.

If u want to know about new functionalities in sql 2005 BOL is a good place to start.

Hi

no such issues for me. r u doing this inside a proc.

Hi

I think venkats solution may not be what you need.

Try this

declare @c varchar(100)

set @c = ''

select @c = @c + ' And ' + symbol

from table1 where id = @id

select...

You can set collations at these hierarchial levels.

server,database,columns. The server collation is default for the database and columns unless collations are modifed at any level. if you change the...

wondering why you would need a table with a single column that contains a lot of zeros.

Another option is to use the ALL operator. You can use it as <> ALL. I dont know if its faster or not.