Hi Try the following script it will work for your reuirement

CREATE TABLE [practicedb].[dbo].[template_practice](

[LTM_INV_CD] [char](10) NOT NULL,

[LTM_TMP_CD] [char](9) NOT NULL,

CONSTRAINT [PK_template_practice] PRIMARY KEY CLUSTERED

(

[LTM_INV_CD] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Hi Try the following......

if exists(select * from sysobjects where name ='a')

begin

print 'passed'

UPDATE a

SET a.b = 1

...

Hey Guys,

Please check the following link there it is showing, Level is "SSChampion" for...