Truncate data from all tables in a database
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
478 reads
Grant EXECUTE permission to users
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
213 reads
Blogs
RMOUG Training Days in Denver
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Forums
Modify RDS page missing the Storage Autoscaling option
Hi folks, I have a single Postgres instance on RDS that in the past...
how to make a col in a table after checking its existence, in one stmt
hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME IN...
Coaching the Digital Transformation
Comments posted to this topic are about the item Coaching the Digital Transformation
Ask SSC