Clear all data in DB table
来源:互联网 发布:mac蓝牙鼠标连接方法 编辑:程序博客网 时间:2024/05/22 22:57
USE database
--
DECLARE @SQL VARCHAR(8000)
SET @SQL = ''
SELECT @SQL = @SQL + 'DELETE FROM [' + [Name] + '];' + CHAR(10) FROM SYS.OBJECTS WHERE TYPE='u'
--
SET @SQL = @SQL + @SQL + @SQL
PRINT @SQL
BEGIN TRY
EXEC(@SQL)
END TRY
BEGIN CATCH
END CATCH
- Clear all data in DB table
- Create Table in HANA DB
- Extracting data in Table maintenance
- check if filed exists in all tables in current DB
- groovy Exports all table names in database
- 4.7 Displaying Hierarchical Data in Table Views
- Update one table with the data in another table
- Update one table with the data in another table
- building block can create db table & schema in Bb 9.1
- Parameterized Query in OLE DB data source component
- How to use NQ logs to check data in DB
- Get the rows count of all the table in Sybase
- Drupal7 truncate/clear all cache
- DB太大?一键帮你收缩所有DB文件大小(Shrink Files for All Databases in SQL Server)
- exception in initAndListen: 29 Data directory /data/db not found., terminating
- C# Tips: Draw a data table in console
- Display custom fields data in an HTML table
- SQL Programming(5):Presenting Data in a Table View
- 记录:搭建QT4.3.5-X11平台的过程
- isos系统工作笔记3
- 字符类型转换
- 萬惡淫為首,百善孝為先
- isos系统工作笔记4
- Clear all data in DB table
- TRACE32调试技巧
- treeview 數據保存後的更新
- oralce 存储过程
- NHibernate+Oracle10g搭建一个项目架构全程解析(一)
- ASP.NET系统用户权限设计与实现
- isos系统工作笔记5
- 关于Base64编码
- isos系统工作笔记6