How about this code?

Declare @Str varchar(30)

select @Str = 'karTHI&%@#123'

select substring(@Str,N,1),ascii(substring(@Str,N,1)) as AsciiValue,

case when (ascii(substring(@Str,N,1)) >= 65 and ascii(substring(@Str,N,1)) = 97 and ascii(substring(@Str,N,1)) <= 122)

...

I ran this script it in sql2000. it is working fine. it shows 1,2,3,4,5,6. so the correct answer is c.

I did a small R&D between TOP and SET ROWCOUNT.

Here is my R&d work.

create table test

(

no int,

name varchar null

)

go

insert into test1 values(1,'a')

insert into test1 values(2,'d')

go

create table test1

(

no int,

name varchar null

)

go

insert...

I mean how many bits or bytes will be allocated to each statements? which one will take more space?

Thanks Chris!

I want to know how sql memory will be allocated for those 3 statements? How sql optimizer process the above queries?

lmu92 (3/23/2009)

---

I'm just wondering:

is your question related to the country to outsource from or to outsource to? :hehe:

Aside of that, you're normally not outsorcing to a country but to a...

Well, I wanted to know which country (overall thought)...

A small help,

if i found any msiing data between the range,then i have to insert that date into the table.

say for example,

2009-01-05 00:00:00.000 2009-01-05 00:00:00.000

2009-01-06 00:00:00.000 2009-01-06 00:00:00.000

2009-01-07 00:00:00.000 NULL

2009-01-08...

post the query too.

Can you post the insert statement that you executed?

Which index you applied few months back?

Is there any other indexes available for the table?

Post the following here.

1)Table structure with all the available indexes.

2) Query

Try this one

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)

VALUES (null,1,'Gökhan','özkanat','Kung')

it will work.

Try this statement

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)

VALUES (1, 1,'Gökhan','özkanat','Kung')

it should work.

Because you have referred personal_id column value to chief_id, so what is the general rule of foreign key? Foreign key value...

"string concatenation" function...

Execution plans in my box.