<%@ CodeTemplate Language="C#"
TargetLanguage="T-SQL" Description="Generates a update stored
procedure." %> return param; CREATE PROCEDURE dbo.Insert<%= SourceTable.Name
%> insert [<%= SourceTable.Name %>]
select @@identity |
<%@ CodeTemplate Language="C#"
TargetLanguage="T-SQL" Description="Generates a update stored
procedure." %> return param; CREATE PROCEDURE dbo.Update<%= SourceTable.Name
%> update [<%= SourceTable.Name %>]
set
|
<%@ CodeTemplate Language="C#"
TargetLanguage="T-SQL" Description="Generates a update stored
procedure." %> return param; CREATE PROCEDURE dbo.Get<%= SourceTable.Name
%> select |
<%@ CodeTemplate Language="C#"
TargetLanguage="T-SQL" Description="Generates a update stored
procedure." %> ----------------------------------------------------------------- CREATE PROCEDURE List<%= SourceTable.Name
%> set nocount on select @RecordCount=count(*) from [<%=
SourceTable.Name %>] if ((@PageNum * @PageSize) > @RecordCount)
set rowcount @RowCount
set rowcount @RowCount
|