Do you have Windows 7 64Bit and you are trying to install SQL Server 2008 Management Tools and cannot?
{Programming} & Life has the long answer at this link
Here is the short answer from the same site.
FIX – INSTALL BACKWARDS!
So that’s the logic, install everything backwards:
First the SQLManagementStudio_x64_ENU.exe to install your tools, and then SQLEXPR_x64_ENU.exe to install your database services. Or perhaps if you are happy with an all in one package, go for this guy – Microsoft® SQL Server® 2008 Express with Tools it’ll probably save you a lifetime of headaches. Don’t try to be tricky like me and get separate installs.
Here are two variations of looping through rows in Oracle PL/SQL. The FOR structure reduces the amount of code, in either case is it more perference than anything else.
----------------------------------
--Cursor - For Loop
----------------------------------
for i in (select constraint_name, table_name
from all_constraints
where constraint_type = 'R'
and owner = lv_owner
and status = 'ENABLED')
LOOP
execute immediate 'alter table ' || i.table_name ||
' disable constraint ' || i.constraint_name || '';
end loop;
----------------------------------
--Cursor - For each record
----------------------------------
declare cursor csr is
select constraint_name, table_name
from all_constraints
where constraint_type = 'R'
and owner = lv_owner
and status = 'ENABLED';
begin
for rcd in csr
loop
execute immediate 'alter table ' || rcd.table_name ||
' disable constraint ' || rcd.constraint_name || '';
end loop;
end;
This example will load a list box of documents from a network share. It will then allow the user to select the file to print from the browser.
1. Create a class that contains the name of the file and full path and file name. This will later be used to add to a generic list.
![](../image5793.html?picture=2011%2f7%2fNETFILE_Class.png)
2. Create a method that will read all the sub-directories and file names to load to a list box.
![](../image84b4.html?picture=2011%2f7%2fNETFILE_GETFILES.png)
3. When the user selects an item from the list render open the document (example a PDF) in from the browser.
![](../image515c.html?picture=2011%2f7%2fNETWORK_RENDER.png)
For an example of how to render an object (PDF, Word, ZIP...) to the browser for opening see this post.
Code snippet attached.
Get_Network_Files.cs (2.69 kb)