delete all record in table in sql server

[ahmeddc]

hi


I want to delete all fields of the table with stored procedures in sql server 2014


stored procedures

ALTER proc [dbo].[DELETEBILLHEADSAV](
@BILLHEADSAV_ID int )

as

DELETE FROM BILLHEADSAV_TB WHERE BILLHEADSAV_ID>='0'

code not work

Dim comA As New SqlCommand()
comA.CommandType = CommandType.StoredProcedure
comA.CommandText = "DELETEBILLHEADSAV"

comA.Connection = con
con.Open()
comA.ExecuteNonQuery()
con.Close()

Continue reading...