-- Store Procedure select [name],[type],type_desc,modify_date from sys.objects where modify_date > '2010-01-29' and type='P' order by modify_date desc -- Table select [name],[type],type_desc,modify_date from sys.objects where modify_date > '2010-01-29' and type='U' order by modify_date desc --View select [name],[type],type_desc,modify_date from sys.objects where modify_date > '2010-01-29' and type='V' order by modify_date desc --Function select [name],[type],type_desc,modify_date from sys.objects where modify_date > '2010-01-29' and type in ('FN','TF') order by modify_date desc
感謝 Ken 的介紹,
讓我茅塞頓開。
沒有留言:
張貼留言