CREATE PROCEDURE usp_DropColumn

@TableName Varchar(50),

@ColumnName Varchar(50)

AS

/*====================================================================================================

NAME:  usp_Dropcolumn      CREATED BY: SD

TYPE:  stored procedure (SQL 7)    CREATION DATE: 08/01/01

USAGE:

DECLARE @TableName Varchar(50)

DECLARE @ColumnName Varchar(50)

SET @TableName = 'MyTable'

SET @ColumnName = 'MyColumn'

Exec usp_DropColumn @TableName, @ColumnName

PURPOSE : To Drop a Column from a Table...

Thankx It works

Thankx Philcart

If u go to the server settings of the propeties dialog,

there is some settings calles Server Behavior

Can we change those from a script

!

If I got your problem correctly,

u can use Like command

i.e.

Where Course_ID Liek 'ISM%'

is this the answer you are looking for

refer this

http://www.sqlservercentral.com/columnists/dasanka/findminmaxvaluesinaset.asp

u can put rank + 600 ( I think , Sorry I could n't check)

SQl Server 200 does not have a unique record number like Oracle (I guess&nbsp

But U can wirte quiries to get the unique record number...

Thankx Tatsu

select sum (a) from (select sum(amount* -1) as a from TABLENAME where RecordType = 20 union all

select sum(amount) as a from table1 where RecordType <> 20) a

will give you the...

Very sorry for my porr english. I try to minize those in my next articles. Thank you very much for the comments. Its really helps me

In my case,

I have a application which has hard code the db name , so to test the new upgrades with the old db i need to have two instances

I had a practical some times back when I use insert command for datatime field. I got this problem when I am doing this korean charactors.

When this data time was...

If some thing can go wrong it will go wrong. that is a theory. therefore it will be very much advisable to stop every where error can occur

for the public holidays, you need to keep them  in a table. then you can modify the above function to work accordingly

Hope you all got the invitation. if not forgive me and send me a mail to my gmail id