why should there be only one clustered index in a table? ...more >>

Dear SQL Friends, my question may be asked repeatedly before, but i couldn't find a straight answer for it. I simply want to run some scripts that creates tables and stored procedures through some command line tool so I can run them automatically. I am using SQL Server 2005 and SQL Serve...more >>

Hi, Consider this code-behind and below the stored procedure: everything works fine, except that the three records have all the same data (the last value: 30). Any idea what to change in the code-behind or in the stored procedure to fix that? Thanks a lot Francis code-behind: co...more >>

I get the error "Incorrect syntax near '@MyTbl'." from the following script; what am I doing wrong? Declare @MyTbl varchar(50) Set @MyTbl='MyTable' create @MyTbl table ( [Field1] [nvarchar](16) NOT NULL, [Field2] [nvarchar](35) NOT NULL, [Field3] [nvarchar](1) NULL, )...more >>

Is there much of a performance difference between DROP TABLE table and TRUNCATE TABLE?...more >>

We are using 64 bit SQL Server 2005 and one of the queries that was executing within 3 minutes fails to return once in a while. The problem is not predictable. The data is increasing every day. It does not seem to be the volume of the data that is causing the problem. I say this because if we ob...more >>

Hi, Can I use DBType.XML in .net 2.0 to pass xml string to a stored procedure in sql server 2000 ? It's just that I know sql 2000 does not have xml type. If this is true then how is it possible to pass very large xml string to a stored procedure parameter? Remember that the xml strings may ...more >>

I have 2 tables like the following: Example of tbl1: Account OrderNumber Quan 12345 12345-1 1 12345 12345-2 1 99999 99999-1 1 Example of tbl2: Account Currency 12345 F1 12345 F2 12345...more >>

Hello All, I cannot get sp_send_dbmail to send e-mail to my Exchange Server 2003 mailbox. Database Mail works fine when I "Send Test E-mail..." in Managment Studio. I've confirmed all things are configured and working correctly according to "Troubleshooting Database Mail: General Steps" ...more >>

I'm trying to figure out how to define a varaible that mimics a row type from a table. Then when I do a cursor fetch, I can grab the entire row and store its contents in this variable. I know it can be done in Oracle using the following PL/SQL code, I'm looking for the T- SQL equivalent. de...more >>

what's the difference between the following two CONSTRAINT created by SQl Server 2005 (Script Table As -> CREATE To) CONSTRAINT [MyColumn1$PrimaryKey] PRIMARY KEY CLUSTERED CONSTRAINT [PK_MyColumn1] PRIMARY KEY CLUSTERED ...more >>

Hello. I wish to create and schedule a procedure that clears out old archived orders we have stored. The problem I'm running into is that the archive table previously had no constraints about any primary keys. I wish to delete from 2 different tables based on the date in one of the tables....more >>

I have inherited several applications and I'm beginning to wonder about things I'm seeing. So before deciding that my predecessor was inept, I thought I'd find out if any of these things make sense. 1. In a table, I have a column called 'Attending' and it is a bit data type. Easy enough, ri...more >>

I am writing a view that will concatenate 2 fields, both numeric. I will need to convert them to a varchar in order to concatenate rather than add. The first field is a smallint character 10 in this case. The second field is a int sequential field that starts at 1 and can go up to 9999999999...more >>

My bulk query line works fine when executing it against a local database, bot not against a remote one. Will it not work in that case? If not, what's a poor boy to do to populate data on the server? BULK INSERT Country FROM 'D:\Win\FRC.COW.Feedyard.Database\FRC.COW.Feedyard.Database\Scr...more >>

I'm writing a web application and will be storing URLs in certain columns along with text desriptions. I originally started with everything as varchar(n). However, I'm thinking it will be better to go with nvarchar(n). The web app will be written in english but available to global users, wh...more >>

I am looking to execute a simple audit trigger and am able to accomplish when working within the database environment. Once the application runs and trys anything, it fails to continue its own updates. How can I create a trigger that is NOT seen my the application. My code is: ALTER TRIGGE...more >>

I have a VARCHAR field with datetime text in this format: YYYY-MM-DD HH:MM:SS How can I convert this to datetime so I can query on a date range for the last 2 months? I've heard of CAST but not sure if that works for this. Thanks ...more >>

Hi all, First off a disclaimer, I'm a very basic user of sql and stored procedures etc., it's not my job function, however I've managed to get some basic stuff up and running. However, I'm a frequent user of cursors and now I'm wondering if this is right. I've been reading in the group that...more >>

hey all, i have an employee history table like the following: EmpID,Start Date,End Date,Status 1,7/31/06,8/15/06,PartTime 1,8/16/06,null,FullTime 2,12/1/03,3/1/03,PartTime 2,3/2/03,null,FullTime Given there are duplicate entries needed for each employee, how would i say in a sql statemnet...more >>

I would greatly appreciate help with the following scenerio: I have 2 example tables here: create table tblloans ( loannumber int primary key ) insert into tblloans (loannumber) values (1) insert into tblloans (loannumber) values (2) insert into tblloans (loannumber) values (3) crea...more >>

I am passing xmlstring as varchar(8000) to be used inside the openxml query. At present I am using sql server 2000. The issue is that some of the xmlstrings are longer than 8000 characters. Tried using text but can not manipulate strings using text datatypes. What is the alternative please?...more >>

I am trying to copy data from a linked Oracle 9 database in to SQL Server 2005 using the following T-SQL. Is there a better technique that I can use excluding BCP, DTS, SSIS and VIEWS? INSERT INTO ProdDesc select * from openquery(MyLinkedServer, 'SELECT A.ProdId, A.ProdDesc, A.ProdCat, ...more >>

Hi all, I have a stored procedure that returns a recordset. For example create procedure up_HotelDetails @IDHotel int as select * from hotel where IDHotel = @idhotel Can I put a SELECT on the recordset that it returns? For example: Select rooms from (exec up_HotelDetails 1) Tha...more >>

Hi, Trying to use OpenXML to insert the xml data into table. As you can see in the sql code I am first trying to see if the select * works but nothing is returned. The idea is to eventually get this to do the insert into the table. can you please see what i am doing wrong? Here is the xml sa...more >>

Hi all, I have a table like this one: CREATE TABLE Expense( ExpenseType varchar(100), InTown char(1), Amount money) that, until now, it was used with this query: SELECT ExpenseType, SUM(Amount) FROM Expense GROUP BY ExpenseType Now I need to obtain something like this: ExpenseTy...more >>

Hi, I am converting a MS Access 2003 Application into SQL Server + .NET. I imported all the tables into SQL Server easily using the "import" option in SQL server But for Queries - I could not find any easy way to migrate all the queries Is there any direct import/export process available...more >>

Hi, I have a DTS in SQL Server 2000 which runs fine when executing it manually. The first step is a dynamic property task which uses SQL to dynamically set a Source Connection e.g. 'D:\Reports\Report 23- Feb-07.csv' The next step is to then transfer that data to SQL Server by the means of a Tr...more >>

Hi all, I have a table which contains the names of employees and their information. The [EmployeeName] field of the table is in unicode. Some of the names contains "-" (hyphens). I've read posts in Microsoft KB that the SQL Server will ignore the "-" when they do a sorting on unicode dat...more >>

I'm trying to set a smalldatetime column with a default of "getdate()". I get this error in SSIS: 'table1 (someSchema)' table - Error modifying column properties for 'DateModified'. There is already an object named 'DF_table1_DateModified' in the database. Could not create constraint. See p...more >>

Hello, I'm not an expert SQLserver user but sometimes I find myself working with it. Now I'm experiencing the above error when I try to connect to my SQLexpress 2005 database using the ODBC Driver for SQL2005. If I use the ODBC driver for SQL2000 it all works well, and I can't understand why...more >>

Hi, I'd like to translate this from Access SQL to 'true' SQL: SELECT "http:/mydomain/" & [Image] AS image_url I've tried several things but SQL Server doesn't accept it. How can I add this string to the value of that field? Thank you very much! Jerome...more >>

During form Load, I want to fill in the dataset and the close the connection at once. However, In SQL Server, I still find that the connection exists and the status is "AWAITING COMMAND". My client 's IT admin complaint that this connection should be disappear. I really got no idea about SQL adm...more >>