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.

Dostana : 3/5 Rating (it’s a film with a one-point agenda – to entertain you while you’re in your seat. It achieves that, no two ways about it.)

Dasvindaniya : 3/5 Rating (It’s emotional and sure to leave you teary-eyed. Watch it, but take your tissue box with you.)

Truly Inspired By Rajeev Masand.
Please Watch CNN IBN On Every Friday 10:30 PM and Get All Latest Movie Review.

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.

3. Double click network.http.pipelining.maxrequests and set value to 10 from 4

4. Right click on any black space. Select New->String write nglayout.initialpaint.delay and set its value to 0.

Enjoy your New Speedy FireFox.

Below stuff for IE.

1. First Step is open start menu and type regedit in Run prompt that will open registry editor of your windows operating system.keep in mind that what i have write please follow same steps please don`t do anything more because registry operates all windows functionality so if you may change wrong stuff it will cause you windows.

2. Now Please Expand this string see two time and expand all stuff

Expand HKEY_CURRENT_USER -> Software -> Microsoft -> Windows -> CurrentVersion -> Internet Settings

3. After Clicking on internet setting go to the right hand side window frame and find this two DWORD Keys “MaxConnectionsPerServer” and “MaxConnectionsPer1_0Server” if you will find these two keys then change both keys values to 6 for that you will  click on key which open new window and please modify that value 6.

4. If these two DWORD not found on right hand side frame then please create two new DWORD.right click on right hand side frame blank space and create new DWORD with same name One for “MaxConnectionsPerServer” and another for “MaxConnectionsPer1_0Server” and give 6 value to both that new DWORD.

5. Please make sure when you give that both the keys to value 6 select decimal radio button after write 6 value.

6. close your registry editor and reboot your computer which will effect your IE Speed.

Enjoy All stuff.

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