Hi

There is the bitwise AND operator (&).

http://sqlfool.com/2009/02/bitwise-operations/

Hi

Has it solved ur problem..??

Hi

Refer BOOKS ONLINE

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Also learn abt the new features in SQL server 2008.

Again... http://beyondrelational.com/blogs/

is a good resource.

Yes..you are right..Sorry for that..

To create a column of VARCHAR data type with a maximum of 10,000 characters, you declare the column as VARCHAR(MAX) data type and simply add a...

Hi

You can consider using nvarchar(max).

Hi siamak.s16

Have you got the solution..?

Interested to know..how it worked..

Hi

Refer this link

http://beyondrelational.com/blogs/ashish/archive/2009/05/09/error-exception-handling-in-sql-server-2005.aspx

Hi

If you want know the T-sql difference , you can refer this link

http://thehobt.blogspot.com/2009/02/rownumber-rank-and-denserank.html

Well Done..BitBucket...

Thats a great way to do it...!!

Declare @D DATETIME

Declare @E DATETIME

SET @E= DATEADD(Year, 1, @D)

Thanks for the replies..!!

Any other option by which I can directly work in Adventureworks DB over Internet, similar to as it is installed in a PC..??

Hi

Try this useful link

http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx

Hi..

Try this useful link

http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/

PIVOT on character data

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-programming/71624/SQL-2005-PIVOT-on-character-data

Hi..

Please refer this link

http://www.sqlservercentral.com/articles/T-SQL/63681/

http://www.devx.com/dbzone/Article/28165/0/page/3