Hello, I'm trying to write a script to update a series of tables. Is there any way to determine if a field exists in a particular table? Any direction would be appreicated. Thanks! Rick ...more >>

Hi, I have an issue. I am using .net application to connect to the SQL server 2000 through SQLhelper class to update one of my table. I am using a stored procedure to update the table with the output parameter returning back to me a value back. But i am finding that its returning to me only 1...more >>

Hi all; I have a table contains some initial data and I want to take these data into a file like a script to copy these data into the same table but in another database, I don’t want to use copy data base from server to another, I want the file to be like a script so when ever we run it on ...more >>

Take a case a where user does not have insert access to a table T1, but user has stored procedure execute access. Can inserts be done to table T1 using the stored procedure? Can user be the owner of table T1 and still insert access can be denied to the user? ...more >>

Are they available? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.2 ^ ^ 20:43:01 up 18 days 23:55 0 users load average: 1.00 1.00 1.00 news://news.3home.net ...more >>

greetings... I have a stored procedure that results with a column of time only, my problem is that when i order by this column the results are: 10:00 AM 11:00 AM 12:00 PM 1:00 PM 2:00 PM 3:00 PM 4:00 PM 5:00 PM 6:00 PM 7:00 PM 8:00 PM 9:00 PM 8:00 AM 9:00 AM I need it to be sorte...more >>

i have a stored procedure which selects a record from a table based on id . i have to check if the record exixsts in the table before selecting the record: this is my code: reate procedure seltimesheet @timesheetid uniqueidentifier as if exists ( select * from Timesheet where TimesheetId =...more >>

Is there a way for a non-sa user to run TRUNCATE TABLE? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.2 ^ ^ 20:10:01 up 18 days 23:22 0 users load average: 1....more >>

I've isntalled the SOAP Toolkit on a SQL Server 2000 box (see: http://tinyurl.com/aw2o) and am trying to invoke a web service from a stored procedure. I have been successful in retrieving simple datatype values (from calls to GetInteger and GetString) but when the returned value is not simp...more >>

In MYSQL SQL, I know there is a LIMIT can be use to do so, is it any syntax in MS SQL? I would like to select the rows rom 10-20 out of 100 rows record. This table has a primary identity key named rowID with some missing key, let say, 12 and 16 row is delete. Thanks! ...more >>

I'd like to keep track of the space being used in MSSQL 2005 for each user. freshbooks.com does this for the invoicing service and displays it to users. The first thing is to figure out what exactly I want to track. Once I know that, what is the best way to calculate an "x MB of x MB used...more >>

I am importing about 60,000 records from a text file. As each record is read, it is inserted into a table "TImport" via a recordset. In MS Access this is completed in about 15 seconds. We changed the database to SQL 2005 with identical tables and now this read/insert process (60,000x) is t...more >>

I'm confused on the range definition in a partition function. Lets say I want to create monthly partition starting from Jan 2007, how many values should I put in the range? 12 months per year and for 2 years that will be 24 values? What happens when the third year starts? Do I need to manu...more >>

Hi all, Can anyone tell me what the difference is between adding a unique constraint to a column, and adding a new index that is marked as unique? As I understand it, adding a unique constraint has the effect of adding a unique index anyway to enforce the constraint. If this is the case, ...more >>

I'm passing a comma separated string into a stored procedure as the @Zips varchar(255) variable. It holds a string of zip codes like this: 90201,90333,90455 that I need to use in a query like this: .....AND c.zip IN ('90201','90333','90455') What is the best way to convert my CSV strin...more >>

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx...more >>

Hello, I'm new to SQL Derver stored procs. I came across this syntax and can't find it in the online reference. I assume it is a call to a user defined function and was hoping someone could point me to the docs... {fn GET_TIME}...more >>

I have a table that has the following characteristics. ItemName key value item1 100 0.4 item1 200 0.5 item1 300 0.7 item2 300 0.6 item3 500 1.9 item2 100 1.1 item3 100 2.2 and i need an output table such as the following: k...more >>

Hi I am looking at the MS script sp_help_revlogin but I'd like to know to encounter less problems, when mvoing a database onto a new server to ensure the logins work correctly. Should you add the logins first then move the database on the new server or is it better to move the database fir...more >>

I have two tables reps tid smallint(3) auto_increment initials char(4) ( Rep Initials) areacode int(3) (Area Codes for all the States) state char(2) (State Area Code Resi...more >>

Hi What would be the difference between using in and using exists with a subquery. Thanks, Carly ...more >>

Hello there I have database maintenance plan who backup the file i'm working with and it brings me an error: Backup can not be performed on database 'my database' and don't show error and reason for that. what can cause the log file not to be backing up? ...more >>

Hi. I need to copy an existing table from a SQL 2000 server to an existing database on a SQL 2005 server so another application can access it. I suppose there are a number of methods to accomplish this. I created a linked server on the SQL 2005 box, but not sure where to go from there. Any...more >>

Hi -- I'm confused about BCP's FORMAT argument, which I'd like to use to create a format file for future BCP runs. I see that the syntax is: FORMAT [datafile] and that it needs to be used with -f: -f [format_file] Yet here I'm only executing BCP to *create* a format file to use in the...more >>

Hi All, What is the difference between SQLSEVER 2005 and SQLSERVER 2000. Thanks Chellam ...more >>

Hi I am using sqldbc.jar to access SQL Server my code was working fine till the db server name was one singlr hostname now the DBA has changed it to HOSTNAME\XXXX format and my java code is failing. The following URL is what is getting generated. jdbc:sqlserver://HOSTNAME\XXXX:1433;database...more >>

I am receiving the following error; Error Source= Microsoft VBScript runtime error Error Description: Object variable not set: 'CreateObject' when the following active x script job step executes; sub main() set Messanger = CreateObject("eFAACTMessanger.clseFAACTMessanger") Messang...more >>

hi i have 3 listboxs used like search criteria. the default option is all records. it works on nvarchar fields with % , but doen'st with INT fields. How can i do that for INT fields?? thanks in advance ...more >>

Hi, I was asked at a job interview to create a trigger that will block the bulk insert in a table. I HAVE NO IDEA OF HOW TO BLOCK BULK INSERT!! Any ideas? Thanks, Carly ...more >>

I have 2 SQL Servers running the same query from a linked server. With the linked servers set up the same as far as I can tell. Both use OLEDB for SQL Server. On one server I am running SP3 and the other I am running SP4 The issue is that on the server with SP3 I run the query below and ...more >>

custid, date_logged_in 123, 1/1/2007 234, 1/1/2007 123, 1/1/2007 123, 1/1/2007 567, 1/1/2007 567, 1/2/2007 789, 1/2/2007 I only need to know that a custid logged in once per day. How would I get this count by time frame? E.g. the query for timeframe 2/2/2006 to 3/3/2008 would produce...more >>

script ========= create table t1(id int identity(1,1),[1] int ,[2] int) go insert into t1([1],[2]) values(1,1) go insert into t1([1],[2]) values(1,2) go insert into t1([1],[2]) values(2,3) go select [1],[2] from t1 where "1" =1 --returns 2 rows is it possible to write a similar se...more >>

I have written a user defined function (UDF) that makes a random whole number with 1-15 digits. The intended use of this function is to provide a randomized field in a table with more than ten million records: I will need to use SELECT commands based on a number of WHERE clauses and then pick ...more >>

I have a highly volatile table that gets data inserted into it constantly. it currently does not have a clustered index on it because of this. a colleague suggested adding a clustered index on the primary key to improve performance. i'm not sure how this would help.....anybody have an opi...more >>

I have a table that lists data in unique 'bins' for my customers. There are multiple customers and each one has bins numbered 1-254 They MUST be numbered such. The bin number itself has no meaning - other than being unique for the customer. I can add a record for a customer by setting th...more >>

Hi, What is most efficient: SELECT * FROM Company a INNER JOIN Store s ON a.companyID = s.companyID INNER JOIN Department d ON s.storeID = d.storeID WHERE d.type = 'A' or this one: SELECT * FROM Company a INNER JOIN Store s ON a.companyID = s.co...more >>

I want to combine three name fields in a select statement. name1 name2 name3 name1 name2 name3 --------- ---------- ---------- some owner name owner NULL NULL If I do SELECT (name1 + ' ' + name2 + ' ' + name3) as name, I will get NULL for the value of na...more >>

I'm trying to write a program in C# that utilizes the SMO to do some automated index rebuilds. One thing that I'd like to be able to do is order the tables within a given database by size so that I can do smaller tables first (presumably freeing up space in the database to do rebuilds for l...more >>

Good morning everyone. I inherited this stored procedure and have been tasked with tweaking it. Its purpose is basically to go back to the beginning of time and recalculate the balance (Credit - Debit) per day for a business. There are essentially 740,000 records in this table, 200,000 a...more >>

Hi, I have a string field, "Description", in a database table, "Account", (in SQL Server 2000) that contains an invisible trailing newline character. I was thinking of running an update statement like the follows to trim off the trailing newline character: Update Account Set [Descriptio...more >>

I have a simple table that contains phone numbers for contacts. There is a column in the table that contains a fully-formatted text version of the complete phone number (i.e. "(423) 555-1212 Ext. 123" ). Since a contact can have more than one phone number, there can be several records for ...more >>

Im trying to write a procedure to return a list of tables in my db where the PK is not an identity column but am getting a bit lost. all help appreciated...more >>

Me running SQL 2000. Want to know if the DST will affect SQL Servers or not? Thank you...more >>

Hi all, I have the following problem: I am distributing data from DB to clients using my server. To have all up-to-date, all my tables include RecTimeStamp (timestamp) column. Using some time intervals clients are asking for new data based on last remembered timestamp. .NET server selects d...more >>

I would like to find out via ADO or ADOX (or any other means) whether a certain column of a table contains a formula, and if yes, the text of the formula. I didn't find such a property or field in INFORMATION_SCHEMA.COLUMNS. Any help is appreciated. TIA, Norbert Meiss...more >>

PROCEDURE [dbo].[pcins_ExportUser] AS BEGIN SELECT * FROM TBL_User END ------------------------ PROCEDURE CalingSP AS BEGIN DECLARE @SQL VARCHAR(2000) DECLARE @DataBase VARCHAR(100) DECLARE @Server SQL_VARIANT DECLARE @Path VARCHAR(200) DECLARE @ExportResult INT...more >>

Hi, I need to select part of a field to compare it to another contained in another table. The field is a name John Smith The problem is there is a prefix at the start that varies between two letters and 5. i.e ABLS - JOHN SMITH AS - JOHN SMITH If the prefix was the same I would ...more >>

Hi, I am using cascade delete foreign key with SQL 2005 Express Edition. The delete works fine and delete all related rows. However I need the list of all affected rows from all cascade delete action to apply this changes in my application. I know that it can be done with triggers or not...more >>

Hi, I have a database with table name as test in that i have 6 colums they are name varchar (20) address varchar (20) position varchar (20) nametype1 varchar (20) nametype2 varchar (20) nameval varchar(20) now in the nametype1 and nametype2 there are values like nametype1 ...more >>