T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Recompile Features include at existing SP?

  HI, Option1: WITH RECOMPILE - only Stored Procedure Option2: Option (Recompile) - only SQL stateme…

  SQL Galaxy

  1 replies

  14 years, 5 months ago

  By: Mike John

• SQL about select records that has max count

  I have a query that wants to make a default orgUnitID to a Orgization. Basically I check to see whi…

  sqlfriend

  3 replies

  14 years, 5 months ago

  By: J Livingston SQL

• query XMLType

  Hi i have a tabel a lot of field AND with a XML field contining a xml. The xml look like following …

  peter_opglab

  1 replies

  14 years, 5 months ago

  By: Mark Cowne

• GROUP BY Problem

  I have a query which uses a CASE WHEN to calculate some value. Inside CAS..END, I have used some fi…

  meelan

  5 replies

  14 years, 5 months ago

  By: Manjuke

• Logic and Theory / Optimisation

  I've just optimised a query to run in 19 seconds rather than just under 5 mins. All I did was take …

  Rob-350472

  8 replies

  14 years, 5 months ago

  By: TheSQLGuru

• Truncate Log File

  Hi All, I am running SQL Server 2008R2 and am getting the following error: Msg 9002, Level 17, Sta…

  martin.kerr 34088

  3 replies

  14 years, 5 months ago

  By: stephen7272

• INDEXES

  how does sql engine decide what indexes to use when seeking indexes from table or tables that has c…

  peacesells

  5 replies

  14 years, 5 months ago

  By: stephen7272

• t-sql,sql server 2000

  I have 2 tables A and B Table A columns: Name -nvarchar ID1 -nvarchar ID2 -nvarchar CatID -int Tabl…

  mtz676

  1 replies

  14 years, 5 months ago

  By: Gail Shaw

• String or binary data would be truncated -- Mysterious

  Hi, " String or binary data would be truncated" I am getting the above error in my SP. While Invest…

  na1774

  14 replies

  14 years, 5 months ago

  By: SQLRNNR

• Means to export a varbinary(max) column from the database to disk

  I'm working with msdb.dbo.sysmail_attachments I'm trying to write a stored proc that will take fail…

  mtassin

  6 replies

  14 years, 5 months ago

  By: GSquared

• Sanity Check - using CASE in WHERE clauses

  I'm more after a sanity check before I plough on and do something incredibly stupid :hehe: We frequ…

  Rayven

  17 replies

  14 years, 5 months ago

  By: brendan woulfe

• tsql statement differnces

  Hi, Can anyone tell me what is the exact behaviour or difference between the below two sql statemen…

  Oracle_91

  1 replies

  14 years, 5 months ago

  By: Adi Cohn-120898

• Basic Create Foreign Key Issue

  Hi All, I am getting an error when I try to create a foreign key. Scenario: I have tables A, B and …

  Pyman

  5 replies

  14 years, 5 months ago

  By: Pyman

• bulk insert from csv file and physical order

  This is not my choice I hasten to add but I may need to do it. Currently, I import a csv file conta…

  kuopaz

  4 replies

  14 years, 5 months ago

  By: kuopaz

• Dynamic SQL Error

  When I execute the script below, I get the message: Msg 102, Level 15, State 1, Line 1 Incorrect sy…

  JayWinter

  12 replies

  14 years, 5 months ago

  By: ChrisM@home