T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• openrowset with readonly

  Hi, i want to use openrowset to connect with readonly access to a mdb database. i have created a v…

  Sergio Campos

  1 replies

  18 years ago

  By: Grant Fritchey

• Passing Porcedure Parameters using N'

  The need is to formulate the needed file paths and database name based on an input by my new DBA. …

  David Paskiet

  6 replies

  18 years ago

  By: Gail Shaw

• Identify if a string contains Chinese characters

  Hi I am looking for a method to identify if a string contains Chinese characters. Cheers

  nbryson

  1 replies

  18 years ago

  By: nbryson

• how to exclude accounts on TSQL where clause

  Hello comunity i have the following TSQL: SELECT conta, docnome,u_subconta, data, mlstamp, dinome, …

  luissantos

  1 replies

  18 years ago

  By: jezemine

• Tree Structures + SQL

  Hi there, I am working with an accounting system, where the chart of accounts tree structure is bui…

  colaforever

  3 replies

  18 years ago

  By: Adam Haines

• large table to table copy

  I need to copy a large table, in the same database. The table is around 500+ million records, and …

  Ravi Patel-554358

  6 replies

  18 years ago

  By: noeld

• Probably an easy one, need help with a Where clause

  Ok, I'm not sure how to include something in a where clause....probably easy to do and I'm not look…

  blast2hell

  2 replies

  18 years ago

  By: David Paskiet

• Passing Parameters in a DBCC SHOWCONTIG statement

  I am modifying the delivered BOL DBCC SHOWCONTIG script so it can work with all tables, not just th…

  jsheldon

  4 replies

  18 years ago

  By: jsheldon

• Real Identity Value

  hi how can i get the real identity value of a table, not the max id but the real identity value aft…

  Charbel-371270

  2 replies

  18 years ago

  By: Charbel-371270

• complex programing HELP-Stored Procedure insert value after value like this into #temp_table

  need help urgent i need to create complex programing Stored Procedure for employees ID (for test t…

  midan1

  20 replies

  18 years ago

  By: midan1

• select @@DOMAIN_NAME

  I've been searching and experimenting for 3.5 hours to find a way to query my domain name programma…

  James Wing-285826

  3 replies

  18 years ago

  By: Jeff Moden

• Creating reports with Tsql

  Hi, Can anyone help me, how can I generate reports on an sql server 2000 standard server using t-sq…

  fosco

  6 replies

  18 years ago

  By: Jeff Moden

• query help to concatonate fields

  Thanks all but I solved this myself .......... Jeff I have the following table data that I need to …

  Jeff-132889

  2 replies

  18 years ago

  By: Jeff-132889

• How to get the last inserted row number with in a trigger

  Hi Guys, I got a problem with my insert trigger today.I have an insert trigger on a table which ins…

  kswathis

  2 replies

  18 years ago

  By: Jeff Moden

• SQL Select Statement

  Thanks for looking at this! I have two views: one view lists all the games that person x played: da…

  Ryan Moore-334418

  7 replies

  18 years ago

  By: Adam Haines