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 am a SQL Server (2005 & 2008) data warehouse developer (SSIS, SSAS, SSRS, SQL) and I am wondering if it would be worth the effort and time to learn Powershell scripting. Are there applicable uses from a development perspective? I understand that from a DBA view there is considerable power in Powershell for administration - does any of this translate to useful commands for a developer?
Thanks!
I have a ASP.NET solution in Visual Studio 2008 and I added a file identical to http://plugins.jquery.com/files/jquery.cookie.js.txt named jquery.cookie.js in a subfolder of my project containing other javascript files and Visual Studio is treating it as a C# file, giving me errors like CS1012: Too many characters in character literal and Semicolon after method or accesssor block is not valid.
Why?
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?
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 backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or so.
Suddenly, the database is now stuck in "(Restoring...)" state in Management Studio and has a green arrow icon, and my application login is failing!
Any advice? :-)
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?
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.
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.
What are "directoryentry" and "directorysearch" controls in Visual Studio 2008? How do they work? What are there real-world applications? What about their properties?
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.
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)
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?
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
In a SQL Server 2008 R2 database, given this schema:
AgentsAccounts
_______________
AgentID int UNIQUE
AccountID
FinalAgents
___________
AgentID
I need to create a query that does this: For each AgentID 'final' in FinalAgents remove all of the OTHER AgentID's from AgentsAccounts that have the same AccountID as 'final'. So if the tables have these rows before the query:
AgentsAccounts
AgentID AccountID
1 A
2 A
3 B
4 B
FinalAgents
1
3
then after the query the AgentsAccounts table will look like this:
AgentsAccounts
AgentID AccountID
1 A
3 B
What T-SQL query will delete the correct rows without using a curosr?
Hi !
I' written this UserControl:
<my:MyUserControl x:Class="MyClass"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:my="clr-namespace:MyNameSpace.MyControls;assembly=MyAssembly">
</my:MyUserControl>
public partial class Editor : MyNameSpace.MyControls.MyUserControl {}
Everything works, the control is shown in the VS 2008 Designer, but I cannot click directly in the elements and select them as it was with UserControl.
Any idea how to solve it?
hi
i have sql-server 2008 database that in the main server.
i have 10 terminals that connect to this server and work against the database.
i need that every new inserting to database through any terminal - in the server this
line will inserting to text file (every line)
can i do it ?
thank's in advance
I am using C#, Entity Framework and SQL Server 2008 Express.
I am connected to the database over internet.
What is the best method to speed up saving/updating data to database?
It takes 60 seconds to save 140 records to database.
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 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 BIT (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?
In a C# Winforms-App I have several user settings stored.
Is there an easy way to clear those settings each time I start debugging the project from Visual Studio 2008?
Otherwise it always starts up with the settings from the last debug-session.
Thank you!
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)