怎么清空 sql server 2005数据库中一个表内的全部数据-ZOL问答

5个回答默认排序

默认排序

按时间排序

已采纳

delete from table_name 清除表中的所有数据、保留表结构
Truncate table table_name 清除表中所有行，保留表结构、与delete类似
比delete速度快,而且效率高，使用的系统和事务日志资源少

drop table table_name 删除表(所有数据及表结构)

取消评论

数据库推荐

超值推荐

sjjsjjsjjsjjsjjs

public void ReadTxt(int a,int b)
{
StreamReader objReader = null;
int Qty = 0;
this.textBox4.Text = ;
try
{
objReader = new StreamReader(this.textBox3.Text.ToString().Trim());
string sLine = ;
ArrayList LineList = new ArrayList();
while (sLine != null)
{
DataSet lot = null;
string sqlstr = ;
string retrunMessage = ;
sLine = objReader.ReadLine();
if (sLine != null && !sLine.Equals())
{
if (sLine.Contains(-))
{
if (b != 17)
{
showMessage(MAC格式为4C-AC-0A-8A-B4-7D，长度必须为17, true);
this.textBox2.Text = ;
this.textBox2.Focus();
return;
}
}
if (!sLine.Contains(-))
{
if (b != 12)
{
showMessage(MAC格式为4CAC0A8AB47D，长度必须为12, true);
this.textBox2.Text = ;
this.textBox2.Focus();
return;
}
}
sqlstr = EXEC [dbo].[TXN_MES_CSPrint] +
@I_PlugInCommand = N' + PlugInCommand + ', +
@I_OrBitUserId = N' + OrBitUserId + ', +
@I_ResourceId = N' + ResourceId + ', +
@MAC = N' + sLine.Substring(a, b).Replace(-,) + ', +
@CSPInfo = N' + sLine + ';
lot = GetDataSetWithSQLString(sqlstr);
this.Cursor = Cursors.Arrow;
if (lot.Tables[0].Rows.Count 0)
{
int result = (int)lot.Tables[0].Rows[0][I_ReturnValue];
if (result == 0)
{
Qty++;
this.textBox4.Text = Qty.ToString();
retrunMessage = lot.Tables[0].Rows[0][I_ReturnMessage].ToString();
showMessage(retrunMessage, false);
}
else
{
retrunMessage = lot.Tables[0].Rows[0][I_ReturnMessage].ToString();
showMessage(retrunMessage, true);
}
}
else
{
retrunMessage = 文本记录中不存在测试数据！;
showMessage(retrunMessage, true);
}
}
else
{
showMessage(截取文本数据已完成或文本数据为空！, false);
}
}
objReader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{ objReader.Close(); }
}
--- 存储过程
-- =============================================
-- Author: Author,,Name
-- Create date: Create Date,,
-- Description: Description,,
-- =============================================
ALTER PROCEDURE [dbo].[TXN_MES_CSPrint]
@MAC nvarchar(50)='',
@CSPInfo nvarchar(500)='',
@CSPFormat nvarchar(500)=''
AS
BEGIN
--begin----插入测试数据--------------------
if @MAC is null or @MAC=''
begin
set @I_ReturnMessage='ServerMessage:当前截取数据中MAC不存在!'
select -1 as I_ReturnValue,@I_ReturnMessage as I_ReturnMessage
return -1
end
--if @CSPInfo is null or @CSPInfo=''
--begin
-- set @I_ReturnMessage='ServerMessage:当前截取数据为空!'
-- select -1 as I_ReturnValue,@I_ReturnMessage as I_ReturnMessage
-- return -1
--end
if exists(select MAC from CSPrint where MAC=@MAC)
begin
set @I_ReturnMessage='ServerMessage:当前截取数据已存在!'
select -1 as I_ReturnValue,@I_ReturnMessage as I_ReturnMessage
return -1
end
--申请主PKID
declare @CSPrintId char(12)
exec SysGetObjectPKid '','CSPrint',@CSPrintId output
--写入数据库表
insert into CSPrint (
CSPrintId,
MAC,
CSPInfo,
CSPFormat,
Createdate
)
Values (
@CSPrintId,
@MAC,
@CSPInfo,
@CSPFormat,
GETDATE()
)
--------end-----------------------------
set @I_ReturnMessage='ServerMessage:截取数据保存成功!'
select 0 as I_ReturnValue,@I_ReturnMessage as I_ReturnMessage
return 0
END

取消评论