.NET Framework inside SQL Server announcement
-
Link
This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.
Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads
Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/
Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads
Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads
Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads
Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads
Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads
Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.
-
0 VotesPowershell automation of SCCM reports through Posh tool .
Hi all, i am looking for the solution to inbuilt the credentials inside the PoSH tool which i have created for SCCM reports. But the big question is i am not able to inbuilt the ...Unanswered | 2 Replies | 377 Views | Created by Sachin_Kumar0000 - Friday, December 13, 2019 11:40 AM | Last reply by Sachin_Kumar0000 - Friday, December 20, 2019 10:08 AM -
0 VotesThe number of variables declared in the INTO list must match that of selected columns ?
Im receiving error: The number of variables declared in the INTO list must match that of selected columns Whats that? My ...Answered | 2 Replies | 332 Views | Created by Gaccerbo - Tuesday, December 17, 2019 3:33 PM | Last reply by Erland Sommarskog - Tuesday, December 17, 2019 10:46 PM -
0 VotesReturn LEFT String from character '.' fails
Im using: SELECT LEFT(Nombre,LEN(Nombre)-CHARINDEX('.',Nombre)) from PCC.Archivos WHERE Nombre LIKE '4d3d7b5d-947d-4524-98ea-f722cafa27ee_164.png' Actual ...Proposed | 1 Replies | 311 Views | Created by Gaccerbo - Tuesday, December 17, 2019 5:29 PM | Last reply by Gaccerbo - Tuesday, December 17, 2019 5:48 PM -
0 VotesIS v10 Could not find a part of the path
System.IO.DirectoryNotFoundException: Could not find a part of the path '\\x.x.x.x\foldername'. The foldname is mapped drive on another server in a ... -
0 VotesSQL selecting from a database but excluding whats in a textbox
Hi, in the example below I am selecting from a MySql database where the id column matches what is in the Number.Text. Number.Text is a random ...Unanswered | 1 Replies | 499 Views | Created by nigelsvision - Monday, December 9, 2019 7:34 PM | Last reply by Erland Sommarskog - Monday, December 9, 2019 10:56 PM -
1 VotesMerge Three Tables and get one output using Sql Query
I have below candidate table details Table_TraineeInfo TraineeID BatchId ...Answered | 5 Replies | 1034 Views | Created by mazhar khan123 - Monday, December 2, 2019 8:38 AM | Last reply by Erland Sommarskog - Thursday, December 5, 2019 10:10 PM -
0 VotesMemory consumption while executing the Query
Hi Team, We have developed a .Net WPF application which is using ADO.Net to read data from the SQL server. As part of the WPF application, a query returns ...Unanswered | 2 Replies | 931 Views | Created by Naga Suresh - AIMS360 - Monday, November 18, 2019 3:40 PM | Last reply by Olaf Helper - Monday, November 18, 2019 5:40 PM -
0 VotesAlternate of UPDLOCK,TABLOCK
Hi, Can some one help me with table hints. Somebody has used WITH(UPDLOCK,TABLOCK) in sql in one of the applications I am working for an update statement. I suspect that this ...Unanswered | 3 Replies | 1005 Views | Created by Hp2019 - Thursday, November 14, 2019 2:10 PM | Last reply by Erland Sommarskog - Monday, November 18, 2019 11:53 AM -
0 VotesSQL Server Agent crashes - internal error in the .NET runtime
Hello everyone, We have an SQL Server 2017 (RTM-CU16) running on Windows Server 2019 Standard x64 OS. We reboot our server weekly, ... -
0 VotesHow to replace string sTSQL parameter with stored procedure spqueRun on csharp clr function ?
problem How to replace string sTSQL parameter with stored procedure spqueRun on csharp clr function ? clr function wih csharp work on sql good but must pass tsql ...Answered | 2 Replies | 980 Views | Created by engahmedbarbary - Saturday, November 9, 2019 9:51 AM | Last reply by Timon Yang - Monday, November 11, 2019 8:39 AM -
0 VotesList of modules in CLR
Hi all Is there any way to list the available Stored Procedures and Functions in an (installed) assembly? Maybe with their ...Answered | 4 Replies | 1125 Views | Created by EgSuLu - Thursday, November 7, 2019 4:08 PM | Last reply by Olaf Helper - Thursday, November 7, 2019 7:38 PM -
0 VotesSQL Connection string for service account in a C# solution
Hi All, I am very new in coding the C# solutions, I have a c# solution which will connect to the TFS (Team foundation server) download the files and then deploy them to ...Answered | 3 Replies | 928 Views | Created by Rahul 11 - Tuesday, October 29, 2019 9:35 PM | Last reply by Olaf Helper - Wednesday, October 30, 2019 9:31 AM -
0 VotesSQL Server Distributed Cache
Hello, Has any one worked on SQL Server Distributed Cache? Do we have performance numbers for SQL Distributed Cache vs ...Unanswered | 0 Replies | 878 Views | Created by Parameshwaran Iyer - Monday, October 28, 2019 7:58 AM -
0 VotesSql Connection From Local C# Application to Another Computer
hi guys i build an application and build a connection to my local sql databse on my computer. Its working fine well i want to know is there any way to connect my server ...Unanswered | 1 Replies | 939 Views | Created by Haashim Butt - Saturday, October 19, 2019 1:47 PM | Last reply by Erland Sommarskog - Saturday, October 19, 2019 5:05 PM -
0 Votessql querty to get distinct values in string_agg function
i have following query where i need 3rd column values comma separated which am getting it now but i need distinct values how can i do it? WITH SelectedData As ...Unanswered | 2 Replies | 4320 Views | Created by shivayogiHiremath - Monday, September 10, 2018 7:48 AM | Last reply by RichBCamarillo - Friday, October 18, 2019 11:55 PM -
0 VotesSQL WPF C#
How to store data into SQL Server tables in WPF C#?Unanswered | 2 Replies | 1185 Views | Created by Saya.d - Wednesday, October 16, 2019 1:17 PM | Last reply by Erland Sommarskog - Wednesday, October 16, 2019 9:32 PM -
0 VotesSplit column into multiple based on value
I am looking to split a column into 4 parts based on the value in the column eg. table: ID | Some No a ...Unanswered | 1 Replies | 1060 Views | Created by eruig - Monday, October 14, 2019 8:01 AM | Last reply by Erland Sommarskog - Monday, October 14, 2019 9:41 PM -
1 VotesStrange results in SQL 2005 with CLR UDF and Varbinary(MAX)
I have an empty C# CLR UDF that looks like this: public static SqlBytes MyUDF(SqlBytes data) { return data; } Defined like ...Answered | 3 Replies | 3054 Views | Created by Neil Weicher - Friday, February 7, 2014 8:16 PM | Last reply by Kazzman - Wednesday, October 2, 2019 12:40 PM -
0 VotesDatabase connection issue
Hi there, I am trying to connect server database in my web api. While doing this I am getting following error in Postman. "Could not get ...Unanswered | 1 Replies | 1303 Views | Created by Nihar86 - Friday, September 27, 2019 12:51 PM | Last reply by Olaf Helper - Friday, September 27, 2019 1:07 PM -
0 VotesCan I connect SQL Server 2005 to Visual Studio Community 2019 / Visual Studio Code?
I was assigned to develop an asp.net with the database in SQL Server 2005. Can Visual Studio Code or Visual Studio 2019 Community connect with SQL Server 2005?Unanswered | 3 Replies | 1138 Views | Created by xokin - Tuesday, September 24, 2019 4:21 AM | Last reply by Olaf Helper - Wednesday, September 25, 2019 5:35 AM - Items 1 to 20 of 2922 Next ›
.NET Framework inside SQL Server announcement
-
Link
This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.
Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads
Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/
Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads
Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads
Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads
Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads
Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads
Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.
