Cursor in MS SQL

Using Cursor in MS SQL Server 2005 or 2008 Consider following code for creating cursor declare db_cursor CURSOR for SELECT ItemSLNO FROM P_Return_ItemSLNOTraking where Com_PReturnId_ItemId = @Com_ReceiveId_ItemId OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ItemSLNO WHILE @@FETCH_STATUS = 0 BEGIN SET @SLNO = @SLNO+ ‘,’+ @ItemSLNO FETCH NEXT FROM db_cursor INTO @ItemSLNO END CLOSE db_cursor […]

Cannot access shared files and folders or browse computers

Most of the time I am unable to access shared files and folder from other pc. There is a service named Computer Browser stopped automatically I dont know why. But I found a solution from Microsoft site. Here is the solution: At first do following: ———————- i. Right-click My Computer > then click Manage. ii. […]

ERDBManager

1. Introduction: Welcome to ER DBManager.NET®. This documentation helps you understand ER DBManager.NET® and how to integrate the library into your applications. DBManager is a library that is used to perform database(MS SQL, Oracle, Oledb, Odbc) operation (Connecting DB, Executing Command, Reading Data, Reading Output parameter, Executing DataSet etc) more easily in Microsoft™ .NET Platform. […]