If you want to synchronize data from another table only for once, you can use this way. When you are going to update from another table don’t forget to give a condition. USE [AdventureWorks2012] GO --Inserting data from HumanResources.Employee and Person.Person to non existing table SELECT * INTO Tmp FROM [HumanResources].[Employee] GO --Retrieving data SELECT * FROM Tmp --Update Using ...
My previous blog post was about using insert in many ways. You can use SELECT INTO to add data from existing table to a new table. In this statement SQL Server will create a table for you. You just want to write the query and add INTO clause to the statement. Rest will done by SQL Server for you. USE ...
Today I wanted to paste few statements on Live Writer which were coded on SQL Server Management Studio 2012. But when I paste the code into Live Writer I got disappointed about the look. Codes were awesome on SMSS 2012 with colors. Then I wanted to find a way to insert those code with Visual Studio formatting. I found few ...
I’m still a beginner in SQL Server. Then I will blog about so many basic things in SQL Server. Inserting is very important Data Manipulation Statement. So lets see how to use INSERT Statement in different ways. USE tempdb GO --Creating Table CREATE TABLE tmpTable ( [id] int NOT NULL, [name] varchar(100) NULL, [address] varchar(1000) NULL ) GO --Inserting Data ...
Before two weeks I saw a post about lightning talks of SQLServerUniverse. So I applied for a lighting talk about “PowerPivot in SQL Server”. Then the A/L exam came to me. So I had no time to create a presentation for that. Hence the day before the physics exam I searched on the internet for “PowerPivot Slides”. Then I found ...
Until few our ago, I was happy. Thought that happiness came to me with a new friend. Now I’m feeling something very bad. I can’t explain it. It’s a problem with time. If you feel that you are going to loose your world what will happen. I don’t know! I don’t know what to do even. Happiness is a mirage ...
