T-SQL

• Topics

  Started by

  Posts

  Last post

• OPENDATASOURCE syntax for Excel worksheet with space in name

  Hi guys, The following works OK (run from SQL server management studio express)... SELECT * FROM OP…

  prbennett

  2 replies

  16 years, 7 months ago

  By: prbennett

• can we send a message?

  If we need to know , which host (machines) are accessed our Database with the help of Sysprocesses …

  Saravanan_tvr

  1 replies

  16 years, 7 months ago

  By: arun.sas

• tsql can not find procedure xp_delete_file from procedure

  I built a simple procedure below to learn more tsql. The output of the print statement produces the…

  cchart3

  6 replies

  16 years, 7 months ago

  By: Lynn Pettis

• dropping and creating a dynamic table in a Stored Proc

  Hi All, I am new to this forum, and wanted to first say hello! My problem: I am trying to create a …

  sfisher-1058608

  6 replies

  16 years, 7 months ago

  By: GSquared

• Avoiding injection on stored procedure

  Hi, I've got an SP that looks like this: CREATE PROCEDURE USPDeleteAnswers @Id varchar(50), @Questi…

  el_wise

  14 replies

  16 years, 7 months ago

  By: Greg Snidow

• PATINDEX PROBLEM

  If I run select patindex('%[0-9]mm%', 'RockShox Tora SL Le Femme, 100mm-travel w/lockout'), patin…

  Kirk Dudley

  5 replies

  16 years, 7 months ago

  By: Kirk Dudley

• Join

  Hi I have two tables Table 1 Price[Char(11)] TYPE[Char(1)] 10.333 …

  Tsql-561486

  3 replies

  16 years, 7 months ago

  By: Vijaya Kadiyala

• Cannot resolve the collation conflict

  Having a collation problem with an sql query in my database when running the following query. I'm p…

  john.michasiuk-836345

  1 replies

  16 years, 7 months ago

  By: Sergiy

• How to get Stored Proc return rowset metadata?

  I'm looking for a simple way to query the metadata of a stored procedure's returned rowset and get …

  Tom Williamson-285801

  3 replies

  16 years, 7 months ago

  By: Sergiy

• Matching Date periods to specific date

  Hi all, I need some help. I have two tables. The first table (Account) holds account details and a …

  Grinja

  4 replies

  16 years, 7 months ago

  By: Grinja

• error of sintax

  Hi - I have a table. This table as two columns: (codctb INT NIFCTB varchar(20)) i want to create …

  pedro.ribeiro

  10 replies

  16 years, 7 months ago

  By: pedro.ribeiro

• inserting a list into a table that does not allow dupes

  I have a table where the schema is as follows id bigtin identity(1,1) sn varchar(50) create primary…

  xgcmcbain

  2 replies

  16 years, 7 months ago

  By: Steve Jones - SSC Editor

• Nested store_proc in a loop

  I've got a problem with a loop and a nested stored_proc. Main stored_proc:- ... INSERT #e…

  mcinwg

  2 replies

  16 years, 7 months ago

  By: mcinwg

• Select column in a specific order based on values.

  Hi, I can´t find any solution for my problem that works well and don´t need a cursor. My problem is…

  m.wardell

  13 replies

  16 years, 7 months ago

  By: LutzM

• t-sql not committed

  HI - Masters, I have the t-sql below in my query analiser: update bulk_provincia set VALIDO_BUL…

  pedro.ribeiro

  17 replies

  16 years, 7 months ago

  By: Sergiy