SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Monday, October 8, 2012
A transport-level error has occurred when sending the request to the server
›
Sometime you may get the below error while connecting to SQL Server: .Net SqlClient Data Provider: Msg 10054, Level 20, State 0, Line 0 ...
Friday, October 5, 2012
Error: 7139, Severity: 16, State: 1
›
Today I was getting error while uploading documents to the table. Whenever I was uploading documents with size greater than 64 KB, I got th...
Thursday, October 4, 2012
SET NOCOUNT ON
›
SET NOCOUNT ON gives a performance boost to action queries by suppressing the "(n row(s) affected) message that results from running ...
Wednesday, October 3, 2012
Script to remove Tab, Line Feed and Carriage Return from a string
›
The below TSQL script removes the Tab, Line feed, Carriage Return characters in a string: SET NOCOUNT ON DECLARE @String VARCHAR(100) ...
Monday, October 1, 2012
Convert Delimited String to Table
›
Sometime we may need to convert delimited string to table. From below function we can do this conversion: CREATE FUNCTION Func_String_To...
‹
›
Home
View web version