随笔分类 -  数据库相关

摘要：ID not null IDENTITY(0, 1) it means, that the feild will automatic growth. at init, field ID is 0, then add one record, ID field will increse 1. 阅读全文

摘要：when we excute sql script, the absolute path is too long, so what can do ?you can set Environment Variables "SQLPATH"example:SQLPATH=c:\test\test;C:\t 阅读全文

摘要：i don't konw before that we can use visio get picture of table relation, so record here, if one day met the problem, i can try to do it by visio. 阅读全文

摘要：Return Type The number of rows changed, inserted, or deleted. -1 for SELECT statements; 0 if no rows were affected, or the statement failed. "selectt0 阅读全文