Yes,

You should use (Not Exists) predicate

for satisfying two or more conditions.

either

You can use (IN) Predicate.

Your,

Windows Domain settings are chaged.

You should login the SQL TO sa

The Sql Server Administrator Account  

I think , your database log file is not shipped to the server.

Properly.

No Answer About such Question

USE THIS SIMPLE qUERY???

select REPLACE(substring('V4567',1,3) + SPACE(1) + SUBSTRING('V4567',4,LEN('V4567')),' ','.')

hi,

You have to use for each T - Sql satements

you should check,

on error goto err

if @@error<>0

go to err

err:

Rollback Transaction

HI ,

USE THIS,

SELECT  NAME_COL,

       (SELECT MAX(REV_NO) FROM TABLE_A WHERE B.NAME_COL=NAME_COL AND B.KEY_COL=KEY_COL)

       ORDER_NO,

       KEY_COL

FROM TABLE_A B

GROUP BY NAME_COL,

         ORDER_NO,

         KEY_COL

Hi,

You can use the following Query !!!

select client_name,count(*) from <table>

group by dateadd(mm,-1,ticket_date)

order by ticket_name

i hope this would be your answer!!!

which you are trying to ask.

hi ls,

you can use this,

declare @mm_month int

set @mm_month=5

select len(@mm_month),str(@mm_month,2)

select cast(replace(str(@mm_month,2),' ','0') as varchar(2)) + '/' + '01' + '/' + cast(year(getdate()) as varchar(4))

you will get your answer!!!

you can use the following query ?

select * from

student s join studentcourse sc

on <join condition>

join

course c

on <join condition>

use the DTS wizard for impot/export the records??

You can use the following Query :

update test_update

set name=(case when id=1 then 'aaa'

                       when id=2 then 'bbb'

                        when id=3 then 'ccc'

                else null end)

where id=?

use the following steps if you can :

1) stop the services of your sql server.

2) copy the mdf and ldf files into floppy

if small or write ait into cd...

you may use the following command:

if not exists (select * from information_schema.columns where table_name=<tbl_name> and column_name=<col_name&gt

begin

alter table table_name add col_name <type>

end

use it and ask...

It may happen that which script you are using

contains such objects (i.e. tables or views or procedures) are accessed by some transactions.

In that case you have to first kill the...