I have two tables:
info: ID, fee_id
and
fee: ID, amount
and a reference between them (SQL Server 2008):
ALTER TABLE info WITH CHECK ADD CONSTRAINT FK_info_fee FOREIGN KEY(fee_id)
REFERENCES fee (ID)
ALTER TABLE info CHECK CONSTRAINT FK_info_fee
GO
How to configure this reference that way so a record in fee will be deleted if info.fee_id becomes NULL
I have a web service that I just coded up that drops an image (png) into my SQL Server 2008 database as a varbinary.
Is there a easy tool out there that can let me see that image?
I could code up a client, but I would rather just use a tool if one exists.
When I rename a table column in Designer mode in SQL Server Management Studio 2008 (both R2 and non-R2) and generate a change script it looks like this:
EXECUTE sp_rename N'table.column', N'Tmp_columnNew', 'COLUMN'
GO
EXECUTE sp_rename N'table.Tmp_columnNew', N'columnNew', 'COLUMN'
GO
What for temporary column name is used? Why don't rename at once?
Hello everyone,
I am using SQL Server 2008 Enterprise and using the new Merge statement. From my experiment, I find source is always read only (table content not modified, i.e. no record is deleted/inserted/updated)? Is that correct understanding?
thanks in advance,
George
Hello,
I'm using Visual Studio 2008 Express and I would like Visual Studio (or perhaps an Add-in) to save my whole project to some sort of auto-incrementing archive or whatever would help me recover from disasters. I don't have much need for SVN or complex versioning systems.
I'm just looking for something simple and lean.
Any help would be much appreciated.
Jenny
PS : I looked into the built-in AutoRecover feature but it doesn't seem to save more than a few files.
Hi Experts,
Who can help me with this: I am working on Win7 x64, with VS.net 2008. I am developping for pocketpc.
When my application is deployed to the device emulator it can't connect to my computer / db server. Both de emulator as well the mobile device center are configured to use DMA. When I cradle the device using device manager, nothing happens.
What can I try?
Greets,
Jasper
Hi,
a colleague and I are trying pair programming for the first time. We both remote into a development machine; I'm using RemoteDesktop and my colleague is using UltraVNC. This works great except that he can't see the Intellisense dropdown in Visual Studio 2008. According to online posts, this may be something to do with DirectDraw, but I don't see much by way of a workaround.
Has anyone else experienced this?
Thanks,
Andrew
Would somebody please tell me whats wrong with this code
I am just calling a Sleep function from the kernel32.dll
What's wrong?
I am using Visual Studio 2008.
Any help would be grateful.
Thank you very much.
__asm
{
mov eax, 77e2ef66h
push 9999
call eax
}
I have a asp:GridView with a HyperLinkField. It's DataNavigateUrlFormatString property is set to View.aspx?id={0}&isTechnical={1}
Select command of appropriate SqlDataSource returns columns of type INT and BYTE (from SQL Server 2008).
So displayed string becomes something like View.aspx?id=1&isTechnical=1. But I want to display isTechnical=true|False, i.e. Convert.ToBoolean(row["isTechnical"]).ToString().ToLowerInvariant().
How to implement such conversion in page markup?
I was wondering if there was a way to extract all the values of a column, and then save each value into separate text files (labeled ANYTHING, 1-100 works fine).
I know how to do this through another language, but I'm using SQL Server 2008 with Microsoft SQL Server Manager and it would save me some time from figuring out how to do it through C#.
Hello
I am trying to deploy an application via Clickonce from one domain, where I'm logged in as DOMAINONE\Irwin to another, where I am granted permission via DOMAINTWO\deployer.
When I try this, Visual Studio (2008) reports:
Unable to access \\DOMAINTWO\publishfolder.
Any advice on how to accomplish this?
I have a Windows 2008 server with two IP addresses assigned to a single NIC. The DNS settings are setup to register the connections's addresses on the DNS server. nslookup shows both IP addresses for the server name. How is name resolution done in this case, i.e. which IP address does the DNS server return for a host lookup? Or does it return both, and the client selects one of the addresses?
Hi all,
how can I create a connection to excel file and view the result in vb.
I am using visual studio 2008, I have been trying to look for answers around but could not find one that teaches step by step.And what references do I need to use?
Thanks in advance.
Regards
Jason
I am using Visual Studio 2008 with C#. Is there a way to set the default editor for a class file containing a DataTable derived class? Whenever I double click on one of these classes to open the file VS attempts to open a component designer. Since my class isn't compatible with that editor this is a rather useless default. I would like these files to open up in the normal code editor.
Designer file is locked and when go to project properties it gives this error.
An error occurred trying to load the project properties window. Close the window and try again. The CurrentContext property of the LicenseManager is currently locked and cannot be changed.
.net framework 3.5
VS 2008
I'm new to Sybase and so far it's a monumental pain just to connect to it! Where in the world can I get 64 bit drivers for Sybase ASE 15 so that I can connect from my 64 bit SQL 2008? Our Sybase servers are 32 bit and there are no 64 bit drivers on the media :(
I use WebClient from System.Net Namespace of Visual Studio 2008 to download the HTML content.
It done well with normal website but with some 4rum that require authorization such as warez-bb.org, it always return the HTML of the login page.
I wonder if there is a way to send the username and password to the WebClient?
I am reading though the sql server 2008 bible and I am covering the views section. But he really dont explain the purpose of views. What is a good use for views. Should I use them in my website and what are the benefits of them.
Is there a way to tell how to get a file size that is uploaded to database?
SELECT [ID]
,[File]
FROM [dbo].[Reports]
I would like to be able to tell user the size of File which is VarBinary(max) field in MS SQL 2005/2008. How to do that?
Maybe the only way to do is to create another column and when inserting file i should also insert it's size in additional column?