Insert data to table from another table

Here is the example, how you can transfer data from one table to another;
(asumming, tables have been created and structures are same)


SET IDENTITY_INSERT [DB1].[dbo].TableName ON

insert into [DB1].[dbo].TableName select * from [DB2].[dbo].TableName

SET IDENTITY_INSERT [DB1].[dbo].TableName OFF

Above 3 lines:
1. Disable Identity.
2. Dump data from table.
3. Enable Identity again.


Hope you like it.

Testing WebService remotly.

This post helps to solve the poblem, how to test webservice remotly.

If this attribute is not configured in Web.config file, you will not able to access the webservice remotely.

jQuery

Hi

jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.

you can download latest version of jQuery: http://jquery.com/

Download jQuery presentation:

jQuery-PPT

jQuery-PPTX

Download the Sample Demo Code:

Demo

Have Fun :)

Visual Studio Tips-1

Hi

Here are some useful tips, which will help you a lot while working with VS.

· Cycle the Clip Board:

o Copy few text one by one, then to cycle the clip board(copied items), press Ctrl+Shift+V

o

· Browse with different browsers:

o By default VS will use Internet Explorer as default browser, well you can change the default settings or can browse a particular page with different browser.

· Open Visual Studio from Run Command:

o Run > type “devenv” without quotes > press “ok”

o When you open the VS, mark that, before opening VS, a small splash screen will come, and if you don’t want to see that screen(which can faster opening VS), you can do that doing a small addition in the above command:

§ Type “devenv /nosplash” instead of “devenv”.

Happy coding :)

Open SQL server with one click

Hi

Before reading this post, tell me how your opening SQL server, I mean how many steps its taking… just count… may be from 3-4 clicks… and for opening object explored 2 more .. And opening new query window for a particular database 2 more…

Now I will tell how you can open SQL server (with object explorer, new query window with selected DB) in one lick.

You know how to open it normal way, i mean from Run command, it is “sqlwb”(for sql server 2005) and “ssms”(for sql server 2008).

Open Run command, type:

sqlwb -S ServerName -d DataBaseName -U UserName -p Password

e.g:

sqlwb -S TestServer -d dummyDatabse -U Username_test -p myDummyPassword

To get help for these commands and more type “sqlwb /?” in run command.(“ssms /?” for 2008 sql server).

Happy coding…!!!