The assciated indexes would be dropped.

The two table definitions could be different in any column(s) interms of the storage .

Try the White paper on the SQL CLR in SQLskills.com, it gives lot more info.

The DMV "sys.dm_os_memory_objects" shows the memory pages allocated to the SQL server objects.

Your query is retruning the memory pages allocated for the CLR objects .

Try the below link , might...

Paste your query to understand the requirement

In case if you need the value to be datetime and storage type to be varchar in COGNOS, then you need to CAST it to datetime in the SP once...

The second one would be faster becuase it is single SET based update on the table compared to 10 different update statements.

The syntax in the second query seems to be...

Sorry the previous script doesnt work as expected if the value is present in the table.

Try the below code

declare @name varchar(10)

set @name ='junk'

select distinct case

when exists...

May be you can try this.

select distinct case

when exists (select name

from dbo.tableA

where name ='junk') then name

else ''-- or u can write something

end

from...

There had been a discussion going on the same error( the possible reason could be insufficient memory)

, PFB link, this might help you.

Sql server is having Boolean Data Type, declare the vairable as bit

You can use the below

ALTER PROCEDURE [dbo].[cpas_CloneBoM]

-- Add the...

Please mention the requirement clearly

Try the below code and let me know in case of any erorrs or problems.

This will extract the numbers from the alphanumeric values.

The final output is of Varchar type...

I hope there is a confusion with my question.

I am not asking why my insert was falied ...am asking why SQL server accepts such a conflicting range of values..isn't there...

hi,

You can check the below example, it might help you in framing your query.

Create Table test1

( c1 int ,

C2 int)

insert into test1 values (1,45)

insert into test1 values (1,76)

insert into...