watchingsite.wordpress.com

sqlhelper.wordpress.com

sqlhelper | Helpful tips and tricks for SQL database coding | Page 2

https://sqlhelper.wordpress.com/page/2

Helpful tips and tricks for SQL database coding. Newer posts →. Identify duplicate values in PL SQL using RANK() OVER. For this article I will show you how to identify duplicates in a table. The following code will create a table and populate it with the necessary data. CREATE TABLE DUPLICATE TEST. Continue reading →. Subtotals in pl sql. Triggers in MS SQL. So what is a trigger? You can also specify when you want the trigger code to run, after or instead of the specified operation. If you ever need to n...

sqlhelper.wordpress.com

MS SQL outer joins | sqlhelper

https://sqlhelper.wordpress.com/2011/11/19/ms-sql-outer-joins

Helpful tips and tricks for SQL database coding. New operators in SQL 2008 →. MS SQL outer joins. If you have been working with SQL for a while, sooner or later you have to use an outer join. The easiest way to achieve this is to build a SQL statement using a left outer join. Create table of sales people. CREATE TABLE [dbo].[SALES PERSON] (. ID] [int] IDENTITY (1, 1) NOT NULL ,. Name] [varchar] (100) NULL. Populate SALES PERSON with data. INSERT INTO SALES PERSON(NAME) VALUES('David Spritz'). Sales Date]...

alexpinsker.blogspot.com

Alex Pinsker: C# - the fastest way to iterate over dictionary

http://alexpinsker.blogspot.com/2010/02/c-fastest-way-to-iterate-over.html

Wednesday, February 24, 2010. C# - the fastest way to iterate over dictionary. Having a big dictionary, say 1M of double,double samples – what is the fastest way to iterate over it? Comparing 3 options (iterate over. In the dictionary, iterate over. Collection and iterate over. Collection) – below is code and timing comparison results. Of course if you iterating over Keys collection and accessing the value by key – it would be the slowest. 160;   Enumerable. Repeat(0, 1000000).Select(. Total = 0.0;.

sqlhelper.wordpress.com

SQL Merge Statement | sqlhelper

https://sqlhelper.wordpress.com/2011/11/01/sql-merge-statement

Helpful tips and tricks for SQL database coding. Stored procedure with output parameters. MS SQL outer joins →. In older versions of SQL Server, if you wanted to check for the existence of a record in a table and then update a value (if the record was found) or insert a new record (if no record was found) you had to do all of this yourself. Create table to hold client balances. CREATE TABLE [dbo].[account balances]. Account number] [numeric](18, 0) NULL,. Balance] [numeric](18, 2) NULL) ON [PRIMARY].

sqlhelper.wordpress.com

nickstan777 | sqlhelper

https://sqlhelper.wordpress.com/author/nickstan777

Helpful tips and tricks for SQL database coding. I am a SQL/reporting developer with more than 10 years experience. I have started a blog to share a few interesting things that I have learnt over the years and to learn something new. New operators in SQL 2008. MS SQL outer joins. Sql left outer join. In older versions of SQL Server, if you wanted to check for the existence of a record in a table and then update a value (if the record was found) or insert a new record (if no record was found) … Con...

sqlhelper.wordpress.com

Backup databases | sqlhelper

https://sqlhelper.wordpress.com/2012/05/11/backup-databases

Helpful tips and tricks for SQL database coding. New operators in SQL 2008. The following script can be used to backup all databases on your server (except the system ones) to a specified directory. SET @filepath = 'C: backups '. DECLARE db cursor CURSOR FOR. BACKUP DATABASE [' name '] TO DISK = N' ' @filepath name '.BAK' ' ' WITH COMPRESSION, RETAINDAYS = 1, NOFORMAT, NOINIT, NAME = N' ' name '-Full DB Backup' , SKIP, NOREWIND, NOUNLOAD, STATS = 10'. AND name NOT IN ('master','tempdb'). Johnd882 on SQL ...

sqlhelper.wordpress.com

New operators in SQL 2008 | sqlhelper

https://sqlhelper.wordpress.com/2012/02/18/new-operators-in-sql-2008

Helpful tips and tricks for SQL database coding. MS SQL outer joins. Backup databases →. New operators in SQL 2008. One of the small (but useful) changes to SQL 2008 is the introduction of new assignment operators. DECLARE @add AS INTEGER. DECLARE @subtract AS INTEGER. DECLARE @multi AS INTEGER. DECLARE @divide AS INTEGER. SET @add = 0. SET @add = @add 1. SET @add = 0. SET @add = 1. SET @subtract = @subtract - 1. SET @subtract = 5. SET @subtract -= 1. SET @multi = 2. SET @multi = @multi * 2. Notify me of...

watchhogstories.wordpress.com

Coding Practices – The Modulus Operator.. – WatchHogStories

https://watchhogstories.wordpress.com/2008/08/11/coding-practices-the-modulus-operator

A blog about games development, the games industry and general software engineering. The Story Of The Hog. Follow WatchHogStories on WordPress.com. Coding Practices – The Modulus Operator. August 11, 2008. August 11, 2008. Before we begin I’d just like to make a note that I’m going to be using C# for all my examples considering this blog are generally c#/XNA-centric (however i’m pretty sure the same functions for the modulus operator can be applied in C/C and most other languages). N) as the remainder.

shivagaadu.blogspot.com

.NET: (Tricky) C#.NET, SQL Server interview questions

http://shivagaadu.blogspot.com/2012/03/tricky-cnet-sql-server-interview.html

Experiences with .NET! Monday, March 12, 2012. Tricky) C#.NET, SQL Server interview questions. 1 What is the difference between classic ASP and ASP.NET? My answer) ASP.NET has the .NET framework part which includes CLS and CLR. CLS - has all the libraries. CLR provides the ability to convert MSIL to binary code and take care of bunch of other stuff like Garbage collection, etc. 2 Principles of OOPS. Inheritance, Polymorphism, Abstraction, Encapsulation. 3 What is the need of Encapsulation? It will be NULL.

whysfreallyisthatbad.com

Why San Francisco Really Is That Bad | A Manifesto in Parts

https://whysfreallyisthatbad.com/comment-page-1

Why San Francisco Really Is That Bad. Part II: Marrieds & Gays. Part III: [Absent] Alpha Males. A Manifesto in Parts. People Love talking about how much they Love San Francisco. But lurking under that fog of adoration is an underground world of women. 77 Comments to “Abstract”. June 26, 2012 at 6:02 pm. So basically men are to blame for everything. Well, that explains it. :rollseyes:. July 2, 2012 at 3:59 pm. March 12, 2014 at 11:45 pm. March 24, 2013 at 2:50 am. How trite. Google is your friend:. Take a...