type User struct { Id uint `gorm:"column:id"` Mobile string `gorm:"column:mobile"` Bind bool `gorm:"column:bind"` } func (u User)TableName() string { return "bs_member" } func main() { connString := fmt.Sprintf("server=%s;port=%d;database=%s;user id=%s;password=%s",host,port,database,user,password) db,err := gorm.Open("mssql",connString) if err != nil{ panic(err) } db.LogMode(true) defer db.Close() var users []User db.Limit(10).Order("id asc").Find(&users) for _,u := range users{ fmt.Println(u.Mobile) } }
gorm连接sqlserver 2012,limit函数使用Offset /Fetch Next需要指定排序,即必须有order by ***