vstudiojourney.blogspot.com
Visual Studio Journey: Temp Tables in SQL Server
http://vstudiojourney.blogspot.com/2013/02/temp-tables-in-sql-server.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Tuesday, February 12, 2013. Temp Tables in SQL Server. We all know you can create variables in SQL Server. But what if there is a need to store more complex data? As it turns out, there is an easy way to accomplish that as well. Declare @csrlist Table(customer varchar(20), CSR varchar(25), counts int). Get the counts of customer service reps orders for each customer. Insert into @csrlist (customer, csr, counts). Net Jobs on DICE.
vstudiojourney.blogspot.com
Visual Studio Journey: August 2013
http://vstudiojourney.blogspot.com/2013_08_01_archive.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Thursday, August 29, 2013. This simple class exposes a static method to take a MailMessage object and represent it as a block of text. I ran into this because when an emailer program I wrote started getting error messages, the only thing I got in the error log was. So - to track the problem, I wanted to quickly see what the mailmessage looked like and include it in my error notifications. Here is the class. Posted by Some Yahoo.
vstudiojourney.blogspot.com
Visual Studio Journey: January 2014
http://vstudiojourney.blogspot.com/2014_01_01_archive.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Thursday, January 9, 2014. Dramatically Speed Up Stored Procedures using Temp Tables. If you're wondering how to create a list, or temp table in a SQL Server Stored Procedure, look here. But what if you're joining to an in-memory table and you experience performance issues? Pick list id integer. Simple enough, right? Pick list id integer not null PRIMARY KEY. Not bad for one modified line of code! Posted by Some Yahoo. This is on...
vstudiojourney.blogspot.com
Visual Studio Journey: Job Listings
http://vstudiojourney.blogspot.com/p/job-listings.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. These job openings for ASP.NET developers are brought to you by DSLWest. Subscribe to: Posts (Atom). Issuing Direct SQL from MVC5. Issuing Direct SQL from MVC5. DataGridView Visual Studio 2010 Tutorial. The help never never never helps. Visual Studio 2010 Tutorial. Visual Studio Express 2008. Visual Web Developer 2008. Monster Job Search Results C# ASP.NET Visual Studio. Net Jobs on DICE. INSTEAD, CONSIDER HIRING SOFTWARE SERVICES.
vstudiojourney.blogspot.com
Visual Studio Journey: Questions
http://vstudiojourney.blogspot.com/p/questions.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Use this page to ask us a question. If you want to comment on a specific article, it's better to use the Comments link at the bottom of each article. Subscribe to: Posts (Atom). Issuing Direct SQL from MVC5. Issuing Direct SQL from MVC5. DataGridView Visual Studio 2010 Tutorial. The help never never never helps. Visual Studio 2010 Tutorial. Visual Studio Express 2008. Visual Web Developer 2008. Net Jobs on DICE.
vstudiojourney.blogspot.com
Visual Studio Journey: Dramatically Speed Up Stored Procedures using Temp Tables
http://vstudiojourney.blogspot.com/2014/01/dramatically-speed-up-stored-procedures.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Thursday, January 9, 2014. Dramatically Speed Up Stored Procedures using Temp Tables. If you're wondering how to create a list, or temp table in a SQL Server Stored Procedure, look here. But what if you're joining to an in-memory table and you experience performance issues? Pick list id integer. Simple enough, right? Pick list id integer not null PRIMARY KEY. Not bad for one modified line of code! Posted by Some Yahoo. Visual Stu...
vstudiojourney.blogspot.com
Visual Studio Journey: December 2013
http://vstudiojourney.blogspot.com/2013_12_01_archive.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Friday, December 27, 2013. Windows 8 is Costing You Money. Your Money is Being Sucked Down a Hole. Now, I can see there might. Be problems if I were trying to shoehorn grids into grids, or streaming media into 20,000 rows of data. but really I am doing nothing out of the ordinary here. Bryan Valencia is a contributing editor and founder of Visual Studio Journey. He owns and operates Software Services. Posted by Some Yahoo. Whenev...
vstudiojourney.blogspot.com
Visual Studio Journey: Column Modification Checklist
http://vstudiojourney.blogspot.com/2014/01/column-modification-checklist.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Tuesday, January 7, 2014. This is one of those things that I always forget part of, so because I just went through this, I thought I would document what needs to be done to sync your application whenever you modify any column in your database. This tutorial is designed for:. Visual Studio (for web or desktop). In SQL Server Management Studio (SSMS). In your Desktop App:. EXECUTE sp refreshview 'dbo.v myViewName';. Your stored pro...
vstudiojourney.blogspot.com
Visual Studio Journey: August 2015
http://vstudiojourney.blogspot.com/2015_08_01_archive.html
Sharing the joys and frustrations of C# and ASP.NET programming since 2006. Monday, August 3, 2015. Select a List of Column Names in SQL Server. This gives a list of all the tables and columns in the tables in your database. The TABLES table was included to exclude views. COLUMNS.TABLE SCHEMA,. COLUMNS.TABLE NAME,. From INFORMATION SCHEMA.COLUMNS. On Tables.TABLE CATALOG = Columns.TABLE CATALOG. And Tables.TABLE SCHEMA = Columns.TABLE SCHEMA. And Tables.TABLE NAME = COLUMNS.TABLE NAME. Links to this post.