how to get list of tables, functions and stored procedure created last month in sql server

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables where create_date >='03/01/2015'
       
       
       
       
        SELECT * FROM sys.procedures WHERE  create_date >='03/01/2015'

SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF')  -- scalar, inline table-valued, table-valued

Comments

Post a Comment

Popular posts from this blog

i am writing With sad hearts some problems with my windows phone samsung omnia w

Last month i bought a Windows phone Samsung Omnia W.... After a few days i realise the some problem with it...... WP7.5 (Mango) is already in its second generation but it still has many restrictions, limitations and serious usability issues. This is a list of its shortcomings as compared with other smartphone OS in the market. We are not comparing special features or abilities but those which have become the norm for all smartphones and even dumb phones. An Android, Symbian or MeeGo phone would have almost none of these shortcomings. An iphone share some restrictions with WP7.5 but is still miles ahead. Even the Nokia N9 running the first generation MeeGo OS is far better with none of the disastrous issues which impact on the sheer usability of the phone. OS LIMITATIONS 1. No true multitasking - apps are frozen in the background. 2. No Divx/Xvid video codec support. Zune will convert with loss of quality. 3. No mass storage mode. 4. No micro-SD card support. 5. Only suppor...
Read more

Delete Duplicate Records in DataBase sql server

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........
Read more