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.
I have a clarification for query optimization technique in sql server 2005.
I have a select query in sp. In this query, i put...
In my project i am in critical situation. I am having two scenarios. In single application, multiple user update and retrieve the data from...
I am using Sql Server 2005. I have one doubt. I write procedure for multiple queries.
I have two tables. Table Name 1 : UserPermission Table Name 2: UserFeaturetype.
I have doubt. I am creating table and insert two rows.
This is my table .
BookName Price Author
I am using sql server2005. I have an error while executing this sp.
Iget the values that @featureoperationmapid and @user id from...
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
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...
<img src="file:///C:/DOCUME%7E1/ashok/LOCALS%7E1/Temp/moz-screenshot-1.jpg" alt=""><span><span id="_ctl6_ctlTopic"><span...
This is my table tblGroups
I have one doubt.I use phpmyadmin for viewing MYSQL Database from my PC without
installing Mysql in my system. Like that somebody...
I am using two tables tblUsers and tblGroups
tblUsers : *intAutoUserId,strUserName and tblGroups : *intAutoGroupId,strGroupName,+intAutoUserId...
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...
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.
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...
I am using Asp.Net 2.0 application, First i have createddatabase dynamically in my codebehind. well the db createdsuccessfully. Now i want to...
I try to implement trigger for Before Insert.
But i got an error. My trigger event is below.
CREATE TRIGGER Trig_Insert_author
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....
Separate names with a comma.