User Profile

Collapse

Profile Sidebar

Collapse
rvvvprasad
rvvvprasad
Last Activity: Nov 11 '11, 09:51 AM
Joined: Nov 9 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • rvvvprasad
    started a topic sql if conditons

    sql if conditons

    can any one explain what below code means

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ht_litigatio n_ht_mast]') and OBJECTPROPERTY( id, N'IsForeignKey' ) = 1)
    ALTER TABLE [dbo].[ht_litigation] DROP CONSTRAINT FK_ht_litigatio n_ht_mast
    GO

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ht_mutation_ Ht_mast]') and OBJECTPROPERTY( id, N'IsForeignKey' ) = 1)...
    See more | Go to post

  • rvvvprasad
    started a topic server msg :207 errror

    server msg :207 errror

    when i am trying to updating values into newly added column i am getting error which says "Invalid column name 'surveytax'.
    Server: Msg 207, Level 16, State 1, Line 3"

    pls help me...
    See more | Go to post
No activity results to display
Show More
Working...