select TOP 1 * from sys.procedures order by create_date desc
select TOP 1 * from sys.tables order by create_date desc
select TOP 1 * from sys.views order by create_date desc
/*
CREATE PROC jkAlterProcTest
AS
SELECT 1
CREATE TABLE jkAlterTableTest (a int)
CREATE VIEW jkAlterViewTest
AS
SELECT a
FROM jkAlterTableTest
ALTER PROC jkAlterProcTest
AS
SELECT 2
ALTER TABLE jkAlterTableTest ADD b int
ALTER VIEW jkAlterViewTest
AS
SELECT a, b
FROM jkAlterTableTest
*/
Wednesday, January 6, 2016
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment