SQL Server database programming

Hi, I wanted to start a general discussion more for getting some thoughts on what other people think/practice out there just to see how far (if at all) I'm off base on my own thoughts. My primary experience is developing applications using VB or DotNet.  I ...

I have a table that includes a DateTime column. I need to create a select statement that displays the number of entries for each period: Period                      Count ...

Hi, I have a table with an id column and text data type column. My following query runs fine on Sqlserver 2000, but in SqlServer 2005, It gives me an error "Invalid character value for cast specification". Does anybody have ...

I am running SQL 2005 on a Win 2k3 R2.  I currently have 4GB FB-DIMM and an Intel 5150 (Core 2 Duo Xeon) processor.  I want to upgrade but don't have the money to upgrade both ram and processor at this time. ...

What's the difference between the following 2 queries especially the 1st line after declaring the variable @OrderCount int in the 2 queries (both the queries output the same resultset): -------------------- DECLARE     @OrderCount int SET @OrderCount = (SELECT COUNT(OrderID) FROM Orders WHERE UserID = 5) ...

While researching using BCP in a stored procedure, the that xp_cmdshell needs to be used.  I can not use xp_cmdshell due to security reasons. Is there any other way to use BCP in a stored procedure? Thanks in advance. ...

Hi, I have the following query:- SELECT DISTINCT TOP 10 PERCENT dbo.tbl_cleaning_visits_internal.cvi_id, dbo.tbl_main.m_internal_block_type FROM         dbo.tbl_supervisor_block_pre LEFT OUTER JOIN                       dbo.tbl_main INNER JOIN ...

Let's say I have a table with 650 columns and similar .NET class with 650 public properties.  There are 10,000 instantiated objects that give the same number of rows in the table.  I loop through all objects ...

I need to replicate a SQL Server 2000 database that exists in a hosted environment with only primative web-based management tools. I have one tool that creates a .bak file, and another tool for running queries. There seems to be no way to automatically script the tables the way we can in Enterprise ...