Above you are assigning the whole SQL Statement to the variable, you should do something along the lines of:

declare @Cnt int

SELECT @Cnt = count(CName) FROM [TableName] where CName= 850891144

SELECT...

Ratheesh.K.Nair (8/4/2008)

---

Hi EXperts,

Am getting the error

Msg 492, Level 16, State 1, Line 2

Duplicate...

Morris Logan (7/30/2008)

---

Hi Folks,

I would like to know the best way to identify the nth occurrance of a specified character in a string?

e.g: lets say I have this string aaaddddfffggghhhhjjjj,...

You may be able to do this, depend on what you...

Depend on: what recovery mode you are using (you may want...

patr (7/29/2008)

---

hi

I want to generate a script,should contains both the structure and the data existing in the database.Is ii available in sql server 2005

thanks in...

patr (7/29/2008)

---

hi

I want to generate a script,should contains both the structure and the data existing in the database.Is ii available in sql server 2005

thanks in...

CrazyMan (7/29/2008)

---

Hi All

i need to disable management studio from my live servers, please help me on this, i want to block some users...

The above message means that some of the values in your table cannot be converted to the new data type. For example you may have 'foo' as a value, and...

To find out how much space your database is using, you can run a query like:

SELECT...

You can get around this by adding go statements between the inserts. Also have a look at the remarks section of http://technet.microsoft.com/en-us/library/ms162773.aspx

What you experience may have to do something with:...

bodhilove (7/28/2008)

---

Hi,

Are there any issues migrating a sql server database to 2005. I was thinking that I could backup the current databases on 2000 and restore on 2005. Will this...

sepelloo (7/28/2008)

---

hi all.

i deploy my tion and sql database on user pc.

some user have installed enterprise manager on their system. so they easly see my database and can modify it.

i...

go2vish (7/25/2008)

---

Hi,

Can anyone help urgently??

I have to roll back a table in sqlserver 2005, where in table for one column the "Set Identity Insert" is "ON".

Before making change in...

GilaMonster (7/18/2008)

---

shiwani2002sg (7/18/2008)

---

if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command....