在源码中遇到select * from sqlserver..sys_update这样的语句
各位大侠,小弟初学程序希望大家能多多指教。
小弟在看一段程序源吗的时间遇到这样的代码,请问中其中的Hxxdsys..HDSystem_Databases不知道是什么意思,在线等!第一次来不知道怎给他就填了个中间数,万分感激!
Private Function Ljyxxpd() As Boolean
Dim DBPassWord As String
Dim DBUser As String
DBPassWord = "SQL123 "
DBUser = "MLand "
Xtsjljc = "Provider=SQLOLEDB.1; "
Xtsjljc = Xtsjljc + "Persist Security Info=False; "
Xtsjljc = Xtsjljc + "Data Source= " + Trim(ServerText.Text) + "; "
Xtsjljc = Xtsjljc + " Initial Catalog= " + "HxxdSys " + "; "
If Cslj.State = 1 Then Cslj.Close
Cslj.Open Xtsjljc, DBUser, ErpPassWord
End Sub
Private Sub Tcztxx()
Dim Xtztxxrec As New ADODB.Recordset
Set Xtztxxrec = Cw_DataEnvi.BaseInfoConnect.Execute( "Select * From Hxxdsys..HDSystem_Databases order by number ")
ZtCombo.Clear
With Xtztxxrec
Do While Not .EOF
If .Fields( "YNuse ") = "1 " Then
ZtCombo.AddItem .Fields( "number ") + "- " + Trim(.Fields( "CountingRoomName "))
End If
.MoveNext
Loop
End With
End Sub
------解决方案--------------------Select * From Hxxdsys..HDSystem_Databases order by number
Hxxdsys..HDSystem_Databases
数据库名 Hxxdsys
拥有者 dbo (省略了)
表名 HDSystem_Databases