select
'EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'''
+ reverse ( substring ( reverse ( substring ( name , 9 , len(name)) ) ,
11 , LEN ( reverse ( substring ( name , 9 , len(name)) ) )))
+ ''''
from sys.procedures where name like 'procGen%_selectAll'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'NamingConvention'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'PlAddNew'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'PlEditItem'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'TestCase'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'RequirementHistory'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'StatusForObject'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'PlSearchItem'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'PageTypeMsg'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Status'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Specification'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Functionality'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'TaskHistory'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Task'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'msg'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'MenuItem'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Bug1'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'AppSetting'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'GuiPage'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Menu'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'LogStore'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Company'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'FunctionalityHistory'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Requirement'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'Bug'
EXEC [dbo].[procUtils_GenerateSelectAllView] @TableName = N'BugHistory'
Posts
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 !!!!