Query record in tables..

**matrik02** · May 30th, 2008, 10:06 AM

I would like to know, the general consept how to query the tables?

I have the piece of SQL command here..

Code:

sSqlCmd = "CREATE PROCEDURE UMNO as SELECT PLOT FROM Pemilik"

How I can delete the UMNO Query tables?I got error because this query tables already exist.. so I want to delete this query tables if found

**CVMichael** · May 30th, 2008, 10:09 AM

Why not just:

Code:

sSqlCmd = "SELECT PLOT FROM Pemilik"

?

**mendhak** · May 30th, 2008, 03:34 PM

Code:

IF EXISTS(SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'tablename') AND type = (N'U')) 
BEGIN
   DROP TABLE tablename
END

Thread: Query record in tables..