| Thread | Last Post | Replies |
|
| [SQL 2005] SQLCLR UDT Comparison Methods | 19 Dec 2006 00:53 GMT | 16 |
OK, so I'm creating a simple UDT. I want to expose a method that performs a comparison of two objects of the type of the UDT and returns a "boolean" value based on the result that SQL Server can use in T-SQL statements and expressions. I understand you can't override comparison ...
|
| Problem with Scalar CLR UDF... | 17 Dec 2006 23:37 GMT | 2 |
I have created two UDF's that do exactly the same thing (UTF-8 encode and decode). The one written in T-SQL works just fine but the one written in C# is returning some strange data. When the character nchar(0x0100) is encoded it should return two characters
|
| Impersonating a different user inside a CLR Assembly | 17 Dec 2006 01:22 GMT | 1 |
Here is my situation. I have a stored procedure bound to a function in a C# assembly I've loaded into SQLServer 2005. Inside that assembly's code I need to create a process as SqlContext.WindowsIdentity (the ID of the caller) NOT as WindowsIdentity.GetCurrent(), which is NT ...
|
| Uploading data from Excel to SQL Server | 14 Dec 2006 05:33 GMT | 5 |
I assume that I'll need to write a cursor to accomplish this -- how would I write a cursor to upload data from Excel to SQL Server (1 row at a time)? I have the following code which does the following: 1. Deletes all rows having a value of "0" in column C
|
| Database Internals | 08 Dec 2006 11:51 GMT | 7 |
I am working in a simple work for my college where I have to choose a database to talk about optimization, structures, transaction control, recuperation, and distribution. I chose SQL Server, but I can't find anything on the Internet. Where can I find this information or which ...
|
| Linked Table possible as source for SQL server 2005 ? | 03 Dec 2006 15:05 GMT | 2 |
Currently I am using Access and the tables are in linked tables that get data from various Excel table. This mode is dynamic since when user update the Excel sheets, the table in Access changes accordingly. I am thinking to migrate from Access to SQL server 2005. However I could ...
|