Hi, Now I started learning SQL Server 2000. Perhaps, I want to update myself simultaneously with SQL Server 2005 also. I want to know the exact difference between SQL Server 2000 and SQL Server 2005 with respect to programming and concepts....It will be helpful to me. I need to use SQL as the...more >>

I'm chewing on a DNS blacklisting system that needs to store a list of blacklisted hosts. I am having difficulty in deciding whether to use VARCHAR or NVARCHAR for the hostname column. Can anyone think of a reason why I might need to store a hostname containing, say, Chinese characters? I...more >>

hi thankx in advance i have been using sql server 2000 i had written one stored procedure that will written me a set or records now i want to take a print out of these records when i run the stored procedure so any idea about this ? how to achieve ? waiting for reply ana ...more >>

I have 3 tables in a database, Table 1 4 fields ID = incremental datetime = datetime from = numeric pin = numeric Table 2 7 fields ID = incremental address1 = text address2 = text town = text county = text postcode = text pin = numeric Table 3 many fields s...more >>

Iam trying to write to a DateTime field in MSSQL from wonderware intouch. The problem is that I keep getting the error that the string I'm using is not a valid datetime string.....has anybody experienced this and what was the workaround? Thanks Gary ...more >>

I have a view that returns data as follows: Ticker | MetricId | MetricName | NumValue ABT 1 Sales 100000 ABT 2 Receivables 3000 ABT 3 COGS 5000 ABT 4 ...more >>

I've got a VB app that calls an SQL stored procedure that calls another SQL stored procedure that updates multiple tables. I want deadlock detection and recovery. Where can it be done? The inherited code attempts to check for error 1205 inside the inner sql stored procedure - an error code...more >>

I'm trying to find all occurances of bad data in a varchar column. The bad characters include: /";:<>|[],.'?~`!$%^&*()-+={}\ I need a quick and dirty way to do this. I tried: --Doesn't work... WHERE MyColumn LIKE '%[/";:<>|[],.''?~`!$%^&*()-+={}\]%' --Works, but t...more >>

I could get Query Notification working for a windows forms client using the SQL Dependency object but the same code doesn't work from a simple windows service. The OnChange event doesn't seem to be raised up to the windows service. Looking at the SQL trace, it doesn't look like the a notificatio...more >>

Hello, I am trying to run a SQL statement that uses a variable in the LIKE statement. I am simply trying to list all the items starting with a given letter, so if the user passes in A, it will list all the start with A; however, when I run the query and pass it A, it returns no values. If ...more >>

Hi. I have been attempting to solve this problem for some time (I want to place the code in a SQL Server Stored Procedure). I have created the following tables and test data. CREATE TABLE Binder ( Binder_id INT PRIMAY KEY, Binder_txt VARCHAR(60) ) CREATE TABL...more >>

We own several test centres worldwide and are able to offer you this fantastic service. If you would like a 100% guaranteed pass, then please read on further...... We are able to offer a guaranteed pass for the following: Microsoft, Cisco, Comptia, Oracle, Solaris. Please send a request for...more >>

I am in the process of rebuilding an Access database using SQLServer as the backend. The cliff notes version of the schema is... tblTransferHeader (parent/one) transferDate smallDateTime tblTransferDetails (child/many) transferTime smallDateTime The form in the Ac...more >>

I have a companies table with 18000 unique listings - unique as in Clorox, Clorox Inc, Clorox Inc., Clorox Incorporated... This example lists the same company, Clorox, uniquely, 4 different ways. I wasnt to query the table to return the count of similar sounding names. Something like ...more >>

Hello, Is it possible to declare a variable and use it with the "top" keyword? declare @x int set @x=1 select top @x userName from users I keep getting a syntax error and cannot figure out why. Thanks...more >>

Hi, Using SQL Server 2000, I write a query and it displays the results in a grid. Is it then possible to reference those results in another query? Or do I have to do something else? Thanks in advance, Linn ...more >>

Sorry, I'm not sure where to post this question. This query has a problem: SELECT CAST(SpecValue AS Numeric) AS Expr1 FROM dbo.tblSpecification WHERE (IsNumeric(SpecValue) = 1) AND (SpecValue Like N'%,%') (btw SpecValue nvarchar(50)) How do I explicitly Cast a string lik...more >>

I have question to pose to you all that is more architecture & design related. In my new position at a small business, I have inherited a database that has historical transactional data for the past 6 years. Unfortunately, the design has much to be desired; all of the data was stored in 1 tab...more >>

is it possible to use a linked server to oracle to pass DDL to Oracle? ...more >>

When i want to catch pictures on trace it always crop my files to 8kb when i insert this data to other tables and i cant preview this pictures. is that mean maximum size of data in trace 8kb ? thanks...more >>

I am having a table ObjectDetail which is having following columns ObjectTypeId, ObjectId,StatusId,StateId,Release, LastStatusUpdDt ObjectTypeId,ObjectId is Primary Key. This table contains about 1 million records in it. 1. When i removed the Primary Key and kept the Clustered Index on ...more >>

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 ...more >>

Is there a way to query and identify which file extensions have a Full Text Search filter installed for SQL2005? Thanks Tom...more >>

-- Original Message -- I'm not a math genius but I like a challenge and I was thinking over the weekend and am now stuck as to how to go. My youngest son, Silas is 3 My daughter, Millie is 5 My eldest son, Samuel is 7 These are all prime numbers My age is a prime number, as is that of...more >>

Hi there, I have been learning SQL programming and I have a question. I want to be able to insert information into a SQL table field using a system date. I want to run a query and if the matching criteria is met, (this is fine and I can do that) I want to be able to write to a date SQL fiel...more >>

hi, is there any method for incrementing the varchar field i have an emp table with columns create table emprecord(eno varchar(10), ename varchar(20)) i cant give eno column with identity field because identity column must be of data type int, bigint, smallint, tinyint, or decimal or nu...more >>

Hi everyone. I have have problem which is driving me up the wall at the moment. I'm fairly new to SQL and ADO, so I hope that it's something simple that others can spot easily. I am executing a stored procedure from ASP.Net which adds students to a database. The name "temp" in front of the pro...more >>

If I insert something into my table it works: INSERT INTO Advertisments (adv_name,adv_description,adv_duration,adv_type,adv_active,adv_name_org) VALUES ('test','description',550,9,1,'test') If I do the same, just with stored procedure: CREATE PROCEDURE [dbo].c_advertisment @name nVarc...more >>

Hi, I have a sql statement that perform bulk insert into another table. How can I ensure that if an error occurs, maybe due to primary key constraint, the rest of the records will be inserted. Thanks alot. ...more >>