SQL server取得所有table資料筆數的方法 « oDDs.Bl@H
SQL server取得所有table資料筆數的方法以下指令可以查詢SQL server資料庫所有table的資料筆數 (由大到小排列)。可以很快知道資料筆數大的table，並做進一步管理。
select o.name, i.rows
from sysobjects o inner join sysindexes i on o.id = i.id
where i.indid = 1
order by i.rows desc另一個好用的store procedure是sp_spaceused，這個指令可以查詢某個table目前的資料筆數和資料所佔的硬碟空間，指令如下：
exec sp_spaceused ‘’
一般認知上，LenB是傳回位元組的長度，
如此對於雙位元文字如中文、全形字等，
我們可取得字元(Byte)數而不是字數。例如：
mystr = “測試"
Len(mystr) –> 2
LenB(mystr) –> 4
Tech on the Net is dedicated to providing helpful advice, how-to’s and FAQs. We focus on technologies such as Microsoft Access, Microsoft Excel, Microsoft Word, SQL, Oracle/PLSQL, UNIX, and Linux.The information presented here is suitable for all programmers from beginner to expert. We hope you find this information useful and return to our site, as we expand our information base.
Forums
We’re proud to offer a new feature to our site called techonthenet.com Forums. We encourage you to visit the forums to post questions and answers relating to Oracle, Microsoft Access, and Microsoft Excel. Or just browse the forums to find answers to many of the questions that you may have.
You can access the techonthenet.com Forums by clicking on the Forums link in the Navigation bar at the top of any one of our pages. Register now and be one of the first to post!
请问微软专家！！！如何用ADO.NET 枚举数据库的表、字段及类型长度等 .NET技术 / 其他 – CSDN社区 community.csdn.net
CREATE PROCEDURE sp_columns (
@table_name nvarchar(384),
@table_owner nvarchar(384) = null,
@table_qualifier sysname = null,
@column_name nvarchar(384) = null,
@ODBCVer int = 2)
AS
DECLARE @full_table_name nvarchar(769)
DECLARE @table_id int
ACC: How to Find If an Object Exists in a Database
ACC: How to Find If an Object Exists in a Database
in Access
documenting ACCESS – listing all ControlSource instances
SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32768) AND ([Name] Not Like ‘~*’))
ORDER BY MsysObjects.Name;
If you want to move vmware guest machine from linux to windows, you have to change xxxx.vmx
.encoding = “windows-1252″
to
.encoding = “UTF-8″
在vista, xp的dos下也可以使用這個指令來更改ip address
How to Use the NETSH Command to Change from Static IP Address to DHCP in Windows 2000
先用這個指令來看你的網卡名稱
C:\>Netsh interface ip show config
介面 “無線網路連線" 的設定
已啟用 DHCP: 是
IP 位址: 192.168.103.100
子網路首碼: 192.168.103.0/24 (遮罩 255.255.255.0)
預設閘道: 192.168.2.1
閘道公制: 0
預設閘道: 192.168.103.254
閘道公制: 0
介面公制: 25
透過 DHCP 設定的 DNS 伺服器: 192.168.103.254
以哪個尾碼登錄: 僅主要尾碼
透過 DHCP 設定的 WINS 伺服器: 無
再用下列指令來更改ip
C:\>netsh interface ip set address “無線網路連線" static 192.168.0.10 255.255.255.0 192.168.0.1 1
http://dba.fyicenter.com/faq/sql_server_2/EXECUTE_Executing_Stored_Procedures.html