Viewing 15 posts - 16 through 30 (of 65 total)
Monica Chaturvedi (9/14/2008)
U can also use sql server 2005's with clause.See Sql server 2005's Common Table Expressions for more.
And how will a CTE help here?
September 15, 2008 at 12:48 am
Rohit (9/10/2008)
I have the data comming from Excel file(Which is the latest one and
want to update this data into the DB table) and am temporarily putting
into...
September 11, 2008 at 12:58 am
There actually is no point handling this issue at the database level, push some checks on the UI to stop users sending the same form again.
September 11, 2008 at 12:48 am
AShehzad (9/11/2008)
e.g.
startDate ...
September 11, 2008 at 12:45 am
Glen (9/4/2008)
I remember reading in one of the blogs that SQL Server does short-circuit evaluation, but it was not specified under what conditions.
I dont agree here Gila coz SQL...
September 10, 2008 at 3:28 am
:Dactually I am at a mobile device and cannot test the queries.... just wrote the logic.
September 8, 2008 at 7:09 am
Shahzadi (9/8/2008)
i have three table in my Database (UserTeam, Team, User) and i need to have the list of Those user which Disabled = False
i have UserTeam which save each...
September 8, 2008 at 6:20 am
richard (8/26/2008)
I've created an SP that selects data based on 2 variables that are passed to it. One is a user name (varchar) and the other is a date...
August 26, 2008 at 5:28 am
Actually I found the solution just after posting the question. Then I tried to delete the post a couple of times but was unable. :hehe:
August 26, 2008 at 1:42 am
There is a very beutiful article for the problem that you are talking about. Below is the link:
August 26, 2008 at 1:31 am
GilaMonster (8/26/2008)
Defaults only apply to new rows inserted. If you want the existing rows with null to change to that value, you'll have to run an update statement.
NAH Man, I...
August 26, 2008 at 1:13 am
Hey Jerry,
I would advise to create a proc that will fetch the scripts from the .sql files and schedule it.
Regards,
Arjun
August 25, 2008 at 12:55 am
One example that I can think of can be the EmployeeDetails table. This table stores the EmployeeID as well as the ManagerID of the employee. In such a situation, managerid...
August 25, 2008 at 12:51 am
karthikeyan (8/22/2008)
I am trying to filter the below flat file message which is stored in a sql table. But i am not able to fileter successfully. Here the table...
August 22, 2008 at 5:46 am
Viewing 15 posts - 16 through 30 (of 65 total)