this have an introduction to handling error in Sps

http://www.sqlteam.com/item.asp?ItemID=2463

If I can remeber correct there was article in SQLServeCentral.com. search the site. good luck

 select sum(cast( isnull([CostPriceTotal] ,0) as float)) will do

Using unicode data types such as nchar, nvarchar, ntext will allow you to save in different languages.

I have done this for korean, chineese and english

My personal view on the certification is, it is nice to have feature in you rather than a required feature. Having being in the database area for quite some...

got it. thankx simple query

read the capacity specifications-SQL Server section of the BOL

You can create table like this

CREATE TABLE [dbo].[t1] (

 [date] [smalldatetimer], [amt_recharge] [int] NULL ,

 [amt_food ] [int] NULL ,

 [bc] AS ([amt_recharge] + [amt_food])

) ON [PRIMARY]

GO

Search for the SQL80.col. If this is not in the pc then u hav eto install the book on line

use this sp

CREATE PROCEDURE usp_DropColumn

@TableNameVarchar(50),

@ColumnNameVarchar(50)

AS

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

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

USAGE:

DECLARE @TableNameVarchar(50)

DECLARE @ColumnNameVarchar(50)

SET @TableName = 'MyTable'

SET @ColumnName = 'MyColumn'

Exec usp_DropColumn @TableName, @ColumnName

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

select * from sysobjects where xtype ='D' and parent_obj = OBJECT_ID('Table1')

above will give you all the default constrainst that the table1 has

insert into tblStudent_Sponsor(intStudentID, intSponsorID)

select distinct studentid,sponsorid

from tblContractRates

remove values, for futher details refer the BOL

HI Rohan,

I had the same porblem some time back.

I used VB exe to achieve this.

This vb reads the SQL script so that i don't have to change exe again and...

thankx for the infoamrtion

hmm

Good Trick

Thankx