Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Programming / CLR / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
UDAGG: Invalid size29 May 2008 00:47 GMT1
I am trying to implement an UDAGG that operates on a bit vector (varbinary).
all compiles fine, but when I attempt to register I get the following
message:
Msg 6560, Level 16, State 1, Line 1
Performance problem using CLR property in Transact-SQL27 May 2008 20:59 GMT1
GlacierI am using a SQL CLR variable as a parameter to pass information between procedures.
However, when I use a property of my CLR in a Transact-SQL statement there is a substantial performance impact.
For example.
DECLARE @CLRvar   MyClrType
CLR Stored procedure to import Excel sheet.17 May 2008 17:27 GMT1
I've gotten a windows application to read an excel file with the following
code:
       string ExcelConnStr = @"Driver={Microsoft Excel Driver
(*.xls)};DBQ=\\Server\Spreadsheets\Test.xls";
CLR and LINQ: Can I compile my SQL INSERT, UPDATE, DELETE & SELECT statements?01 May 2008 04:42 GMT1
I was reading
    Professional SQL Server 2005 CLR Programming: with Stored Procedures,
Functions, Triggers, Aggregates, and Types
last night and was shocked to see quoted SQL SELECT statements in the C#
2009DecNovOctSepAugJulJunMayAprMarFebJan
2008DecNovOctSepAugJulJunMayAprMarFebJan
2007DecNovOctSepAugJulJunMayAprMarFebJan
2006DecNovOctSepAugJulJunMayAprMarFebJan
2005DecNovOctSepAugJulJunMayAprMarFebJan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.