How to implement SQL to get the show_table.vbs of table structure
This article mainly introduces how to achieve SQL to get the show_table.vbs of the table structure, the article introduces in great detail, has a certain reference value, interested friends must read it!
The code is as follows:
Set arg=wscript.arguments
If arg.count = 0 Then
Show_help ()
Wsh.quit
End If
Server = arg (0)
User = arg (1)
Pass = arg (2)
Database_name = arg (3)
Table_name = arg (4)
Set Conn = CreateObject ("ADODB.Connection")
Conn.Open "Driver= {SQL Server}; Server=" & Server & "; UID=" & User & "; PWD=" & Pass & "; Database=" & database_name
Set rs = conn.execute ("select count (*) as n from" & database_name & ".dbo.sysobjects where id = object_id (N' [dbo]. [" & table_name & "]'))
If rs ("n")
