T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• View To Repeat New Rows Based On Date Range

  SQL 2005... Need SQL sample for a View that will retrieve a START_DATE field and an END_DATE field …

  mailbox-721349

  3 replies

  18 years ago

  By: mailbox-721349

• Default value based on case?

  Am I doing something wrong, or can you not case a default value? CREATE TABLE #OrphanedUsers ( [O…

  Adam Bean

  3 replies

  18 years ago

  By: Adam Bean

• which is more secure for file deletion, sp_OACreate or xp_cmdshell

  which do i enable that is the most secure for file deletion, sp_OACreate or xp_cmdshell? Both are d…

  winston Smith

  3 replies

  18 years ago

  By: Lynn Pettis

• Hey

  Hi all, Am trying to do a migration of some servers from 2000 to 2005 but need to do some auditing …

  fosco-515896

  1 replies

  18 years ago

  By: GSquared

• How to write to a text file from stored procedure

  How to write to a text file from stored procedure without using xp_cmdshell ? Help....:hehe:

  sanuj

  3 replies

  18 years ago

  By: Peter E. Kierstead

• Auditing login and Database Information on servers

  Hi all, Am trying to do a migration of some servers from 2000 to 2005 but need to do some auditing …

  fosco-515896

  3 replies

  18 years ago

  By: fosco-515896

• Retrieving text of erroring Dynamic SQL

  I have been working with some of the DMVs to better my understanding of what I can capture about er…

  Kimberly.Hahn

  7 replies

  18 years ago

  By: RBarryYoung

• Update statement rounding off

  Hi I have an Update SQL which is rounding off and I don't want it too. Both Fields are decimals and…

  crholder

  10 replies

  18 years ago

  By: Vijaya Kadiyala

• Stripping Rich Text tags in T-SQL

  I have a Text field that shows rich text tags and I need to strip them out. Any Suggestions?

  Todd Wojtkowski

  1 replies

  18 years ago

  By: GSquared

• Linked Access Database Problem

  Hi brainy people.. I have a database of 300 plus tables that was developed over a period of about 1…

  DaftUsername

  1 replies

  18 years ago

  By: GSquared

• question about sending email

  hi guys i am doing a stored procedure in which sends an email with information from a query from th…

  DBA-640728

  6 replies

  18 years ago

  By: DBA-640728

• How to add values from a column and show the total value SQL 2005?

  Hello Everyone, I have a table 'employee' with 3 columns, EMPNO, HRS_WRKD, PAYCODE_NAME This test e…

  DiabloSlayer

  5 replies

  18 years ago

  By: GSquared

• Difference in execution plan for stored porocedure and straight queries

  I have a stored procedure that is taking about 30 seconds to run (in our underpowered test environm…

  Simon Dennison

  6 replies

  18 years ago

  By: Michael Earl-395764

• Calculate the time based on States in a single table

  Hi, I need help regarding calculation the time difference: my data looks like this: FormCode …

  venkatesh-MSBI

  12 replies

  18 years ago

  By: GSquared

• Divide by Zero - bit lost

  Hi Guys, Sorry but i am pretty stupidly new at SQL and need a bit of help, i've had a look through …

  ghostiv

  1 replies

  18 years ago

  By: Hari.Sharma