|
Bring your table up in Design mode. From the 'Table Designer' menu select 'Relationships'. Set the 'Enforce Foreign Key Constraint' option to 'No'.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
how do i do it without opening sql server. i want to do it through my own coding
|
|
|
|
|
Look at the ALTER TABLE[^] statement.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
While i am trying to import .dat file into the SQL database i am getting this error.
I have pointed the mdf and ldf files to D drive which has around 2.5gb of space left.I am using the bulk import for importing the data.
The statement has been terminated.
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object '(SYSTEM table id: -1073380781)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.
Msg 9002, Level 17, State 2, Line 1
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
Any solution is welcome.
|
|
|
|
|
i think you should turn off updating of log
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi all, thanks for looking
I have a table in which i need to apply some conditions depending on the day
TableX columns:
ID int
Name varchar (50)
Mo int
Tu int
We int
Th int
Fr int
Sa int
Su int
Currently i have an SP that has 7 if else statements (1 for each day of the week (using datepart)) and these queries are almost identical, the only chnge is the column name
I would like to make this query smaller and i was wondering if there is another way to implement this
I wouldnt like to create a child table with the days values
Any advice will be appreciated
Thanks
Alexei Rodriguez
|
|
|
|
|
Use DATENAME(weekday, date) to return the name of the day that a particular date falls on.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks for your answer
Im using something similar (i dont know if faster):
datepart(dw,date)
What id like is to get rid of the if else statements
Will there be any way to acomplish this for this table structure?
Thanks again
Alexei Rodriguez
|
|
|
|
|
Use the CASE statement to select from a different field based on some criteria. Something like:
SELECT
CASE datepart(dw, date)
WHEN 1 THEN CAST(field1 as varchar)
WHEN 2 THEN CAST(field2 as varchar)
WHEN 3 THEN CAST(field3 as varchar)
etc...
END
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I have a parent table Item and a child table Grade. For a query, I would like to be able to select from a view or function that gives me one Item per row (as if I were selecting right from it) but adds an ntext column to the output, where its child Grades are listed in a delimited list. I'm not entirely sure where to go with this, without making it too terribly complicated. Please advise?
|
|
|
|
|
Google[^] is your friend here...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Not sure how feasible this is, but will ask in case someone has figured it out:
I have a table of people with people and a unique id and a name (amongst other things of course)
e.g.
uid | uName
I have a separate table that has entries where two of the IDs will get recorded
e.g.
date|signed(bit)|approved (bit)|signerID|approverID
I want to be able to retrieve the uName for signerID and approverID
e.g.
SELECT t2.date,t2.signed,t2.approved,t1.userName as signerName,t1.userName as approverName
JOIN (so that signerName and approverName both get resolved).
WHERE date < _SOMEDATE_
I know I could dump using a insert select on the people table into a temp table and JOIN against that, but wanted to see if anyone had a fancier/more elegant solution than that ...
TIA
|
|
|
|
|
Something like:
SELECT Approvals.Date, Approvals.Signed, Approvals.Approved, Signer.uName, Approver.uName
FROM Approvals
INNER JOIN People AS Signer
ON Approvals.SignerID = Signer.uid
INNER JOIN People AS Approver
ON Approvals.ApproverID = Approver.uid
Regards
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Works great! I've become so fixed on Left Joins lately ... I knew there was a way to do it with a 'looser' join, but couldn't quite nail it down. Thanks!
|
|
|
|
|
How can I change column orders by Transact Sql in Sql Server 2005?
I can do it in sql server 2000 by updating colid in syscolumns table . but sql server 2005 does not allow us to update system tables directly.
please help me. 
modified on Friday, March 7, 2008 9:52 AM
|
|
|
|
|
|
Hi,
I'm designing a reporting program that is being fed with a pre-defined and pre-filled dataset(passed with constructor to report form).The data set is consist of 2 tables and both of them are needed to display.I maked an exact replica of that dataset with dataset designer and dragging fields to report(Reporting Services Report).But the problem is only the first table of dataset is recognised and whille adding any field of of second one to Details section of report , designer produces something like this:
First(Fields!QTY,"Bill_OrderDetails")
(Bill is the replica Dataset and orderdetails is the second table)
and removing First Function causes compiler complains about not using
an aggergate function in detail section.
How can I use the second Table?
|
|
|
|
|
Hi,
I have 2 Tables with each his own columns
but they have both 1 identical column
I want to make a 3th table with the identical columns in
but not twice the same!
For example:
Table 1: ID1,Title,pages
Table 2: ID2,Title,Author
Table 3: ID3,Title (but when my title is the same in table1 and table2 i only want to insert it once)
So i thought,
I insert whole table1 in table3
then with a cursor, run through table2
and if i don't find the value in table3 insert Title from table2 in Table3
Is there another work around?
Thanks,
A.
|
|
|
|
|
Are the IDs in tables 1 & 2 the same? If not, what value will you insert into column ID3 in table 3 when you find matching rows?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Insert into table3
(ID3,Title,xxx)
Select ID1,Title,pages from Table1
Union
(Select ID1,Title,author from Table2
Where Title Not In (Select Distinct Title From Table1))
Best Regards,
Chetan Patel
|
|
|
|
|
Thank You,
I was looking way to far, for a solution...
|
|
|
|
|
i enter data in table at this order
kamal 78
kamal 78
kamal 78
kamal 45
kamal 45
mohan 12
mohan 12
suresh 23
suresh 23
ram 78
ram 78
mahi 23
mahi 23
and i want to display data on this like [note display according entry]
out put
name amount timeofpaid
kamal 78 3
kamal 45 2
mohan 12 2
suresh 23 2
ram 78 2
mahi 23 2
no knowledge in .net
|
|
|
|
|
You can do it with the help of Group By clause and count function.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
by using group by clause and count function
never give correct format according the order of entry in table
no knowledge in .net
|
|
|
|
|
select count(amount) as appeartimes,[name]<br />
from tablename group by amount,[name]
I Love SQL
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
