T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Why do we use # for temp tables name?

  I even notice ppl using ## or ###, does this have another meaning? Is this a common good practice? …

  cino

  4 replies

  15 years ago

  By: GSquared

• What is the difference between "tempdb.#tmptbl" and "tempdb...#tmptbl"?

  And we get an error (like below) when we exceed 3 periods. The object name 'tempdb....#tmptbl' cont…

  cino

  1 replies

  15 years ago

  By: Lowell

• Reg stored procs deployment

  Hello every one, I have a small question. I have some stored procs like 25-30. I need to alter them…

  sqlnew

  4 replies

  15 years ago

  By: Johan Bijnens

• Does Create Login automatically grant connect privilige

  I created a Login: create login ravid with password = 'ravid', DEFAULT_DATABASE = plu Then tried to…

  martin.s.ransome

  3 replies

  15 years ago

  By: Michael Valentine Jones

• Tally Table vs. While Loop

  My job requires me to parse files in various formats, and standardize them into our system's format…

  jarid.lawson

  28 replies

  15 years ago

  By: The Dixie Flatline

• Newbie issue with Transactions

  Hi all... If I debug/step through the following TSQL: BEGIN Transaction update company set name…

  mike 57299

  5 replies

  15 years ago

  By: Gail Shaw

• create login

  When I execute the following T-SQL DDL statement: create login ravid with password = 'ravid' DEFAUL…

  martin.s.ransome

  2 replies

  15 years ago

  By: martin.s.ransome

• About partitioning

  Hi, i need to get good knowledge on partitions(vertical and horizontal partitioning). Will anyone c…

  sqlmaverick

  2 replies

  15 years ago

  By: MysteryJimbo

• Adding rows in same table for different period

  Hi, I need your expertise on this issue. Basically the reason to do this is to calculate YTD values…

  yingchai

  2 replies

  15 years ago

  By: Orlando Colamatteo

• Issue with SELECT TOP where TOP dynamic

  I am trying to delete oldest records after the last n records where n could be 5 or 6 (this would b…

  tshad

  4 replies

  15 years ago

  By: tshad

• Extra Records

  Hiya, I have the following query, which returns data from our clocking in database; SELECTE.EMP_F…

  lanky_doodle

  9 replies

  15 years ago

  By: Orlando Colamatteo

• conditional table joins

  I would like to join two tables. If there is no match for one column, I would like to say join with…

  Amy.G

  9 replies

  15 years ago

  By: The Dixie Flatline

• dynamic sql

  I have to write a stored procedure which serves as a universal stored procedure for all the tables …

  Lucky9

  15 replies

  15 years ago

  By: Lucky9

• Hypothetical Queries and Joins. AKA Why are these different?

  I know that its different and reading the execution plan obviously shows it's different, but I'm tr…

  Obs

  8 replies

  15 years ago

  By: Evil Kraig F

• cross join exclude data based on partial character of a data

  TABLE: CREATE TABLE [dbo].[vwCourseClass]( [CourseTitle] [nchar](10) NULL, [ClassTitle] [nchar](1…

  mmi 9526

  14 replies

  15 years ago

  By: The Dixie Flatline