As it is well known that MS SqlServer 2005 has CLR integration feature to it. Now what campe up straight to my mind was when to use what , i.e when to use T-SQL and when to use CLR compaitble sp.I got the following thumb rule from a book (Introducing MS SQlServer 2005 for Developers), I'm just specifying them. If the code primarily accesses or modifies data , it should be written in T-SQL . CLR code can never match the DML feature of normal T-SQL. If the code mainly contains processor intensive operations...

• Share This Post:
• 
• 
• 

MERGE INTO MyTable USING MYTempTable ON MyTemptable.MatchingField1=... WHEN MATCHED THEN UPDATE updatefield1=MyTemptable.up... WHEN NOT MATCHED THEN INSERT VALUES(mytemptable.matching...

• Share This Post:
• 
• 
• 

I've heard that SQLServer 2005 has introduce 2GB of data to its varchar,nvarchar datatypes. That was cool. But when I tried the foll. code Declare @var varchar(max) set @var=replicate('A',16000) Print len(@var) It gave me 8000. I'as preety flammoxed. then i cam accross the fact that these datatypes increase with a fixed size of 8000. so i tried the foll. Declare @var varchar(max) set @var=replicate('A',8000) set @var =@var + replicate('A',8000) Print len(@var) this gave me 16000...

• Share This Post:
• 
• 
• 

pageBaseType is an extremely powerful setting that you might to use when all your application pages inherit from a common class. it is in the section of the web.config

• Share This Post:
• 
• 
• 

To break into a remote object, you have to put this line of code.System.Diagnostics.Deb

• Share This Post:
• 
• 
• 

I was trying to find out if I can call an webservice fully dynamically , even without adding static web reference , when I cam across this article. http://www.topxml.com/WS-we... An excellent article

• Share This Post:
• 
• 
• 

http://groups.google.com/gr

• Share This Post:
• 
• 
•