Contribute to OPS-E2E-PPE/sql-docs development by creating an account on GitHub.

Download the sp-alter-column.sql, this script creates the sp_alter_column stored procedure in your database! Enjoy!

In this article we will learn how to check if a stored procedure exists before creating it. We can use the below script which will drop the proc if it exists and then recreate it.

INFORMAT= specifies the informat to be used when SAS accesses data from a table or view. You can change one permanent informat to another by using the ALTER statement. PROC SQL stores informats in its ...