“SELECT * FROM tblTest” “SELECT SupplierID, CompanyName FROM dbo.Suppliers;” “SELECT AuthorID, LastName, FirstName FROM Authors” “SELECT * FROM tblUsers WHERE UserId=” + Convert::ToString(UserId) WHERE Multiple SELECT’s “SELECT SomeColumnName, SomeOtherColumnName FROM SomeTableName WHERE … SELECT AS “SELECT SomeColumnName AS ‘The Name I Want To Use’ FROM SomeTableName WHERE … Multiple WHERE’s “SELECT * FROM SomeTableName WHERE […]
All posts by
Does Table Exist
SqlCommand1 = gcnew SqlClient::SqlCommand(); SqlCommand1->Connection = SqlConnection1; SqlCommand1->CommandType = CommandType::Text; SqlCommand1->CommandText = “SELECT count(*) FROM sysobjects WHERE name =’tblLocations'”; if (!Convert::ToBoolean(SqlCommand1->ExecuteScalar())) //True if label does exist { }