Search Results | SQL Server Performance Forums

Need a solution for this sql query

Thread by: sasivashok, Jan 20, 2011, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am using the below query in my sql. Here is four table. I join the table and i show that what output i need. Select...

Query optimization for correlated query in sql server 2005

Thread by: sasivashok, Jan 11, 2011, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi friends, I have a clarification for query optimization technique in sql server 2005. I have a select query in sp. In this query, i put...

Need a suggestion for using Nolock and Readpast

Thread by: sasivashok, Dec 21, 2010, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, In my project i am in critical situation. I am having two scenarios. In single application, multiple user update and retrieve the data from...

How to catch the db exception in stored procedure

Thread by: sasivashok, Feb 16, 2010, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am using Sql Server 2005. I have one doubt. I write procedure for multiple queries. BEGIN TRAN BEGIN TRY query 1 query 2 query 3 COMMIT TRAN...

Insert values in single table

Thread by: sasivashok, Jan 26, 2010, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have two tables. Table Name 1 : UserPermission Table Name 2: UserFeaturetype. UserPermission...

how delete duplicate rows from table without primary key

Thread by: sasivashok, Nov 25, 2009, 12 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have doubt. I am creating table and insert two rows. This is my table . BookName Price Author C++ 150...

Get values and insert every data continuously using cursor

Thread by: sasivashok, Oct 6, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am using sql server2005. I have an error while executing this sp. Iget the values that @featureoperationmapid and @user id from...

How split delimiters and get the values

Thread by: sasivashok, Oct 2, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I am using sql server 2005. A parameters coming to sp like that aggr | view&true,edit&true | package | view *true,edit&false,delete&true this...

The Type or namespace name 'Northwind' could not be found

Thread by: sasivashok, Aug 12, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi friends, I am new for Linq to sql. I am using web application that vs 2005 and MS Sql server 2005. I have this code Northwnd nw = new...

Need to manage currecy value for country vice

Thread by: sasivashok, Jun 3, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

<img src="file:///C:/DOCUME%7E1/ashok/LOCALS%7E1/Temp/moz-screenshot-1.jpg" alt=""><span><span id="_ctl6_ctlTopic"><span...

How eliminate commas in query and get particular id

Thread by: sasivashok, May 27, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Dear friends, This is my table tblGroups intGroupId intUserId 1 1,2,3 2 1,3...

Without installing MSSQLSERVER can view MSSQL database

Thread by: sasivashok, May 15, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Dear friends, I have one doubt.I use phpmyadmin for viewing MYSQL Database from my PC without installing Mysql in my system. Like that somebody...

How split string in the row

Thread by: sasivashok, Mar 31, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi I am using two tables tblUsers and tblGroups tblUsers : *intAutoUserId,strUserName and tblGroups : *intAutoGroupId,strGroupName,+intAutoUserId...

Could not bulk insert because file 'C:csv ame.txt' could not be opened. Operating system error code 3(The system cannot find the path specified.).

Thread by: sasivashok, Mar 12, 2009, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I got an above error while bulk insert my text file. Whats the solution for this? First without sharing i got file does not exist. Now i gave...

How increase size of db using sql query in ms sql server 2005

Thread by: sasivashok, Feb 28, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have one doubt.Is it possible to increase size of our create db using sql query in MS Sql Server 2005. If yes please tell me the query.

set permission for user at particular database

Thread by: sasivashok, Feb 27, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi friends, I am using asp.net 2.0 application & ms server 2005. Using sp_addlogin,sp_adduser and sp_password I create a login and set username...

Create username and passwod for database dynamically in code behind

Thread by: sasivashok, Feb 26, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am using Asp.Net 2.0 application, First i have createddatabase dynamically in my codebehind. well the db createdsuccessfully. Now i want to...

Error in "Before Insert Trigger"

Thread by: sasivashok, Feb 25, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi Friends, I try to implement trigger for Before Insert. But i got an error. My trigger event is below. CREATE TRIGGER Trig_Insert_author BEFORE...

Examples stored procedure for sp optimization

Thread by: sasivashok, Feb 25, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am using sql server 2005. I want to example stored procedures for sp optimization. If you have any tutorials or useful links please send me....