pranavrajyaguru.wordpress.com
How to connect sqlserver from command prompt using sqlcmd / bulk insert | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08/03/how-to-connect-sqlserver-from-command-prompt-using-sqlcmd
How to connect sqlserver from command prompt using sqlcmd / bulk insert. August 3, 2011 at 5:28 pm. I need to insert large amount of records into sql server. The script is ready in file. The insert query is ready but the record is around 15 Lacs. SQL server gets time out every time I run the file from “SQL Server Management Studio”. Then I thought to do it from command prompt (whether anything can be done using cmd) as in my previous article I have used to replace text file from command prompt. Sqlcmd -S...
pranavrajyaguru.wordpress.com
How to find and replace text in large file | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08/03/how-to-find-and-replace-text-in-large-file
How to find and replace text in large file. August 3, 2011 at 4:36 pm. Back after a looooong break. This time I would like to replace text in a file. Hmm…. You might wonder that it’s so simple, Open file press ctrl F and replace from there. But here the file is very big in size. It’s 300 MB File. I’ve tried different editor to replace it but I’m failed and hopeless. I thought I need to replace it one by one. After creating file you need to fire below command from command prompt. Remember, you need to fir...
pranavrajyaguru.wordpress.com
June | 2010 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06
Archive for June, 2010. User defined function to strip html in sql server 2005/2008. I need to strip html at many places in my project, I can do that by JavaScript function but I want some more common mechanism to strip html codes while getting the data from database. So I thought of using striping html @ database level and I searched on the net and here is the function for striping html. CREATE FUNCTION [dbo].[udf StripHTML]. SET @Start = CHARINDEX(' ',@HTMLText). SET @Length = (@End - @Start) 1. Respon...
pranavrajyaguru.wordpress.com
COALESCE with DISTINCT in SQLServer | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/03/coalesce-in-sqlserver
COALESCE with DISTINCT in SQLServer. June 3, 2010 at 11:58 am. If you want comma separated values from columns it is so simple. Use COALESCE function provided by SQL Server. Select @csv = COALESCE(@csv ',','') cast(id AS VARCHAR) from tablename. COALESCE with DISTINCT Values. If you want, DISTINCT values in COALESCE function use inner table like below. Select @csv = COALESCE(@csv ',','') cast(id AS VARCHAR) from. SELECT DISTINCT id FROM TableName). Entry filed under: SQL Server. COALESCE in SQL Server.
pranavrajyaguru.wordpress.com
Pranav's Blog | Just another WordPress.com weblog | Page 2
https://pranavrajyaguru.wordpress.com/page/2
Convert String Array to Long Array. As I told you I am back within no time. Yesterday, I have faced a problem where I want to convert string array into long array. I need to search a lot in internet for solving this and after a lot finding I came to this simple solution. String[] strArray = { “xyz”, “abc”, “def” };. Long[] lArray = Array.ConvertAll string, long (strArray, Convert.ToInt64);. It’s so simple, cheers🙂. June 3, 2010 at 11:08 am. I am back after a looooooooong time. Any guesses for the error?
pranavrajyaguru.wordpress.com
User defined function to strip html in sql server 2005/2008 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/09/user-defined-function-to-strip-html-in-sql-server-20052008
User defined function to strip html in sql server 2005/2008. June 9, 2010 at 10:44 am. I need to strip html at many places in my project, I can do that by JavaScript function but I want some more common mechanism to strip html codes while getting the data from database. So I thought of using striping html @ database level and I searched on the net and here is the function for striping html. CREATE FUNCTION [dbo].[udf StripHTML]. SET @Start = CHARINDEX(' ',@HTMLText). SET @Length = (@End - @Start) 1.
pranavrajyaguru.wordpress.com
The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/01/the-selected-class-cannot-be-deleted-because-it-is-used-as-the-return-type-for-one-or-more-datacontext-methods
The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. June 1, 2010 at 7:22 pm. I am back after a looooooooong time. Today I have faced one problem in dbml file. As soon as I tried to delete the table from dbml file it gave me below message:. The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. Any guesses for the error? No problem, here is the solution. Cheers………🙂. 1 Comment Add your own.
pranavrajyaguru.wordpress.com
June | 2008 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2008/06
Archive for June, 2008. New feature of Visual Studio 2008. Hi Friends, This is my first post in my blog. I am using Visual Studio 2008 for a month and I was just searching for any new features in it. I have just checked a great feature in Visual Studio. Debug in source files. Yes, my friend, what you have heard is true. Debug in source code. You just need to set few settings and you can debug how your grid is bind or how DataAdapter. Fill() method works or anything you want to debug. Click Here.
pranavrajyaguru.wordpress.com
August | 2011 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08
Archive for August, 2011. Getting Request.ServerVariables from asp.net. Here is the method of getting all server variables in asp.net from Request.ServerVariables. Response.Write(“ table border=’1′ ”);. For (int i = 0; i Request.ServerVariables.Count; i ). String key = Request.ServerVariables.Keys[i];. String.Format(“ tr td style=’border:1px solid;’ {0} /td td {1} /td. This will list all the server variables in the page in table format…. August 12, 2011 at 4:28 pm. Eg once you have typed above command co...