|
Brady Kelly wrote: The user is linked to login 'sa'.
If the user is "sa" surely they have permission to do anything?
|
|
|
|
|
The term 'surely' is the most innaproprate term I have ever come across for describing anything related to this area of SQL Server security.
|
|
|
|
|
Okay - "sa" has permission to do anything it likes.
|
|
|
|
|
Except create unsafe assemblies. I had to log in under my Windows account and grant that user the unsafe assembly permission.
|
|
|
|
|
Ah... I'm still going on my knowledge of SQL Server 2000. My bad.
|
|
|
|
|
Hi
I have a table with datetime field and a stored procedure which should update this table on the date n time specified. This should take place automaticaly at the specified date and time.
Kindly suggest any solutions to this query.
Thanking you in anticipation.
Regards
Siddhi
|
|
|
|
|
Helllo All,
I want to keep my database secure by backened. Actually i donot want to let anybody to make any modification in my database(Sql Server2000) through Enterprises Manager and also only the authorised users can have accesss to the database through frontened(ASP.NET)
Plz.......................
..........................
|
|
|
|
|
The Knowledge wrote: Actually i donot want to let anybody to make any modification in my database(Sql Server2000) through Enterprises Manager
Not gonna happen.
Enterprise manager can connect to the database using any account that has been set up. (Typically it will connect as sa [the sys admin]). If you have any kind of access to the database from an application, Enterprise Manager will be able to connect using the same credentials.
|
|
|
|
|
I'm busy musing over the best way to deploy a CLR stored procedure. Where do I put it before pulling the assembly into the database? Do I use a normal setup routine to an install folder and then invoke my deployment scripts using the code-base in that folder?
|
|
|
|
|
|
Hi,
I have 2 tables ,say A and B.
A: (ID Col1 Col2)
B: (ID Col3)
ID-Unique Column.
I want to move col2 from A to B.
Hence I have added a new column in table B, say col4.
I want an update statement that will transfer A.col2 to B.Col4.
<div class="ForumSig">Regards,
Arun Kumar.A</div>
|
|
|
|
|
Update B <br />
Set Col4 = A.COL2<br />
FROM B<br />
Inner Join A on A.ID = B.ID
Or
UPDATE B<br />
SET COL4 = (Select COL2 From A Where A.ID = B.ID)
Wout Louwers
|
|
|
|
|
It is working.
Thank U very much.
Regards,
Arun Kumar.A
|
|
|
|
|
hi all,
I am not well versed with queries in SQL.
i have a table , product as following
productID productname CategoryID
1 xxx NULL
2 yyy 1
3 zzz NULL
and in the categories table
categoryID categoryname
1 Cat01
2 Cat02
i need to combine these two tables and get the following
productID productname categoryname
1 xxx NULL
2 yyy Cat01
3 zzz NULL
i wrote this query
select c.categoryname,p.productid as pid,p.productname
from product p,categories c
where p.categoryid = c.categoryid
or p.categoryid<>c.categoryid
and this is the result i get
productID productname categoryname
1 xxx Cat01
1 xxx Cat02
2 yyy Cat01
3 zzz Cat01
3 zzz Cat02
Can anyone help me with this query?
Thanks in advance
Regards
Anuradha
|
|
|
|
|
select p.productid, p.productname, c.categoryname<br />
from product p<br />
Left join categories c on p.categoryid = c.categoryid
Wout Louwers
|
|
|
|
|
Hi,
Really thanks for your reply.The query which you gave works perfectly.But now my requirement is
I have a table , product as following
productID productname CategoryID companyId
1 xxx NULL 1
2 yyy 1 2
3 zzz NULL 1
and in the categories table
categoryID categoryname
1 Cat01
2 Cat02
Company Details
CompanyId CompanyName
1 ABC
2 CCC
i need to combine these two tables and get the following
productID productname categoryname companyname
1 xxx NULL ABC
2 yyy Cat01 CCC
3 zzz NULL ABC
how can i write a query for this?
Please help me
Thanks in advance.
Regards
Anuradha
|
|
|
|
|
I think you should be able to solve this yourseld with the help of my first answer...
Wout Louwers
|
|
|
|
|
hi wout,
Thanks very much for your help.I sorted out the query.Its working now.
i am posting the query if anybody needs it in future.
select p.product_service_id, p.product_name,p.tvc_duration,
p.format_type,p.total_fees,c.category_name,m.company_name
from product_service p
Left join company_details m on p.company_id=m.company_id
Left join categories c on p.category_id = c.category_id
Thanks once again
Regards
Anuradha
|
|
|
|
|
I NEED TO UPDATE THESES RECORDS BASED ON THIS QUERY
select * from property where
Lis_key in(select lis_key from property where substring(func_key,1,5)='GEOSS'
And substring(func_key,6,8) >=3)and
Func_key = 'PV000000'
and substring(Attrib_code,5,2)!=16
AND ACTIVE = 1
order by Lis_key
HELP ME
Vuyiswa
|
|
|
|
|
DON'T SHOUT
Just use
update <tablename> set <columnname> = value, ...<br />
Where...
Wout Louwers
|
|
|
|
|
Please tell me sql queery which returns the recordset between two date inclusive of two dates
|
|
|
|
|
"select * from from table where coldate between date1 and date2"
date1 and date2 should be according to database format.
Regards
Shajeel
|
|
|
|
|
I always avoid BETWEEN because it is not clear whether it is inclusive or exclusive. If there was a bug that another developer had to fix I'd want to keep the intent as clear as possible.
|
|
|
|
|
I will keep this in mind. thanks.
Regards
Shajeel
|
|
|
|
|
sonia_basangar wrote: Please tell me sql queery which returns the recordset between two date inclusive of two dates
You have not provided enough information to do that. However, I can tell you that in your WHERE clause you will need something that looks like this:
MyDateColumn >= @SomeStartDate AND MyDateColumn <= @SomeEndDate
Remember that for the end date, you may have to set the time element to 23:59 if you are storing a date and time and want the results for any time on the end date.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
