Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008?
For example, I need a column called Frequency (varchar) that only accepts 'Daily', 'Weekly', 'Monthly', 'Yearly' as possible values
Is this possible to set within the SQL Server Management Studio when creating the table?
Do you know if there is a build-in feature or free add-in for Microsoft Visual Studio 2008 that easily generates C-Headers and keeps them in sync with their .c counterparts?
I have already looked at Visual Assist X, but I'm not really willing to pay money at the moment.
hi
i have C# program (in Visual studio 2005) and i try to connect and
work with sql-server 2008.
the connect is success but i get this error:
this server version is not supported. you must have Microsoft SQL server 2005 Beta 2 or later
what can i do ?
thank's in advance
So I have a number of namedRanges in an excel worksheet. I would like to use these to fill in comboboxes on a user form in the same WorkBook.
I have tried:
cboMember.DataSource = Globals.Sheet1.MemberRange.Value
No error is given but the combo is blank. Does anybody have any ideas?
I'm trying to use VSTO for VS 2008 on an excel 2003 work book.
I have a .DLL that i include in my Visual Studio 2008 project. The .DLL came with a .XML file that has all the comments for the properties and functions.
How do i make it so that VS loads up these comments as Intellisense, so that i have a definition for the functions?
In Visual studio 2008 is it possible to have a resource file that is included as a separate file after compilation rather than as an embedded resource. This is to enable small changes to be rolled out more easily.
I have tried build options of Resource, None, Compile and also copy local on and off for most of these. However when ever I try access the resource at run time I get a cannot find resource exception.
Is this actually possible or am I wasting my time?
Hi All,
According to the following section of BOL:
How to: Use Source Control with SQL Server Management Studio
If you have a source control client installed you should be able to choose it in the plug-in selection. I have both source control clients for Visual Studio 2005 and 2008 (tfs2005) installed and there's no plug-in to choose in the list for me.
UI is created in VS 2008. I'm using C# .... I need to let the user move/focus between text fields from top to bottom by clicking tab button. How can i do it?
My SQL Server 2008 server gets flooded with dynamic SQL from one stored procedure. I am wondering whether I can tell SQL Server not to store this one stored procedure in the pool as it doesn't matter too much whether it executes quickly. Perhaps there is an equivalent of (nolock) for (nobuffer) or similar?
Any ideas?
I'm trying to use a dynamically generated fully-qualified table name in sql server 2008. For example, this does not work:
select max([id]) from @dbName+N'.[T1]'
This will give an error like:
Msg 102, Level 15, State 1, Line 73
Incorrect syntax near '+'.
I know that something like this works:
declare @qualifiedTable varchar(200) = @dbName+N'.[T1]'
select max([id]) from @qualifiedTable
But I have to do this LOTS of times so I would really like to do it in line. Is it possible?
I have panel that I have customized. I use it to display text. But sometimes that text is too long and wraps to the next line. Is there some way I can auto resize the panel to show all the text?
I am using C# and Visual Studio 2008 and the compact framework.
I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?
An insert statement with a large number of values returns 'Error converting data type varchar to numeric.'
How can I find which value actually triggers the error?
MS SQL Server 2008 is used.
If I have 3 million pages, which directory structure is better?
Method 1. ~/123456789.htm
(Putting all the 3 million pages into
the same folder without any sub
folders)
Method 2. ~/789/123456789.htm
(Create 999 sub-folders, each
sub-folder contains about 3000 pages)
For Windows Server 2008, which folder structure is faster? (For file creation, reading and deletion)
hi
i have Database with date field.
i see the time like: 1900-01-01 13:38:00.000
how i can see it like: 13:38 ?
(i work on sql server 2008)
thank's in advance
I have a ComboBox. It is critical that the user cannot scroll by accident and change the selected value.
How can I prevent the ComboBox from changing the value and text when the use scrolls? Thanks.
Visual Studio 2008
Is there a way in Visual Studio 2008 to go from a closing brace to it's opening brace? I've found a fair amount of stuff about highlighting the brace, but nothing about moving the cursor to it.
Visual Studio 2008 shows a lot of erroneous errors when building a website (not a web project) in the errors list. These errors are usually corrected (removed) when I rebuild the site a couple times but they cost me wasted time.
Is there anyway to hide the erroneous errors?
How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)
If I have 3 million pages, which directory structure is better?
Method 1. ~/123456789.htm
(Putting all the 3 million pages into
the same folder without any sub
folders)
Method 2. ~/789/123456789.htm
(Create 999 sub-folders, each
sub-folder contains about 3000 pages)
For Windows Server 2008, which folder structure is faster? (For file creation, reading and deletion)
I've just finished a functional peace of code and would like to upload it to the internet as freeware. It is just a window form application.
I used C# and Visual Studio 2008.
I wan't to know if it is legal to do this...
Thanks for reading this.
When installing SQL Server Express Edition 2008, checklist says
"Previous version of Visual Studio 2008"
and asked me to upgrade to sp1. Unfortunately sp1 for some reason refuses to install on my brand new pc (Windows 7).
So why can't I just bypass this ? Why would SQL Server Express needs VS2008 to install that's insane.
SQL Server install used to be as easy as 123, now it has become a nightmare like installing Oracle.
Will I have to go back to Windows XP ?
I have a table which has a bunch of columns but the two relevant ones are:
Due_Amount MONEY
Bounced_Due_Amount MONEY
I have a SQL query like the following
SELECT * FROM table WHERE (Due_Amount 0 OR Bounced_Due_Amount 0)
Would the best index to put on this table for SQL Server 2008 be an index which includes both columns in the index, or should I put an separate index on each column?