Database

sajid.salim.khan wrote:

any book

sajid.salim.khan wrote:

to study database from a to z

merwa wrote:

I create a new DataBase in the user pc i want to script some assistant information in a certain tables in the created DataBase.

SELECT Product.*,ProductInCategory.*,Category.*<br />
FROM Product,ProductInCategory,Category<br />
where Product.ID = ProductInCategory.[ProductID]<br />
and ProductInCategory.CategoryID = Category.[ID]<br />
and  Product.[ID] = '9780817637606';

SELECT *
FROM ProductInCategory
   INNER JOIN Product
      ON Product.ID = ProductID
   INNER JOIN Category
      ON CategoryID = Category.[ID]
WHERE Product.ID = '9780817637606';

insert into UserTable values (@UserName, HashBytes('SHA1', @UserName + @Password))

select 1 from UserTable
  where UserName = @UserName
  and PasswordHash = HashBytes('SHA1', @UserName + @Password)

SQL = "SELECT username, lpassword  FROM clientlist WHERE username ='" & UserName & "'" & _<br />
" AND lpassword = '" & sPassword & "'"