Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
delete all data from given scheme tables
--'audit' in this case Exec sp_msforeachtable @command1 = ' if (Select Object_Schema_name(object_id(''?''))) = ''audit'' Begin TRUNCATE TABLE ? print ''truncated '' + ''?'' End '
run
|
edit
|
history
|
help
1
Please
log in
to post a comment.
№5
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3
First Query
SQL Problem Template
Subb7
BTVN_QLDT_TUAN 8
QLSV
SCHOOL-BUILD
joins
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
stackse - search stackoverflow differently
Please log in to post a comment.