T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Getting Data from Oracle to Sql Server using Procedure

  Hello Folks, Am a beginner in Tsql and I have a requirement to write a stored procedure and am all …

  hnaveen84

  28 replies

  14 years, 10 months ago

  By: Garadin

• Insert itemno,itemcode,itemyeartranscation .

  Insert itemno,itemcost,itemyeartranscation Three columns are there if we are insert data like …

  sivakrishna.vanama

  1 replies

  14 years, 10 months ago

  By: LutzM

• UPDATE based on Ranking

  Hi. I would like to update a value based its ranking. My query to return the ranking is as follows:…

  2Tall

  2 replies

  14 years, 10 months ago

  By: 2Tall

• Issues with Update DateTime column with GETDATE() using insert and delete triggers

  [font="Tahoma"] Hi All, I have some issues while updating the DateTime column with GetDate() using …

  aksheela

  3 replies

  14 years, 10 months ago

  By: Evil Kraig F

• Select rows from a table whcih was a result of join statement

  hI, I want to do a modification in the table whcih was a result of hte join query.... ..i want onl…

  Skybvi

  3 replies

  14 years, 10 months ago

  By: Skybvi

• Identify rows containing non-English characters within a unicode nvarchar.

  Hi All, I am trying to create query which will return all data from a table where the entry in a sp…

  DBANewbie

  2 replies

  14 years, 10 months ago

  By: DBANewbie

• Incrementing an indentity column (not set in SQL as being identity)

  Hi, I have a table as part of a bespoke application. The identity column is propulated by the softw…

  gareth.ensor

  2 replies

  14 years, 10 months ago

  By: gareth.ensor

• INSERT FAILS WHEN YOU TRY TO INSERT DATA INTO MULTIPLE TABLE USING IDENTITY

  I am newbie to sql programming please help me solving this problem of mine This is code 1.Created t…

  Smash125

  8 replies

  14 years, 10 months ago

  By: Smash125

• Help Converting Oracle Script with Rollup and Pivot to T-SQL

  I hope this is right forum. I am having a hard time understading new syntax T-SQL 2K5+ Pivots. In O…

  TheHTMLDJ

  1 replies

  14 years, 10 months ago

  By: TheHTMLDJ

• Testing T-SQL Code

  Guys, I'm providing a new recruit with some T-Sql training in the near future. I seem to recall the…

  Lozt-887152

  1 replies

  14 years, 10 months ago

  By: Mr. Holio

• Add Column

  Hi T-Sql Gurus, Here is my table "State" ID,TYPE,STATE 1,B,CA 2,C,GA 3,D,NY Here what i want (Same…

  rocky_498

  6 replies

  14 years, 10 months ago

  By: dogramone

• I just don't see it. Do you?

  So I'm getting this error: Column 'maintable.memberid' is invalid in the select list because it is …

  Luke79

  3 replies

  14 years, 10 months ago

  By: Mike01

• Database suspect mode

  I am getting error sql server 2000 enterprise editon.. production database.. I could not do any ac…

  solomon.jernas

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• Very slow data insertion to sql server 2005

  Hi, we insertion data it taken time too long .. pls help me.. how to find out performance problem

  solomon.jernas

  6 replies

  14 years, 10 months ago

  By: Grant Fritchey

• Insuffcient system memory to run this query - sql server 2005 erro

  Hi , Please help me.. I am strugling with one memory page out error -in sql server 2005 64 bit mach…

  solomon.jernas

  9 replies

  14 years, 10 months ago

  By: solomon.jernas