Programming SQL

Default values not being applied on insert in SQL 2005 virtual server
My database has just been moved from a regular server running SQL Server 2005 to a virtual server running SQL server 2005. I have been getting calls today because integer fields that are set to NOT allow nulls and have a default value of 0 --- defined in the table as ((0)) -- are not being set to the default value whe... 29 Mar 2010 14:46

Need help with a stored procedure
I know I need a course in SQL but I need to fix this before that happens. Below is a procedure that use to work before I changed ASC to DESC in four places. I probably needed to do more to make it descend instead of ascend. Now I always get the same data returned. I believe it is the data at the end of the stor... 29 Mar 2010 15:52

selecting and inserting existing and non existing rows into tableparameters and variables
Andy B. wrote: 1. Select all rows that exist both in the TVP @Headlines and in the table [Headlines].[Headlines] and insert them into a table variable @ExistingHeadlines. INSERT INTO @ExistingHeadlines (<columns>) SELECT <columns> FROM @Headlines INTERSECT SELECT <columns> FROM [Headlines].[Headlines];... 29 Mar 2010 11:23

Remote Access Steps
Dear Sir, I had developed Application using Visual Basic 6, Microsoft SQL Server 2005, ADO 2.5, DSN having Driver SQL Server If I run that application in Local Area Network is works very fine. But If I try to access through Internet then it speed is 100 time slow then Len. I wrote one query in Stored Pr... 29 Mar 2010 10:15

Get Total Rows.
If you are doing paging you need to pass back the total number of rows of the query. What is the best way to do that? What one person does is do the SELECT/INTO a temp table to get the total number of rows. Then he does a "SET ROWCOUNT @RowNumber", then does a SELECT * ... The problem here is that he is... 18 Apr 2010 18:38

Row_Number() Sorting
I am a little confused as to what Row_Number is doing based on the execution plan. If I have a table: CREATE TABLE T (PK INT IDENTITY, A INT, B INT, C INT, D INT) CREATE UNIQUE CLUSTERED INDEX TPK ON T(PK) INSERT T VALUES (0, 1, 8, 3) INSERT T VALUES (0, 3, 6, 5) INSERT T VALUES (0, 5, 4, 0) INSERT T VALUE... 26 Mar 2010 20:30

Query Optimization
I have a table with the following structure (plus a couple of other unused columns): dtDateTime; intID; intValue There are multiple entries with the same dtDateTime value such as: 1/1/2010 00:00:10; 1, 10 1/1/2010 00:00:10; 2, 34 1/1/2010 00:00:10; 3, 23 1/1/2010 00:00:10; 4, 75 The goal is to get a resul... 26 Mar 2010 13:12

BULK INSERT with Format File..
Friendly. I have the following table in server SQL 2005. CREATE TABLE dbo.acontlab( WCLOT numeric(8, 0) NOT NULL, WCFEC numeric(8, 0) NOT NULL, WCHOR numeric(8, 0) NOT NULL, WCUSU varchar(10) NOT NULL) I want to concern a flat text file without delimiters with name ACONTLAB.TXT. I put the first registrie... 26 Mar 2010 20:30

urgent date format problem help needed....
Hi, I have a vb.net application that is inserting data into a sql table. one of the cols in my table, is of type date. My sql statement is insert into tbl_opsJournal (article,action,quantity,container,status,job_number,date) values ('R5W','-',6,'00101','00','123','26/3/2010 13:41:00') The insert fail... 26 Mar 2010 09:11

missing Index DMVs
I tried to do the samples in: http://blogs.msdn.com/queryoptteam/archive/2006/04/06/570176.aspx And they worked fine. index_handle database_id object_id equality_columns inequality_columns included_columns statement ------------ ----------- ----------- -----------------------------------------------------... 26 Mar 2010 14:23