Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 TABLE ERRORS.

Author  Topic 

Hinduson
Yak Posting Veteran

69 Posts

Posted - 2013-09-27 : 12:49:30
Please can someone help me out with how to create this table in sql.

Table : supplier.supplierDetails
*SupplierID must be auto generated.
*FirstName,LastName,Address,Phone, and Country should not be left Blank
*Phone number must be in the following format.
'[0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9]'

Best Regards.

Best Regards.
   

- Advertisement -