SQL Server
Sometimes I just need to search and replace to add the CR/LF at the end of each line. Here's the solution I find from other's post. List here for quick reference: Notepad++. Open your text file in Notepad++. Then navigate to menu View > Show Symbols > Show all characters. Highlight one of those squares in your text, then copy it to clipboard. Press Ctrl+H. Inside "Find what:" textbox, paste (Ctrl+V). Inside "Replace with:", type \r\n In search options, choose "Extended (\r, \n, \t, \0, \x...)"....
Here is how you should play it: 1. Make sure your have both a SQL 2000 with latest sp and a SQL 2005 database 2. guess the result of the two 'print' command in the script below, write down the last character in the string on your mind 3. Run the script below in SQL 2000 4. Change the 3999 to 3998 and run it again on SQL 2000 5. Change the 3998 back to 3999 and run it on SQL 2005 ---------------------------... declare @n varchar(4000) set @n = replicate(N'z',3999)+N'i' print @n set @n=replace(@n,...
I got this error when testing my web service POC which is runing on .netFx 2.0: System.Data.SqlClient.SqlEx... Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I find Angel's article gives the most accurate diagnosis. Check it out here: http://blogs.msdn.com/angel... But the solution he gives out doesn't solve the problem: public void DoesNotLeakConnections() { Using (SqlConnection sqlconnection1 =...
My friend told me this morning, he's little confused with his UPS shipment tracking result. We all know that UPS' using 18 bits tracking number to 'uniquely' identify a shipment. But after I just saw my friend's tracking result page, I'm not sure about the 'unique' part any more. On the 'Package Progress' pane, UPS lists all the history of the shipment associated with the number: Package Progress Location Date Local Time Description BROOKLYN, NY, US 06/25/2007 9:47 A.M. DELIVERY 06/25/2007 7:19 A.M....
SQL 2K5 introduces a new behavior row-overflow, which enable the combined row size exceed 8,060 bytes per row limit for varchar, nvarchar, varbinary, sql_variant or CLR user-defined type columns. For more details, check out BOL: http://msdn2.microsoft.com/... What's this mean to the database professionals? Good news for data modelers is you don't have to worry about the error message 'Cannot create a row of size xxxx which is greater than the allowable maximum of 8060' when...