T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• BCP Format file and Unicode

  Hi, I have a problem creating unicode file from BCP, I have to create fixed width file for which I …

  BSql_Dev

  6 replies

  16 years ago

  By: BSql_Dev

• Truncate command using Procedure

  Hi, I want to a procedure to truncate a table and insert record after truncation.But when i run thi…

  nandan619

  1 replies

  16 years ago

  By: Gail Shaw

• Find Missing Number in a Sequence of numbers

  Hi, In a table i have a column with name "SortOrder" having following rows ID Name SortOrder 5 a…

  pinna_hari

  4 replies

  16 years ago

  By: Paul White

• SQL QUERY PROBLEM

  I have two tables in which few columns are same as mentioned in my query condition, what so I am to…

  biren

  5 replies

  16 years ago

  By: Paul White

• Problem - Stored Pocedure

  Hi ! All I need your help regarding a new problem created in one of my stored procedure, The th…

  Shintu

  5 replies

  16 years ago

  By: Shintu

• Convert Julian date to Gregorian date

  I am trying to convert Julian dates to gregorian dates in sql server but Julian date column has inv…

  pinky

  9 replies

  16 years ago

  By: SparTodd

• get data from two tables

  I have two tables, the first, say item_table and second say stage_table. The item_table is a di…

  datelligence

  5 replies

  16 years ago

  By: naveena 78933

• Licensed Limit

  Hi there, Im a bit playing with some stuff and encountered an error. Here's my Code: CREATE DATABA…

  Quatrei.X

  5 replies

  16 years ago

  By: sqlvogel

• INTEGER IDENTITY -WITH behaves differently from CREATE TABLE

  This code works: SET NOCOUNT ON DECLARE @lngTabCount INTEGER DECLARE @lngLoopCount INTEGER DECLARE …

  brosspaxedi

  4 replies

  16 years ago

  By: Matt Miller (4)

• Problem with DATE

  Hi ! ALL I have a very small problem. I have a table named dbo.Container, there are two colm…

  Shintu

  5 replies

  16 years ago

  By: Paul White

• Computed Column

  Hi, I am creating a table EmployeeResult. I want to include computed column which will be 1 if EmpA…

  luckysql.kinda

  3 replies

  16 years ago

  By: Paul White

• Need assistance in LIKE

  I am trying to write one query as follows: I am getting value of @ucf from first query. I am trying…

  luckysql.kinda

  4 replies

  16 years ago

  By: Paul White

• JOIN with the resultset from a stored procedure?

  Hi, I have a stored procedure with 1 input parameter, in which I am using a dynamic PIVOT table. Th…

  Veronka

  8 replies

  16 years ago

  By: Paul White

• Constraint Syntax

  Wasn't quite sure where to post this question as I'm looking for opinions on style, hope this is a …

  Sioban Krzywicki

  8 replies

  16 years ago

  By: Paul White

• Why SQL Server 2005 (9.0.4723) gives Incrrect syntax error on (basic) SELECT?

  Hi all! I'm having quite a strange problem, in every other sql server version it works, but this on…

  Arto Kainu

  3 replies

  16 years ago

  By: Paul White