ASP.NET MVC 3 Walkthroughs & Books 1. Intro to ASP.NET MVC 3 - Rick Anderson http://www.asp.net/mvc/tuto... 2. Building an MVC 3 App with Database First – Julie Lerman a. http://msdn.microsoft.com/e... 3. Walkthrough: Retrieving Entity Types with a Stored Procedure (Entity Data Model Tools a. http://msdn.microsoft.com/e... 4. Book – Wrox - Professional ASP.NET MVC 3 http://www.wrox.com/WileyCD... ......
Create PROCEDURE [dbo].[ts_Dates] @isTo bit AS /* ---------------------------... --Last Dates Display-Value Pair for DropDown List for date greater than ---------------------------... exec [dbo].[ts_Dates] 0 exec [dbo].[ts_Dates] 1 */ declare @minToDate datetime declare @minFromDate datetime select @minToDate = min(<date>) from <table>; select @minFromDate = DATEADD(MONTH,-1,min(<da... from <table>; --print @minToDate --print ......
Thanks to AndraaxAged Yak Warrior http://www.sqlteam.com/foru... Generate insert SQL for a table - Insert this stored proc: create proc [dbo].[generate_inserts] @table varchar(50) --Generate inserts for table @table AS declare @cols varchar(1000) declare @col varchar(50) /* generate_inserts 'PlanLevel1ControlResponsib... */ set @cols='' declare colcur cursor for select column_name from information_schema.columns where table_name=@table open colcur fetch next from colcur ......
---------------------------... --all info from Tables ---------------------------... SELECT * FROM sys.Tables ---------------------------... --Schema.name from Tables ---------------------------... SELECT '['+SCHEMA_NAME(schema_id)+... AS SchemaTable FROM sys.tables ---------------------------... --Schema, name from Tables ---------------------------... ......