T-SQL

• Topics

  Started by

  Posts

  Last post

• Try to find correct Syntaxt of query

  Hi, I write an sp as below. It can be parsed in SQL 2005. But I need it in 2000. Can you help me to…

  aysegul

  2 replies

  15 years, 10 months ago

  By: aysegul

• sql 2000 FOR XML

  Hi All; How can I add a root element in sql 2000 like a query as below. Kind Regards Ayşegül. selec…

  aysegul

  2 replies

  15 years, 10 months ago

  By: aysegul

• Update Trigger to change fields in four tables

  I am new to writing SQL Triggers and would greatly appreciate any assistance with setting this up i…

  SArcher 38334

  3 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• select query for only changed rows

  hi, forexample i have a stock table on mobile device sqlce which got from an sql 2000 database by a…

  yaman bas

  8 replies

  15 years, 10 months ago

  By: Jeff Moden

• New Guid

  Hi All, Can you please Help. In my table, i have a unique identifier column as a primary key. My in…

  mmoziano

  2 replies

  15 years, 10 months ago

  By: michael.french 172

• convert string to datatime

  How can I conver the following string to datatime data. January 8, 2010, 12:57:45 pm Thanks.

  sql_novice_2007

  3 replies

  15 years, 10 months ago

  By: sql_novice_2007

• Outer Join question

  I need to write a query that gets the sales of the last 6 months of all our members. If the member…

  john.clyma 97764

  7 replies

  15 years, 10 months ago

  By: gints.plivna

• Overflow Error 517

  Hi Gurus, I'm trying to execute the following sql-statement which should show the date entry of the…

  mtraore08

  7 replies

  15 years, 10 months ago

  By: Chad Crawford

• Script out database schema

  Hi all, I'm trying to write a script to script out the schemas for all the non system databases on …

  ranvir_2k

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• BEGIN-END Structure

  I have an IF statement with "BEGIN" structures such as below. I need help on the FIRST "BEGIN/END" …

  rew-370421

  4 replies

  15 years, 10 months ago

  By: Simon Liddle

• Import all csv files in a directory without hard coding the file name

  I have a situation similar to the example Link listed below in which I need to import all csv files…

  Welsh Corgi

  9 replies

  15 years, 10 months ago

  By: Welsh Corgi

• PARSE FULL NAME INTO LASTNAME,FIRSTNAME, MI

  I have name data to import into a table. This data is in the following format: DOE/JOHN F JONES/MA…

  Nilssond

  6 replies

  15 years, 10 months ago

  By: LutzM

• Grouping in stored procedure and using a case statement

  I have a stored procedure that works at the moment. It takes data from a table and formats it and p…

  Spikemarks

  10 replies

  15 years, 10 months ago

  By: spaghettidba

• Using variables to determine table identifier in the FROM clause in a stored procedure

  Using SQL Server 2000, (8.0.760)--not upgradable... Trying to compile a stored procedure that uses …

  SQL_Hacker

  3 replies

  15 years, 10 months ago

  By: GSquared

• SQl data comaprison

  I have 3 tables •Ter_Ter_Alignment: Has 4 columns Source SegmentSource TerritoryTarget SegmentT…

  keethukumar

  6 replies

  15 years, 10 months ago

  By: arun.sas