|
In a join which table is said Left, which one right?
It depends on List in select or order in On or ...
Best wishes
|
|
|
|
|
table1 left join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table1 plus matches record from table2
table1 right join table2 on table1.id=table2.id
here table1 is left table whereas table2 is right. Query return all record from table2 plus matches record from table1
hope this clear your confusion
|
|
|
|
|
The left one is the one on the left of the join and the right one is the one on the right of the join.
That is in Left-to-Right text. I cant imagine how messed up queries would look in Hebrew (RtL)
|
|
|
|
|
See the following example:
Select table1.*, table2.*
From table1
join table2 on table1.Id = table2.Id
In the above example table1 is considered left and table2 is considered right.
|
|
|
|
|
Dear All,
I need to reduce the log file size...
I've created a maintenance plan for shrinking the DB in my local machine, I've created every thing ok and scheduled it to work daily. and when I right click and then execute, the dialog displays successful process, but when I check the DB Log, it still huge size (about 20 Gb). I do not know why the log file size still huge after shrinking the DB.
Any help, plz???
Kind Regards
OBarahmeh
|
|
|
|
|
Did you try gogole search?[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Ok, I've found the solution:
USE yourDB;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE yourDB
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (yourDB_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE yourDB
SET RECOVERY FULL;
GO
Kind Regards
OBarahmeh
|
|
|
|
|
Hi Guys
I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck.
Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help.
Kind Regards,
Elizma
|
|
|
|
|
Can you put query or any example
|
|
|
|
|
Hi,
Thanks for the willingness to help. I dont know what the problem was, but I deleted the report table, recreated it and then it worked fine.
Elizma
|
|
|
|
|
|
Hi mates , i am a new joinee...need guidance .....it's a SOS...
These days i am busy implementing Data Mining/Data Warehousing issues for clients.I am facing a critical issue regarding Ab Initio.
I need guidance regarding it's licensing issues and comparitive analysis with other ETL products...
|
|
|
|
|
|
Your image link doesn't work.
Can you post your error message or post once again your image error.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
How you try to connect in that sql server? Remotely? If yes then that Server must login with username SA and password SA.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
SQL server does not exist or access denied.
What part of that error message is unclear?
|
|
|
|
|
|
thx for all
the problem was solved
BESHOY
FACULTY OF COMPUTER AND INFORMATION
COMPUTER SCINCE DEPARTMENT
|
|
|
|
|
Hello all,
I have a table in which I have added new one column and now I want to add data to it. What I want is that column starting values should be from some number and end with the number of rows.
Like if I have 1000 records in by table then I want this column to have values from 2200 to 2200 + 1000.
I hope I made myself clear.
Please help me.
Thanks in advance.
|
|
|
|
|
declare @newValue as int<br />
set @newValue = (selex max(colname) from tablename)<br />
<br />
insert into tablename ColumnName <br />
values (@newValue+1)
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks for the reply but I dont want to insert the records. I want to update one columns values which null now.
How can we do this??
|
|
|
|
|
I don't understand good ur questions.
To update columns which have null value then simple use Update tablename where colname=null and coname=anothercondition
If this is again not help then describe in detail your case.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Well what I want is:
Table Name: tb_Data
Columns: Name1, Name2, ID
Number of Records : 1000
Something like this:
Name1 Name2 ID
----------------------------------------
N1 N2 null
N3 N4 null
N3 N4 null
N3 N4 null
Like wise....
N3 N4 null
Now ID Column has null values and in ID Column I want it to get values starting from 2200 to 3200 that is records should be now as:
Name1 Name2 ID
----------------------------------------
N1 N2 2200
N3 N4 2201
N3 N4 2202
N3 N4 2203
Like wise....
N3 N4 3200
Is there anyway to do it by Query as Im having records in lakhs.
Thanks again.
|
|
|
|
|
hi,
Well based on your last post I have more clear your situation.
It seems that you dont have increament column in table and i make fast solution,maybe is not the best solution but it will work.
here is code down below,just copy-modify-paste and use in your real data
create table #TempTable <br />
(<br />
IdentValue int IDENTITY(1,1),<br />
Name1 varchar(255),<br />
Name2 varchar(255),<br />
ID Int<br />
)<br />
<br />
insert into #TempTable <br />
select name1,name2,id from tabela<br />
<br />
<br />
declare @i as int<br />
set @i=0<br />
<br />
declare @startValue as int<br />
set @startValue =2200<br />
<br />
declare @endValue as int<br />
set @endValue=3200<br />
<br />
while @i<(select count(*) from #temptable)<br />
begin<br />
set @i=@i+1<br />
set @startValue=@startValue+1<br />
update #tempTable set ID=@startValue where identValue=@i<br />
end<br />
<br />
delete from tabela<br />
insert into tabela <br />
select name1,name2,id from #temptable<br />
<br />
drop table #temptable<br />
select * from tabela
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|