This blog related to all the experience that i gain and face during past career. It covers Microsoft technology like. Microsoft Dot Net, SQL Server, Scripting Language etc,.
Pages
Thursday, February 20, 2014
Wednesday, February 19, 2014
How to Create a Linked Server
http://msdn.microsoft.com/en-us/library/aa560998.aspx
Copy table from one database to another
Create a linked server to the source server. The easiest way is to right click "Linked Servers" in Management Studio; it's under Management -> Server Objects.
Then you can copy the table using a 4-part name,
server.database.schema.table
:select *
into DbName.dbo.NewTable
from LinkedServer.DbName.dbo.OldTable
This will both create the new table with the same structure as the original one and copy the data over.
Tuesday, February 11, 2014
Subscribe to:
Posts (Atom)
My Blog List
-
-
कोई समझता क्यों नहीं - मेरी ख़ामोशियों को कोई, समझता क्यों नहीं दिल की हलचलों को कोई, समझता क्यों नहीं उम्र गुज़र रही हैँ मेरी, लोगों में खुशियां लुटा कर, पर मेरी मोहब्बतों को कोई...1 month ago
-
-
Kumaon University Nainital B.Ed entrance exam test result 2012 - कुमाऊँ विश्वविधालय, नैनीताल (उत्तराखण्ड)11 years ago