Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done January 2012 Entries
ASP.NET MVC 3 Walkthroughs & Books
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... ......

Posted On Tuesday, January 31, 2012 8:45 AM

Last n Months Display-Value Pair for DropDown List greater than a minimumm date
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 ......

Posted On Tuesday, January 31, 2012 6:43 AM

Generate insert SQL for a table
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 ......

Posted On Thursday, January 12, 2012 9:17 AM

list schema, table, row count in a database
---------------------------... --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 ---------------------------... ......

Posted On Sunday, January 8, 2012 7:40 PM

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net