question 1 ---------------- i am passing an array from java using stored procedure to sqlserver. i want to read it from sqlserver. can any one send me code to read array values from sqlserver. also question 2 ------------------ I want to print one xml file on browser using DOM parse...more >>

Hi all, How do I pass in variable for an IN clause? For example: SELECT * FROM TABLE WHERE Column IN (1,2,3,4,5) How do I pass the 1,2,3,4,5 as a SQL Parameter? Can I go: SELECT * FROM TABLE WHERE Column IN (@MyParameter)? Thanks!...more >>

Hello, I have following table structure with data: ID Name Title DateTime 1 ABC Title1 3/4/2007 08:25:24PM 2 ABC Title1 3/4/2007 08:29:18PM 3 ABC Title1 ...more >>

Hello, I set up a linked server and am able to query the dbf named "File.dbf" correctly with something like: SELECT * FROM LL...File And dbf files with spaces such as "File With Spaces.dbf" with something like: SELECT * FROM LL...[File With Spaces] However I am not sure how to handl...more >>

using this query I only get dates from the 1st of April and from 10th April forward ... what am I doing wrong? SELECT TOP 100 PERCENT dbo.Stranke.Sifra, dbo.Stranke.Partner, SUBSTRING(dbo.Stranke.Opombe, 1, 255) AS Opombe, StrankeOpcije1.Vrednost FROM dbo.Stranke LEFT OUTER JOIN ...more >>

I am trying to capture some kind of unique identifier for a transaction from a trigger so that I can group a whole bunch of record changes with it. It can be anything really. I've searched here but found not much of anything. One post indicates sys.dm_tran_current_transaction but I couldn...more >>

I have a working CLR trigger, but it needs error handling. My plan is to add a routine to enter errors into a log table, so I added a sub with a SqlCommand to execute a SQL Insert into the table. It does not perform the insert. Instead, I get the error: The current transaction cannot be c...more >>

This select produces a nice clean, distinct list of emails. the View has many dups. select distinct email from access_vw However, Im' trying to get that list horizontally seperated by commas. This t-sql produces the list the way I want, but contains duplicates. declare @x varchar(1000) s...more >>

Looking for some links or possibly books that anyone can suggest as good material to learn how to build and make sure that "Referential Integrity" is in place... I have the following Books already: Microsoft Press - The Storage Engine Microsoft Press - Database Essentials Microsoft Press...more >>

Hello, I created some SQL 2005 tables using Microsoft SQL Server Management Studio. I know wanted to get the script code of those tables. I was able to do that by right clicking over each table. But how can I get the code for the relationships between the tables? Thanks, Miguel ...more >>

We have an issue where our asp.net app connects to sql 2000 in a DMZ through a pix router. There is no ACL(Access Control List) in place, so 1433 is allowed. It connects, but very slowly, 5 seconds to return page. When on the same side of the wall, it is 1.5 seconds. Is there a SQL setting...more >>

Hi all, Simple question: I want to insert a 1 or 2 randomly in a column? thanks gv ...more >>

Is there an easy way to get the total row length for a table? Right now I'm adding up the columns individually by byte for the given data type. But I thought maybe it was sitting out there somewhere. Also, how does it handle varchar's?...more >>

Hello, I have a stored procedure with an input parameter named DocId. I want to select all records if DocId is null or the record with the given DocId if it is not null. My code is pretty more complex then this. SELECT .... Some code ... FROM myTable t1 ... Inner Join...more >>

Hi, I have a rather simple query that includes a UDF. -- QUERY -- select personName from person, address, sectorK where PERSON_NUMBER=ADDRESS_NUMBER AND PERSON_AANVRAAG=ADDRESS_AANVRAAG AND ADDRESS.ADDRESS_TYPE = 'f' AND sectorK.sector = '31224' AND ADDRESS.ADDRESS_CODE = sectorK.code ...more >>

I have a database moved over from SS 2000 to 2005 that has an UPDATE trigger we've been using for auditing changes to tables. One of the fields ('SKU') also validates against another DB to make sure it's not being used in records there before allowing modifications. This was added when we wer...more >>

Hoping for some general guidance. Assuming I'm in a "one-guy-shop" and responsible for all C# ASP.NET programming and SQL2005 programming, and responsible for all change control to an important application, I am in need of a tool that will work something like this. 1. I make a copy of a S...more >>

Hello, I need to move tempDB (sql server 2000) because the default install was on the c drive on Win2003 server. The detach option in Enterprise Manager is grayed out. One of the database's (data DB) is in replication on this sql server and we are running IIS on the same server computer. ...more >>

Hello. I have a table with a datetime column. I need to select rows with a NULL or a datetime earlier than 2 hours ago if getdate() time is currently between 6am and 7pm. Thanks for any help or information! ...more >>

Hello, I have a simple procedure which for a given ID returns only one record. I have this made in two different ways: 1. Use Output parameters for each column in table. In my .NET code I execute a non query. 2. Use select without individual parameters In my .NET code I execute a dataset ...more >>

Hello SQL Gurus: I have a DTS package that has two tasks: ActiveX Script Task (A.X.T.) and Transform Data Task (T.D.T.). The A.X.T. just basically renames the file "NutriliteMESIndirectTransactions" to "NutriliteMESIndirectTransactions_dmyyyy" and is defined as follows: '******************...more >>

Hi can anyone help I have been testing a concept for an application using SQLDependancy to monitor changes to a simple SQL select query. I have the test application working but it only raised the "On Change" event for the first change to the table other changes are not raiseing an event. I hav...more >>

-- SQL2005 - Trying to use ORDER BY with CASE expression seems to be dropping rows. Why does it do this? Is there a known problem using ORDERBY with CASE? Thanks wBob USE tempdb GO DROP TABLE dbo.test GO CREATE TABLE dbo.test( test_id INT PRIMARY KEY, test_date DATETIME NOT NULL )...more >>

SQL Server 2005 with Access front-end. Have several UPDATE queries on the Access front-end (VBA/SQL) that works fine, but one particular query returns an error stating that the query is not updateable. The table concerned is very simple - only three fields: Yr, Mth, Wk and only one row of...more >>

Hi! We are designing a big database with multiple parts (like Human Resources, Sales, Production) etc. in Sql server 2005. Should we devide the main parts into separate databases, or should we put all tables in a single database and use schemas to group the parts (like the AdventureWorks sa...more >>

Hi everyone, Im puzzled by a NULL behaviour in SQL 2000 server. There is a column in the table that does not allow NULL. During data mining, the staff noted that, for that particular column, there are a few records that are empty. I do not specifically know whether they are "alt + 0160...more >>

Having struggled with Crystal Reports yet again. I've had a brief look round for another reporting package but wondered if the community have any recommendations. It needs to be useable within visual studio in the same way that Crystal Reports is but more user friendly and glossier looking. ...more >>