If I don't want to put brackets around my table names (that are reserved keywords) every single time I need to reference them in SQL, what are my alternatives? Case in point, a table we wish to name "User": 1) Deal with the brackets and go with [User] -- this would kill me 2) Instead of [U...more >>

Lets say I have a table Emp EmpID int , LastName varchar(12) , FirstName varchar(12) If I need to mass populate this table with... say.... 1,000,000 rows, what's the quickest way to do this? I am developing a new database, and a top thing on the list is to populate with alot of (like ...more >>

Hi I had a SQL Server database by name Jap.Recently my c drive crashed and i have only jap_data and jap_log files stored in D drive.Can i restore back these files so that i will be able to use them?I had few critical office data and would appreciate a quick help in this regard My Best Antony...more >>

I'm basically a database noob hoping to find a shortcut if at all possible. I've created an ER diagram for a site I plan to build and have used that to create the database in MS SQL 2000. Now I want to import various data from (basically) excel spreadsheets (for example, company names from ...more >>

Hi, I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL Mail and Agent Mail can use the file of mail profile to send email. But on one of client's computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail when...more >>

I was curious about whether is is wise to use the database name in a select statement or Create Procedure such as: SELECT * FROM ft.dbo.theTable SELECT * FROM ft..theTable or CREATE PROCEDURE ft.dbo.GetData CREATE PROCEDURE ft..GetData I was curious as someone had mentioned that was ...more >>

SQL2005 Where can i find information on scheduling DTS package within 2005? as well as making sure we have everything setup and configured correctly to create and schedule DTS packages.... ...more >>

Hi, I created an account called "DBLogin" and used this account to log in and created an database called "DBTesting". and the owner of the database is "DBLogin". Then I found out when I create a schema that is owned by "DBLogin" and it fails. Since the owner of a schema have to be a user...more >>

We're running SQL Server 2000 and I've suddenly been appointed junior DBA (not my usual job.) Some one refresh my memory. Is there any simple call or sp that would give usage info? By 'usage info' I mean things like how long ago a server or a table was last accessed and by who, etc. Se...more >>

Is there some way of using the replace function in SQL That I can remove two characters. Example: I want to select the description of an Item from one table using the data of another. The one table has the item as ESS753-1/3 and the other has it as ESS75313 with the - and / removed. any ideas? ...more >>

Hi All, Trying to reset identity column, meaning starting with row 1 I want to redo the numbering. I tried this but doesn't DBCC CHECKIDENT (MyTable, RESEED, 1) there is 3 rows and under column id column it is. 1 2 5 I want them to be 1 2 3 thanks gv ...more >>

I have an SP that creates 3 table varialbes the first one gets filled from a big query that join 5 big tables and it will have up to 2000 rows . the second one is filled by joining the first one to huge tables. the third one is just some aggregation to the second one. all tables in every sel...more >>

Hi I want to be able to dynamically select the fields from any table. I cannot get this to return all the fields This will be a part of a much larger query which inserts data into certain tables, but I don't know the syntax to return all the fields. I have this below but does not do the job. ...more >>

Microsoft SQL Server 2000 Service Pack 4. I have been experiencing problems with osql when called from a trigger. The osql command is used with an input .sql file. I think I have narrowed it down to the point where when I declare a variable of type nvarchar. The only way to recover is to...more >>

Ok...stupid question... How can I query a table and produce output disclosing the column names and their attributes??? I need for documentation purposes. Thanks in advance!...more >>

Using VB6, SP5 & SQL Server 2000 In VB6 I am sending this line to SQL Server:: exec TXSET_METERDATA 'CS6',Null,Null,'TYPEA',0,'2007-05-01',@Errors3 output This is part of a process that runs every day and has been doing ok until today, and only for one Tag_Id which is the "CS6". The Null...more >>

Hi, I have a strings like ABCXY, ABCD, XYZAB, XZYA I want to remove last two chars.. I am trying something like .. SELECT REPLACE ('ABCXY', ' ', RIGHT ('ABCXY', 2)) but it is not working.. Also that one has a problem if string is like XYXY... Any hints? hj ...more >>

Hi, I have inherited a C# application developed in VS 2005 and SQL Server Express. Since we want to deliver the app with the full version of SQL Server, I am attempting to run it on my development machine which has VS 2005 and SQL Server 2005 but no Express edition. It will not compile, a...more >>

I know this is a very dumb question but I am unable to find the answer anywhere. And would really appreciate any help. I need to update some data with a "=C4=85" character in it. However, when I update the data it replaces the "=C4=85" with an "a". How do I update the value while maintaining t...more >>

Hi; i have this table; id account currentbalance 33 45802 542 34 78299 400 35 78299 330 36 45802 100 37 45802 221 i need to get the "last" currentbalance of each account, so for th...more >>

Can someone explain to me why you'd want to use a NonClustered Primary key on a table? Keep in mind the table doesn't have a Clustered index at all or any other NonClustered indexes. I am working with a new application that contains 4 tables non of which have a clustered index. I've never seen...more >>

Not that this is a great thing to be using, perhaps ever, but i'm wondering if any one here has attempted this. Storing a structure or a class in a type of variant? There are times that you just can't go back and do things right, at least not without a lot of money. Hence the use (not need) of...more >>

I need some query help I have the following table ENTITY ID ENC # DATE 1044 101 05/02/2007 1044 101 05/01/2007 1044 101 04/30/2007 1044 102...more >>

Need a query which returns a count of the total emails sent from the table EventLogMessageInfo and a count of Policy Failures from table EventLogPolicyFailures where the email is one of the following User1@USA.com User5@USA.com User19@USA.com User25@USA.com The results should look li...more >>

I created a user in 2005 and gave them datareader access only to a database. Using Management Studio, I am able to log in as the user but when I tried to expand the database folder, I get the following error message. I only want the user to be able to read all the tables in a specific database...more >>

I have two identical tables; TableA and TableB. Both contain over 100 columns, EmpID is PKEY in both tables. I want to check If the data in EmpSalary has changed in TableA then update each and every column in TableB from TableA. How do I write a query to do it? I don't want to type over a 100...more >>

When I try to run the following Update... UPDATE V SET V.PhoneNumber = i.PhoneNumber FROM Vendor V, [icon_user].TEST_RESULTS i WHERE V.VendorName = i.VendorName AND (V.PhoneNumber IS NULL OR V.PhoneNumber = '') AND V.Province_State = 'MB' .... I get this error: Server: Msg 512, Level 1...more >>

I am attempting to export a binary file from my SQL Server 2005 database to a .jpg file. Below are the import and export routines I am using. All is well, except that there appears to be four bytes added to the exported file causing the OS to not recognize the file format. Looking at the file...more >>

Hi, I have used a query where I access tables from 2 databases, now these databases are going to reside on different servers and machines but on the same lan. What is the syntax to access the "external" database on a different server and machine? previously I wrote "Select invno from Invoice...more >>

Dear friends: I have boiled down my problem to a somewhat minimal repro: ALTER FUNCTION XX() RETURNS @A Table (TType varchar(2), Store varchar(15), Grade varchar(4), TDate datetime, Quantity decimal (11,2)) BEGIN UPDATE @A SET Quantity =3D Quantity + (SELECT A.Quantity - A1.Quantity ...more >>

Hi everyone. I've a technical query regards to MS SQL 2000. This is a one off unique = case . We have a case here, which the INSERT command is not fully committed. = Its a simple command "INSERT INTO TABLE(BLAH) VALUES('data')" It is not held by any Transactions. It seems that this in...more >>

The following query that works perfectly fine under SQL Server 8.0 but times out under SQL Server 9.0: SELECT * FROM AP3ProductGroupCompatibility WITH(NOLOCK) WHERE ProductGroupAboveID IN (SELECT ID FROM AP3ProductGroup WITH(NOLOCK) WHERE ID IN (SELECT ProductGroupID FROM AP3ProductGroupPr...more >>

How can I permit only specific values values in a varchar(25) column without the use of lookup table? In column1 i only want to allow values NULL, '', 'Current', or 'Not Current' ...more >>

Hi, Is there any way to execute a sql script from inside of another sql script? I have a set of many small script files, which i need to execute in specific sequence. Thanks...more >>

The query result return 0. But the variable @query0 is the query formula (select count...), not the query result. How can i execute the query and assign the result to @query0? then i can activate "IF" condition loop. Thanks a lot. ************************ declare @query0 varchar(10...more >>

I'm trying to get a 6.5 database to work properly in sql 2000. There's an SP which concatenates (sometimes) null values with another string. As SQL 2000 handles this proc differently I've added SET CONCAT_NULL_YIELDS_NULL OFF to the sp and it works correctly. An article on MSDN notes that t...more >>