Hello Friends,
When ever some one ask question like that how to insert data from one table to another our mind strikes and give answer that create one cursor which will access all data from one table and insert in to anothre table.sorry friends i give some nice solution then right now you have.
First Method to do such kind of stuff.
This method is used when table is already created in the database earlier and data is to be inserted into this table from another table.
First table which is allready created name is test_from.
Create New Table which have Name test_to.
CREATE TABLE test_to (FirstName VARCHAR(100), LastName VARCHAR(100))
INSERT INTO test_to (FirstName, LastName)
SELECT FirstName, LastName FROM test_from WHERE id = 2
Second Method
This method is used when table is not created earlier and needs to be created when data from one table is to be inserted into newly created table from another table. New table is created with same data types as selected columns.
SELECT FirstName, LastName INTO test_to FROM test_from WHERE id = 2
Enjoy Friends.
Hello Friends,
We all need that our browsers runs more faster and open all requested url more faster then it doing currently. so here is solution for Firefox and internet Explorer.
First OF all we do some stuff for firefox.
1. Open Your FirFox .Type about:config in address bar and press enter.it will show lots of links below address bar.please click show all button first.
2. Find network.http.pipelining set it to True just click on it. it will be true.
Read the rest of this entry »
Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.
This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.
What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .
This weekends movies and it`s rating.
Golmaal Returns : 2/5 Rating (Watch it, yes, but here’s a helpful tip – go in after intermission, that way you’ll only catch the best bits.)
Fashion : 3/5 Rating (All Masala No Reality.Stop thinking of it as a realistic expose and treat it as just another masala potboiler and chances are you won’t complain.)
Truly Inspired By Rajeev Masand.
Please Watch CNN IBN On Every Friday 10:30 PM and Get All Latest Movie Review.
Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.
This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.
What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .
This weekends movies and it`s rating.
Heroes : 2/5 Rating (Heroes is a far-from-perfect film, held together by a script full of holes, too long and packed with too many songs. Yet it’s got its moments. I’m going with two out of five for director Samir Karnik’s Heroes, it’s not entirely a waste of time.)
Roadside Romeo : 1/5 Rating (it doesn’t succeed in creating an exciting world where indeed every dog has its day, I’ll go with one out of five for director Jugal Hansraj’s Roadside Romeo. Go armed with a lot of patience and a comfortable pillow.)
Truly Inspired By Rajeev Masand.
Please Watch CNN IBN On Every Friday 10:30 PM and Get All Latest Movie Review.
Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.
This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.
What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .
This weekends movies and it`s rating.
Karzzzz : 1/5 Rating ( I wouldn’t even recommend it as a film that’s so bad it might be fun.This one’s just plain bad and I recommend you stay far away.Please don`t spoil your mood.)
Shoot On Sight : 2/5 Rating (it’s too simplistic and full of silly coincidences; yet there’s something important being said here, so it’s not an entirely pointless watch.)
Body Of Lies : 2/5 Rating (In this film DiCaprio and Crowe are both good, they always are. But neither can escape the pitfalls of this pointless film.Because it’s too long and goes around in circles, I’m going to go with two out of five and an average rating for Ridley Scott’s Body of Lies. It’s got its moments. But those moments are few and far between.)
Truly Inspired By Rajeev Masand.
Please Watch CNN IBN On Every Friday 10:30 PM and Get All Latest Movie Review.
Hello Friends this category provides you to what to watch and what to not watch on every weekend. when some new Bollywood and Hollywood Movie will release on every Friday. please read this Blog and decide for which movie you want to wast your money or worth your money.
This Blog Update on every Friday when some new movie will release so please read this article before go to theaters.
What Ever you read in this Blog is not my personal comments these are the comments of Film Critic. Only thing is i read all the comments and creates rating on that basis of their and mine opinion .
This weekends movies and it`s rating.
Hello : 1/5 Rating (Hello is not just a dull film, it’s an extremely stupid one. It’s one of those films that has virtually nothing good in it. )
Hello friends some guys asking me about is this any way to imports XML data into sql server table.
so friends here is answer of your question please follow the step and you will fill happy after task will done.
Step 1: Create one table in the
CREATE TABLE Customer (ID int NOT NULL, Name xml)
Step 2: Then After create a XML file .
<?xml version=”1.0″ encoding=”UTF-8″?>
<Customers>
<Customer ID=”1″>
<Name>Test</Name>
</Customer>
</Customers>
<Customers>
<Customer ID=”2″>
<Name>Data</Name>
</Customer>
</Customers>
Save this XML file name as test.xml into C:\ drive of your computer.
Step 3: Now import the xml data from C:\test.xml into newly created table ‘Customer’
INSERT INTO Customer(ID, Name)
SELECT 1, Name
FROM
(
SELECT * FROM OPENROWSET(BULK ‘c:\test.xml’,SINGLE_BLOB) as Disc
) AS ImportXML (Disc)
Note: Do not forget to specify the UTF-8 encoding scheme in the XML file.
Enjoy Friends.
Hello Guys and Girls what i servers you is some nice thing for sql server users.
if you want to find out the users logged in a database then we have to use some of system views.
sys.sysprocesses is one of them.
select * from sys.sysprocesses;
it will returns the host name , login name , window user name and processes.
if you want to know more stuff of sys.sysprocesses then go here
http://msdn2.microsoft.com/en-us/library/ms179881.aspx
some more Store procedures provides same stuff
EXEC sp_who
EXEC sp_who2
sp_who provides information about current users, sessions, and processes in an instance of SQL Server.
Enjoy Friends
Hello ! I am Arjun Jadeja a Software Engineer by Profession. You can contribute and I will distribute your ideas through this site. Thanks and Enjoy 
