Hi,

Thanks for your reply. Yes, I need to catch the error information thrown.

What is command need to execute in the catch block?

Thanks

Hi sanoj

Thanks i got it. 🙂

yeah you are right. But i am not insert single row i inserting multiple rows at a time.

So only i am using cursor.

Thanks

Hi,

thanks for yours reply. I am not assigned in insert statement. I need to get @featureoperationmapid and @userid and insert into another table.

Without assigning how i select...

Hi dude thanks for your reply.

Yes its correct i got it. But query is this one that is WHERE intUserID LIKE '%2%'.

ou know any best schema for this condition...

Hi,

Thanks for your's reply. Is any other options are available for this one??

Thanks

Hi,

Suppose if your query will be like this ie (Col='A') instead of (Col=1)

Select Col

From (Select Col

From Test

Where Isnumeric(Col)='A') X

Where Col Between 1 and 6

You can get...

Hi

The correct answer is C that is

1

2

3

4

5

6

I run this script in sql server 2005 and check it. Its not give an error. Its give an output.

Please...

hi i created ##tempTable also and check it. same exception occured.

yes i did.I put in the db server.

but i got same exception.

BULK INSERT checkcsv

FROM '\\IWAPPSVR\IWSQLDBame.txt'

WITH

(FIELDTERMINATOR = ',', ROWTERMINATOR = '/n')

hi thanks for your reply. so where i put the file and how can i insert bulk??

hi ,

thanks for yours reply. I implemented this query in master database.

I got an exception that

The CREATE DATABASE process is allocating 0.63 MB on disk 'Whatever'.

The CREATE DATABASE process...

Hi friend,

Thanks for your reply.

In which query language have a BEFORE TRIGGER

Regards

Ashok

Hi friend

Thanks for yours reply. In which edition database mail is available??

Hope yours reply.

Regards

Ashok

Hi friend,

i got the same exception. Could you tell please details??