may i have the reason......bcoz i wud hv to us a cursor...if i do it at sql

Well....I have solved my problem, I just restarted the server.But here i dint know the root cause ... something related to server/client link....and it can happen again....so can any...

nope..it is with every user table....

Which error message are u getting?

Hi All,

I duplicated the issue.....I created a new login with a name..."newlogin".(as every one said that Login is used to log in to the sql server instance)....then I created 3-4...

Hans Lindgren (4/21/2008)

---

Because of company policy we have to empty this drive and this includes removing (or moving away) any DB files on it. I have three primary files left...

Anirban Paul (4/17/2008)

---

GilaMonster (4/17/2008)

---

Then the interviewer is either wrong (the syntax is valid and works fine in sQL 2005) or he has something else in mind.

If someone told me...

gud one:)

GilaMonster (4/17/2008)

---

Why not?

CREATE TABLE [dbo].[TheTable](

[ID] [int] identity,

[TheName] [varchar](50) NULL

)

GO

insert into TheTable (TheName) Values ('Tom')

insert into TheTable (TheName)...

It works:)

What if I have varchar column .. in...

Well..I think that we cant use CASE statement in update query..however,

any other options excluding case

y they have not incorporated the concept of array in TSQL like that in other programming languages....

Hi,

You can use bcp utility to extract data into a table.

refer to books online for more information.

Cheers

Ahmad

Sergiy (3/31/2008)

---

That's actually the logic you may...

Chris Morris (3/31/2008)

---

Matt Miller (3/31/2008)

---

If you're trying to make sure that they don't re-enter existing clients - why not force them to go through the existing list of customers FIRST?...