Hi All, I have a table that uses a text column to store lengthy (you guessed it) text data. I need to write a store procedure that checks the table prior to an insert/update to make sure the data isn't being duplicated. How can this be done with a stored proc? Thanks, Steve...more >>

Hi, Is it possible to define an outputfile to log all commands to, from = within an osql session. Orcale has this fuction? thanks...more >>

I have identical databases (SQL 2005) at 5 seperate sites, One table size in the database seems to vary greatly between sites. I have a program that collects data from process control systems and stuff the data into this table. Every 15 mins about 800 records are recorded. The size of the t...more >>

hi, i have a table like orderid int trackid int trackevent varchar(50) values will be like orderid trackid trackevent 1 1 'sample' 1 2 'process' 1 ...more >>

I have table Test1 with columns UserID FirstName LastName Address ..... ..... ..... UserType (only possible value is 1, 2, 3) I have table Test2 with columns UserID QuestionID But only the UserID with UserType either 1 or 2 can be stored in the second table. Would it still b...more >>

Hello, I have a table where the primary key is FAQId which is a GUID. My Procedure has a parameter named @FAQId. I want to check if the is a record in the table where FAQId = @FAQId Here is the important part of my code: -- Find record with given FAQId SELECT FAQId FROM dbo.by27_FAQ WH...more >>

I have been thinking about a way to recycle database every day at a certain time. Can I setup a trigger that's based on a time? thanks, ...more >>

Hi, I have a basic report using reporting services using MSSQL 2000 The report is built by making a call to a stored procedure which takes two arguments, a date and a string (These are declared as being of types DateTime and nvarchar(20)). In the report I have created two report parameters w...more >>

I am working importing an ascii file over 2 gigs in size with DTS. Everything works great until we hit the last record. Of course the last record, column1 say END OF FILE instead of the expects numeric id value. How can I get this skipped/edited or ??? to make it work Thanks, Craig ...more >>

We're having a performance problem with one particular stored procedure, GetRooms. This procedure is called often within our application (several times a second) and we're seeing very inconsistent performance in MSSQL 2005. Most of the time GetRooms runs in about 35ms which is good. It qu...more >>

hi, here is my SQL statement, for some reason, it keeps giving me "Error converting data type varchar to float" error. Anybody news how to resolve it? declare @date as datetime SET @date = (SELECT max( create_Date ) FROM ba..RptAuto_Deficiency) I...more >>

X-No-Archive: Yes Does anyone caution developers about the usage of output parameters as input/output? I know, output parms in SQL Server ARE input/output, but I've always been wary of using them that way. I think it makes cleaner, more understandable code to use output parms only for output...more >>

I have a tabled named bvc_Product and it has a parent-child relationship. I need to update the LongDescription column on all the Child records with the LongDescription of the Parent record. So I tried the following: NOTE: LongDescription is of the type nvarchar(max) ========================...more >>

Just curious, I'm looking to CONCAT(AREACODE,'-',PHONE_NUM) is this possible using pl/sql. I know I can CONCAT(AREACODE,PHONE_NUM) but I need more than two columns/values concatenated. Thanks! ...more >>

SQL Server has no aggregate PRODUCT() function. I don't have SQL Server 2005, so I can't create a custom aggregate function (as described in http://www.novicksoftware.com/Articles/sql-2005-product-user-defined-aggregate.htm), I'm stuck with the POWER/SUM/LOG10 workaround (http://support.microsof...more >>

is there any point to issuing a tablock hint on an update statement? update mytable with (tablock) set mycolumn = 1 where myothercolumn = 'x' myothercolumn is indexed and i think this hint will cause too high a level of lock. ...more >>

Hi, Why is inserting data into a table in database B, from database A, slower than inserting the same data into a table in database A (from database A)? The databases is on the same server. P=E5l ...more >>

We want to create a table that we don't want users to modify, so we were going to add an encrypted delete trigger to stop deletes from the table and an encrypted insert/update trigger that validates a checksum on the table. My question is how do I stop users from doing an ALTER TABLE x DISABLE...more >>

Hi, I got a problem with dynaic sql My Application make use of 2 different databases , out of which one will be a newly created one and the other will be an existing one .Depending on the customers, the second db can have different names.And i wanna fetch some data from these database ,...more >>

Say we have a database which tracks customer orders with tables like this: Product - list of products available ID Name ProductItem - 1 record for each item that comes off the production line ID ProductID Customer ID Name CustomerRequest - order placed by customer ID ...more >>

Hi all, I have a table I want to update with data from another table... simple in theory but not quite sure how to implement it due to the design of one of the tables. Note that if a CustID does not exist in the dest table then we will need to insert, not update. The table being updated ...more >>

I changed port on sql2005 to 1400. From local computer I can connect to server (IP,1400) with sql login(sqldev) and everything works. If I try to connect to the same sql server from other computer, I get an error. Login failed for user sqlDev. What could be wrong? There is no firewall and...more >>

Hi, I have a table called Photos, where user will have 1 to 10 photos and only one photo will set to be active at any given point of time.(i.e IsPermitted ='True' and remaining all photos set to false), user will have an option to make another photo as active. when this happens newly select...more >>

Hi All, If I use Selects in my query (ADO..NET) do I Have to use no lock in the selects or SQL by defaults provides me a no lock? TIA ...more >>

My question is basically about whether its best to do a small number database accesses and do most of the data organisation in sql stored procedures, or one larger fetch from the database and do the database organisation in the asp.net code: I am building a menu system for an online store. ...more >>