|
|
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Update field Posted by Alejandro at 3/14/2006 10:09:52 AM Hi,
This might be an easy one for you experts.
I have two tables. Table A
Id, Name,City .. etc
Table B
Id, FirmId, IDfromtableA, etc
I am doing a join table to get the firmid on table A
Select * from A
Inner join B on a.id = B.IDfromtableA
Now .. here is what I intend to do....more >>
Migrating to SQL Server! Posted by MIK at 3/14/2006 12:00:00 AM Hi,
My application is currently running with an Oracle database at backend
but now I want to deploy it with MS SQL Server for a client. Can anybody
tell me what I should do? I am very new with SQL Server. My application
uses sequences that I cant find in SQL Server commands list etc.
pleas...more >>
Updating Totals Posted by dew at 3/13/2006 6:16:33 PM I have a table with 3 columns, and need to update the 4th column to be the
sum of those three columns. How can I do that? When I do the following
query, I get an error saying you can't use an aggregate in an update
statement:
Update tblNumbers set Total = Sum(col1, col2, col3)
Thank yo...more >>
temporary permission for a writtnig job Posted by Sam at 3/13/2006 2:14:05 PM how i grant to user who has no write permission a temporary permission for
a writtnig job
like add a new user?
thanks
...more >>
addrolemember Posted by Sam at 3/13/2006 11:16:48 AM I use sp_addrolemember 'RoleNmae', 'UserName'
but when i click on user's properties i get a messege
"error 21776: the name was not found in the users collection"
and user has no permit
what is wrong?
thanks
...more >>
Utility that creates sql code to re-populate a table? Posted by keithb at 3/11/2006 11:00:18 PM Is there a SQL Server utility that will create the sql code to re-populate a
table?
Thanks,
Keith
...more >>
Command Line SQL execution with SQL Server 2K? Posted by keithb at 3/11/2006 7:35:47 AM Does SQL Server 2K provide a way to enter command line SQL similar to that
provided with mySQL?
Thanks,
Keith
...more >>
How to print out table structures in a database? Posted by keithb at 3/11/2006 7:33:46 AM Using the SQL Server 2K Enterprise Manager, how can I get a printed copy of
the table structure for a database. I just need the info that is shown in
the 'Design Table' dialog box.
Thanks,
Keith
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005 Mgmt Studio-Not Available Posted by Shyam at 3/10/2006 8:59:07 AM Hi,
I have installed the SQL 2005 Dev Ed.Once i had installed the SQL 2005,i
tried to find for SQL Mgmt Studio,but to my surprise,i do not see the SQL
Mgmt studio in my start->Programs. It is something wierd.
Could someone help me in this regard.Any stpes of action would be really
helpful....more >>
set value to null in query? Posted by r at 3/9/2006 4:46:58 PM I am using query analyzer to change the value of several fields -- i want
the field to be changed to a NULL. What do I use to indicate this in my SET
statement??
SET main.billed = [null] ????
...more >>
help with update query? Posted by r at 3/9/2006 1:03:32 PM I have to tables, Dealers and Data. I'm sure this seems redundant without
knowing the details, but I need it to be done and can't figure it out.
Each dealer in the Dealers table has 2 IDs, D_ID (primary ID) and S_ID
(secondary ID).
The Data table has multiple records for each dealer, and th...more >>
Dependance service or group failed to start - 1068 Posted by R Weeden at 3/8/2006 4:19:10 PM I am getting an error whenever I try to start the sqlserveragent. This
started happening about three days ago. I have not made any changed to the
computer users or permissions and it is a test environment on a local
computer.
The error is:
The dependency service or group failed to start err...more >>
Restoring a Single Table Posted by Francis Reed at 3/8/2006 11:07:00 AM Hi
I'm working for an online university, and we are currently in the process of
redesigning our portal website. We were thinking of using a single database
to store content, quizzes, and assignments coming from multiple courses, as
well as user accounts and security. The reason for this, is th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |