Welcome to Neudesic Blogs Sign in | Join | Help

Steve Muise - SQL Server stuff

From the CLR to Analysis Services - SQL 2005 is a whole new beast. I will be discussing my findings, learnings, experiences, and personal opinions on the new new SQL Platform. I will also be posting follow-up conversations, code samples, question discussions from the MSDN SQL Programmability webcasts I am doing on Fridays. Come join us on Friday http://www.microsoft.com/events/series/msdnsqlserver2005.mspx

<February 2006>
SuMoTuWeThFrSa
2930311234
567891011
12131415161718
19202122232425
2627281234
567891011

Navigation

MSDN Webcast - SQL 2005

Syndication

SQLTypes compared to SQL Server Types

Tomorrow I will be speaking on writing SQL CLR Stored Procedures. Among other things, one thing you always want to insure is that you limit type coersion as much as possible. This means that you should use the SQLType library in your .NET code and the appropriate SQL Server types in the T-SQL Function that calls the .NET method. To insure that you use the right types here is the MSDN reference page of the data types mapped to each other.

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlTypes.asp

 

For other tips come listen to the webcast (or play the recorded version if you're busy tomorrow morning)

Published Thursday, February 09, 2006 7:24 PM by Steve_Muise

Comments

No Comments

Anonymous comments are disabled
Powered by Community Server, by Telligent Systems