SUJOY SANTRA

Wednesday, 19 August 2015

Check a table exists or not in database in SQL

IF OBJECT_ID (N'mytablename', N'U') IS NOT NULL
   SELECT 1 AS val  
ELSE
    SELECT 0 AS val;
Posted by sujoy santra at 12:53 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Search This Blog

Blog Archive

  • ▼  2016 (3)
    • ▼  September (1)
      • Maintaining State of CheckBoxes to checked While ...
    • ►  February (1)
    • ►  January (1)
  • ►  2015 (89)
    • ►  December (3)
    • ►  November (2)
    • ►  October (5)
    • ►  September (8)
    • ►  August (16)
    • ►  July (1)
    • ►  June (18)
    • ►  May (2)
    • ►  March (14)
    • ►  February (11)
    • ►  January (9)
  • ►  2014 (141)
    • ►  December (5)
    • ►  November (13)
    • ►  October (11)
    • ►  September (3)
    • ►  August (16)
    • ►  July (7)
    • ►  June (9)
    • ►  May (32)
    • ►  April (16)
    • ►  March (13)
    • ►  February (13)
    • ►  January (3)
  • ►  2013 (69)
    • ►  December (6)
    • ►  November (2)
    • ►  October (3)
    • ►  September (6)
    • ►  August (43)
    • ►  July (5)
    • ►  June (4)

About Me

My photo
sujoy santra
Bakhrahat, West Bengal, India
View my complete profile

Popular Posts

  • Implement Mutually Exclusive CheckBoxList (CheckBoxes) inside GridView in ASP.Net
    Mutually exclusive CheckBoxList means when one CheckBox is checked, all other CheckBoxes present in the CheckBoxList will be unchecked.  ...

Total Pageviews

Picture Window theme. Powered by Blogger.