DECLARE @procName varchar(100)
DECLARE @cursorProcNames CURSOR
SET @cursorProcNames = CURSOR FOR
select s.name from sysobjects s where type = 'P' AND S.NAME NOT LIKE '%sp_alterdiagram' and s.name not like '%sp_alterdiagram' and s.name not like '%sp_renamediagram' and s.name not like '%sp_dropdiagram' and s.name not like '%sp_helpdiagrams' and s.name not like '%sp_creatediagram' and s.name not like '%sp_upgraddiagrams' and s.name not like '%sp_helpdiagramdefinition%'
OPEN @cursorProcNames
FETCH NEXT
FROM @cursorProcNames INTO @procName
WHILE @@FETCH_STATUS = 0
BEGIN
set nocount off;
-- exec sp_HelpText @procName --or show their text
print @procName
FETCH NEXT
FROM @cursorProcNames INTO @procName
END
CLOSE @cursorProcNames
DEALLOCATE @cursorProcNames
Posts
Getting the Current TabItem when the Tab is not selected in WPF
-
[image: Banner]
This is a quick reminder to self on how to retrieve a TabItem from a WPF
TabControl *when the tab is not currently selected* because I ru...
2 weeks ago
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!