I have the following table of TIME datatypes clarification: I am representing hours/mins/seconds of videos and want to figure out how long the videos will be. runtime ---------------- 01:27:19.0000000 01:26:09.0000000 01:00:56.0000000 01:09:59.0000000 01:25:43.0000000 01:16:01.0000000 01:27:12.0000000 01:22:00.0000000 01:17:47.0000000 ...
i have a series of T-SQL statements separated by the special Query Analyzer batch separator keyword: GO If one batch fails, i need Query Analyzer to not try subsequent batches - i want it to stop processing the series of batches. For example: PRINT 'This runs' go SELECT 0/0, 'This causes an error' go PRINT 'This should not run' go...
I was wondering if there is a sql statement to get the current size of all the databases on your server instead of right clicking and going to properties for each one. ...
Currently my website is written in ASP.NET Webforms using a SQL Server database. I am planning to build a ASP.NET MVC application not because it's better but because I want to learn the technology. My question is more specific to the database. I can create the database and import my SQL table via the import feature of the web interface t...
Table A Col1 Col2 101 102 101 103 102 104 104 105 Table B Col1 101 102 103 104 105 I want to take data from Table A and insert it into Table B as a Distinct value in one query so INSERT INTO TableB (Col1) (SELECT ...) Any ideas? ...
Can someone give me the skeleton body of an Instead of Insert Trigger for MSSQL. I am trying to test the largest value in an Purchase Order Column (which is an integer) and on insert it grabs the largest value increments that by one and inserts that as the Purchase Order ID. The column was not setup with an Auto Increment option so I am ...
i have read this dead lock problem When database tables start accumulating thousands of rows and many users start working on the same table concurrently, SELECT queries on the tables start producing lock contentions and transaction deadlocks. Is this deadlock problem related with TransactNo updlock? If you know this problem, let me kn...
1.Database platform: SqlServer 2.Data Access: nHibernate 1.2 Now we need access the store procedure by nHibernate,like this: ALTER PROCEDURE TestProc() AS BEGIN Select * From User Return 1234 END I know I can get the User List by IQuery, And I want to get the default return value "1234" too. Question: How to...
I have to study about data mining using SQL Server. As I know, Business Intelligence in SQL Server supports data mining, but I'm not pretty sure. Does BI really support data mining? How can I start with data mining with SQL Server? I mean, resources such as books, blogs,..etc Thank you all. ...
Is using MS SQL Identity good practice in enterprise applications? Isn't it make difficulties in creating business logic, and migrating database from one to another? ...
When I try to change this columns list: Nombre Imagen Descripcion Activo IdLineaProducto into this (IdLineaProducto is first) IdLineaProducto Nombre Imagen Descripcion Activo SQL Server Management Studio says that it's not allowed to save changes because the table must be deleted and recreated (in spanish...). I could do this in S...
Sorry for the dumb question as I'm a newbie. If I wanted to build a commercial Windows application (one I'll sell for $), what are my options in terms of an embedded datastore? Would I use MSDE? Is this something that I'd bundle with my app? Are there other options (both from MS as well as other vendors)? Do you have to pay a fee to...
I am running SQL Server Reporting Services on SQL Server 2008 Standard and trying to get the web pages to work. What do I have to do to get RS (Report Manager, Reporting Services Connection), to see me as an admin in the first place so that I can make then change my role and look at the Web Service URL properly? I have Windows auth...
I have implemented full text search over SQL Server 2005 database using CONTAINSTABLE keyword. I was wondering is there a way to add a "sounds like" or google's "did you mean THAT" functionality if the original query yields no results. ...
I have a calendar on my website and i need to add recurrent events and outlook export. What is the best way to handle recurrent events? (mssql + C#) How can I export multiple events to outlook 2003? Thanks. ...
Hello, here is my setup: Sql server 2008 standard running on Vista - VMware running a XP machine with VS2008 inside it. If I open a SQL database in my host computer in sql server management studio and make structure changes to the database and then go back to visual studio, my visual studio has lost connectin to the database (says a n...
How do I get a maximium daily value of a numerical field over a year in MS-SQL ...
Hello everyone, I understand how to manully connect to a SQL Server data source and input SQL statement to generate/publish a report on the web. My question is, I want end user to input some parameter values, then use such parameter values as SQL statement parameter values (e.g. using end user input time range as SQL statement parameter...
I`m using Card Five ID Printing Software for ID Card Printers. It is card design software, and I want to print cards with data that is stored in MSSQL Server database. The problem is with storing photos of employees. I tried different formats JPG, BMP and I used binary reader from C# to populate image filed in my database. I would aprec...
I am using SQL Server 2008 express edition. I have connected before. Now I get this error message: TITLE: Connect to Server Cannot connect to GEF65439\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Serve...