Card image cap

MongoDB Basic: How to Connect to MongoDB Remote Server

In my previous article we learn how to install MongoDB on the local machine and how to connect to your local MongoDB instance. In this […]

Last updated August 22, 2017
Card image cap

MongoDB Basic: How to connect to MongoDB

In this article, I am covering MongoDB basic for a beginner. When I started discovering MongoDB, I handled many small issues which I am going to […]

Last updated July 16, 2017
Card image cap

select range of data rows in MSSQL2005

We all know if we have to find range of data then we use sub queries but sql2005 provide row_number to find range of data […]

Last updated August 22, 2009
Card image cap

@@rowcount with MSSQL

@@ROWCOUNT returns the number of rows affected or read depending on the operation. terms as follows @@ROWCOUNT returns the number of rows returned to the […]

Last updated August 22, 2009
Card image cap

Dealy in sql or Wait in sql query

In many application or process we required dealy there is dealy in sql server call WAITFOR select ‘1’ WAITFOR DELAY ’00:00:30′ above query run and […]

Last updated June 30, 2008
Card image cap

Text file as data source

In many application we need Text file as data source or as table many ways to do this one of that as follows create one […]

Last updated June 28, 2008
Card image cap

Nesting Stored Procedures

Nesting Stored Procedures Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate. […]

Last updated June 16, 2008
Card image cap

How To get last updated Row from table ?

timestamp (Transact-SQL) Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping […]

Last updated June 16, 2008
Card image cap

how to get new inserted row id in sql

SCOPE_IDENTITY Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a module — a stored procedure, trigger, […]

Last updated June 16, 2008
Card image cap

Varchar(Max) limit of max in Sql2005 ?

While developing one store proc i face problem of varchar(max) my string was genreated more than 100000 charactes and by default varchar(max) size is 65,536 […]

Last updated June 4, 2008

I'm Yogesh Kadvekar, a Technology Consultant, Computer Engineer by education, tech writer and problem solver. I love startups. I love hiking, sports, arts and Stock market. Say hello!