How to enter manually a "uniqueIdentifier" type value

I created a DB and a table in Visual Studio .NET 2003. For one of the column
I choose the data type uniqueidentifier.
How can I add manually a unique ID value in the table value editor?
OK, figured it out: select newID() as the default value.
"Frank" <someone@.nospam.com> wrote in message
news:c5f6j4$dpe$1@.news.mch.sbs.de...
> I created a DB and a table in Visual Studio .NET 2003. For one of the
column
> I choose the data type uniqueidentifier.
> How can I add manually a unique ID value in the table value editor?
>

How to enable the option of " Create New SQL Server database " from Database Explorer

Hi there

I am working on Visual Web Developer Express Edition 2005. When I right click on database explorer to create an SQL server database then I always find the option " Create New SQL Server database " Disabled.

Can any one tell me how to enable that option please ?

You are probably in the wrong forum for this question, but do you have SQL Server Express installed?

http://msdn.microsoft.com/vstudio/express/sql/

|||Why not download SQL Server Managment Studio Express? If you click the Add Connection option, you can create a database in the dialog that comes up. Just type a filename in the textbox that doesn't exist and you'll be prompted to create it.

How to enable the option of " Create New SQL Server database " from Database Explo

Hi there

I am working on Visual Web Developer Express Edition 2005. When I right click on database explorer to create an SQL server database then I always find the option " Create New SQL Server database " Disabled.

Can any one tell me how to enable that option please ?

You are probably in the wrong forum for this question, but do you have SQL Server Express installed?

http://msdn.microsoft.com/vstudio/express/sql/

|||Why not download SQL Server Managment Studio Express? If you click the Add Connection option, you can create a database in the dialog that comes up. Just type a filename in the textbox that doesn't exist and you'll be prompted to create it.sql

How to edit Stored Procedure from ASP.NET environment?

In visual studio 6.0, there are Database tools, including:
Data View
Database Designer
Query Designer
Source Code Editor for Stored Procedure and Triggers

From .NET environment, click Tools on menu bar --> Connect to Database, I can get the 'Data View', while click the table name in the Data View, I can get 'Qeury Designer'.

It seems the 'Database designer' and 'Source Code Editor' are missing.

Questions:
How can I edit, execute and deburg a stored procedure or trigger from within the .NET environment?

How can I create, modify a database, table and so on from .NET environment?

The most useful and important feature is from the question one. Thanks for any information.Hi,

Assuming you have an enterprise version of VS.NET, you can use the Server Explorer. It should be on the left side of the IDE, alongside the Toolbox. You can also select View | Server Explorer from the main menu.

Don|||Yes, I do have Server Explorer that is what I said the 'Data View' in Visual Studio 6.0. But, if you try to expand the database, and choose stored procedure, double click one of SP, you will see you cannot open it in the .NET environment.

In VS 6.0, if you right click a stored procedure, you will see several choices: open, execute, debug, new stored procedure and refresh.

But, in the server explorer, if you right click a stored procedure, you will only see run stored procedure and refresh.

It seems you have no way to edit a stored procedure. That should be the case, I believe, because this feature is quite useful and has been already integrated into VS 6.0.

By the way, I use pro version for .NET, but enterprise version for VS 6.0. Does it make any difference?|||Yep, that's why. As I mentioned, you need one of the enterprise versions to have these features. That's why you're not seeing them. And it's why youare seeing them in your enterprise edition of VB6.

Don|||That makes sense. Thanks, Don.|||Don, I have VS.Net 2003 Pro and can create and edit stored procs (and other objects) in the NetSDK instance of SQL Server on my PC but can not do this in the default instance, which contains my real databases. Do I need to move my databases to the NetSDK instance or upgrade to the Enterprise Edition to get the full functionality?|||Hi,

Hmm, I'm not sure about how each edition handles named instances. Hopefully someone else can chime in, although it's been a few days since you posted this.

Don|||What do you mean? Can you give an example?|||What do you mean? Can you give an example?

Are you asking that of me or dlgross?

Don|||Sorry, Don, the quesiton must be for dlgross.|||dlgross,

I have VS.Net 2003 Pro and can create and edit stored procs (and other objects) in the NetSDK instance of SQL Server on my PC

I have asked a question to you before, what did you mean? I have installed VS.NET 2003 Pro, but I didn't see the difference between VS.NET 2002 and 2003 for this issue. i.e., No way to edit Stored Procedure in .NET either 2002 or 2003 environment.

If you indeed can do it, could you show some example? I would rather like than "in VS .NET pro environment, Stored Proc cannot be edited" is a wrong statement?

How to drop database table if it exits in sql mobile version?

Hi,

I am using VB.net and Visual Studio 2005 to compile a program for a Pocket PC with Microsoft? Windows Mobile? 2003 Second Edition. I am using sql mobile also.

What I want to complete is like one of the following two queries. But when I tried them in the sql mobile, errors happened. So how can I complete the same function in sql Mobile? Thanks.

USE DBa

if exists (select * from dbo.sysobjects

where id = object_id(N'[dbo].[Table_a]')

and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop Table Table_a

or

USE DBa

IF OBJECT_ID('dbo.Table_a) IS NOT NULL

DROP TABLE dbo.Table_a

You should issue a query to check if table exists and if it does issue another query to delete it.

Please see SQL CE/Mobile books online for queries (hint: look for Information_Schema.Tables and Drop Table).

|||Thanks a lot, and your suggestion is great

How to download a file from a secure website

We need to download a file from a secure website using either DTS or Visual basic.Any idea??Q1 We need to download a file from a secure website using either DTS or Visual basic.Any idea??

A1 A suggestion would be to gather additional specifications (available from the website host?); generally that should constrain the possibilities somewhat and make different options easier to evaluate in relation to the local environment and local security requirements.

For example: (Is this a rare or one time event, or an hourly, daily, or weekly event? May one use / choose among vpn, ssl methods, etc.? How large a file is to be transferred and what is to be done with it?)|||use OpenURL method, it can do https

Inet1.URL = "https://www.mysecuredserver.com/myfile.txt"
bValidate() = Inet1.OpenURL(Inet1.URL, icByteArray)
Open "c:\myfile.txt" For Binary Access Write As #1
Put #1, , bValidate()

;-)
jiri