T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Hot to update line X in a table with the value from line X+1?

  Hi I have folowing table Name Code Last_code MC1 100 MC2 200 MC3 250 MC4 300 MC5 320 MC6 …

  Vitali-403488

  9 replies

  18 years ago

  By: Vitali-403488

• Using SET ISOLATION LEVEL

  Hi All, a quick question here. What are the pros and cons of: USING SET TRANSACTION ISOLATION LEVEL…

  Christopher Stobbs

  6 replies

  18 years ago

  By: Vladan

• Help doing one procedure

  Hi i need to present in one gridview some information of one table but i need to filter it before a…

  nandoliveira

  1 replies

  18 years ago

  By: Vladan

• Help with SQL Query

  Hi all!, First post, so I hope I posted it in the right section... The query below is working fine,…

  F.L

  13 replies

  18 years ago

  By: RBarryYoung

• importing csv with different data type within the same column...HELP!!!!!!!!

  I have a file that has Integer and string within the same column. Depending which data type is fir…

  davidtlu

  7 replies

  18 years ago

  By: davidtlu

• Non-Sequential Insertion of Data from Temp Table or Arraylist Structure From Within Nested Loop - Inserting Values into Related Tables with Identity Key, CLR or CTE Needed

  help please. I am Using sql server 2005 I have the following situation: I want to populate two rela…

  Tech_Newbie

  22 replies

  18 years ago

  By: Jeff Moden

• count by another count

  Hi All, I used count to contactid,contact address and i want to total of contact for each contact. …

  ramaanujamr

  9 replies

  18 years ago

  By: Jeff Moden

• converting dbf date field to sql date field

  When I import a dbf file the date field comes in coded...how do I convert DBF date field to sql dat…

  davidtlu

  4 replies

  18 years ago

  By: davidtlu

• Comparing Image Field

  Does anyone know how to compare two image fields to find out if they are the same or not?

  drodriguez-762178

  14 replies

  18 years ago

  By: Matt Miller (4)

• query of updated data backup

  Hi... how i can take todays updated columns backup only? Thanx & Regards, Mohammed Iftequar Ah…

  MSQLDBA

  2 replies

  18 years ago

  By: Steve Jones - SSC Editor

• change owner or multiple jobs

  Hi, how can i change owner to differenet user for all 200 jobs running on SQL2005 ? thanks Pat

  pat-261672

  2 replies

  18 years ago

  By: Steve Jones - SSC Editor

• A use for ROWNUMBER() ?

  I am selecting every contact at a particular list of firms - i.e. 1 firm may have 20, one 10, one 5…

  Rob-350472

  6 replies

  18 years ago

  By: GSquared

• How to add IDENTITY constraint after creating a table?

  I had created table id as INT How to alter the table to add IDENTITY key

  sharma-691993

  1 replies

  18 years ago

  By: Andras Belokosztolszki

• PatIndex on varbinary Column

  Hi, I have a Table which holds varbinary column(word document). I need to search few keywords in th…

  umaramiya-724626

  4 replies

  18 years ago

  By: Peter E. Kierstead

• exporting sql query to xls file

  Hi Explaining the situation with the master database sysobjects. select id,name from master..sysobj…

  vsjayashri

  7 replies

  18 years ago

  By: GSquared