T-SQL

• Topics

  Started by

  Posts

  Last post

• problems with store procedure

  Hello, How can I pass or define a variable type table to a store procedure in SQL server? thanks

  oigo

  1 replies

  24 years ago

  By: Antares686

• WITH (NOLOCK) clause

  A long time ago, I read that so long as your code/application doesn't mind, you can use the WITH(NO…

  sjcsystems

  1 replies

  24 years ago

  By: Antares686

• SPOOLING

  I was wondering if any one could help me out. I'm trying to spool the results from a tsql script t…

  kirmssr

  10 replies

  24 years ago

  By: kirmssr

• Updating a Count of records to a table

  I have a table which holds information for each of our salespeople (called 'assoc'). Sales people …

  lkaplin

  1 replies

  24 years ago

  By: Andy Jones, DBA

• Problem with Instead of Trigger

  I have instead of delete trigger on my primary key table(master). when user delete record from mas…

  shrinivaskundarapu

  3 replies

  24 years ago

  By: Andy Warren

• Meaning of "Level, State, Line" in error code

  "myName" is a char(5). So the following generates an error under QA. insert mytable (myName) value…

  Barkingdog

  1 replies

  24 years ago

  By: Antares686

• count with text fields

  Hi everyone,i have another question currently in my database there are 2 tables which basically loo…

  swush

  1 replies

  24 years ago

  By: Klaas-Jan

• exec()

  i have to port a sql statement from mysql to mssql which goes like : select fieldname=1 from table…

  swush

  2 replies

  24 years ago

  By: swush

• store procedure and view with ENCRYPTION

  Hello, I made a store procedure and one view with ENCRYPTION , how can I their text using T-SQL? Th…

  oigo

  3 replies

  24 years ago

  By: Antares686

• Isolation level and user defined database function

  I have the following SQL statement which uses a regular database view (ACC_BCA_Balance_Calc_Vw) and…

  stefanherven

  1 replies

  24 years ago

  By: danw

• Sqlagent

  HI, is there a way to start sqlagent automatically on a pc with msde which have been installed on w…

  apinnelli

  1 replies

  24 years ago

  By: Antares686

• SQL 6.5 Delete Trigger

  I have two tables: tblData and tblChangeLog. Data is stored in tblData and changes to that data is …

  Paul Corbin

  2 replies

  24 years ago

  By: Antares686

• Just wrote the WORST TSQL ever! Help!

  Hey all- been asked to do something, and am having problems. First, my sql takes forever to execut…

  nitrox

  1 replies

  24 years ago

  By: danw

• Dynamically built cursors??

  Please help, I want to build the DECLARE CURSOR statement dynamically. Can anyone tell me how to do…

  sqldynamic

  2 replies

  24 years ago

  By: danw

• OSQL problem

  I'm trying to write an osql script using xp_cmdshell. The test script that i'm trying out is: e…

  kirmssr

  4 replies

  24 years ago

  By: lars