|
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.
|
|
|
|
|
Thanks in adv.
Hello,
I want to change the filed length of a fields let suppose item_Name which is in more then 1 table
let suppose 10
the below query will give me the names of those tables
select sysobjects.name from syscolumns
left join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name like 'Item_Name' order by 1
now i want to update all those table having that field , length to more but i could not even while using cursors
Regards ,
mirza Rahman
|
|
|
|
|
use Alter Table to change the column widths.
Never underestimate the power of human stupidity
RAH
|
|
|
|