T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Insert records into a table with an identity value

  This should be pretty straight forward. But I am having a bit of a problem. I would like to INSERT…

  Randy Powell-473969

  1 replies

  11 years ago

  By: Phil Parkin

• Convert nanoseconds since 1/1/1601

  I have an ldap query which writes data to a SQL table. Fields like "LastLoggedON". Unfortunately it…

  kevin sexton

  13 replies

  11 years ago

  By: tripleAxe

• First Day and Last day of the previous month in ssis expression

  How to find the firstday and last day of previous month in ssis expression? Example: need file name…

  PJ_SQL

  5 replies

  11 years ago

  By: Luis Cazares

• T-SQL Development Standards

  I've been tasked with authoring SQL Development standards for my corporation. I am starting with T-…

  Bryant McClellan

  19 replies

  11 years ago

  By: Jeff Moden

• Finding a word within a string

  Hi, i wanted to select a word within a string, ie; for example, "I have: a - doubt". In this string…

  Boby B Jacob

  6 replies

  11 years ago

  By: Boby B Jacob

• SELECT to transform a csv of INT into VARCHAR

  How to in a SELECT statement transform a csv of int-values in varchars? I have 2 tables: One with N…

  Henk Schreij

  13 replies

  11 years ago

  By: jvenezia

• AccessDB ODBC link to SQL table turns nvarchar(MAX) into memo, causing crash

  Hi everyone - I realize this is probably more of an Access problem than a SQL Server problem, and h…

  ebowditch

  4 replies

  11 years ago

  By: ebowditch

• Replace not replacing all instances of text in a string

  Hi all I've got some string fields that may/may not have the following at the beginning:- Verdan…

  richardmgreen1

  5 replies

  11 years ago

  By: Phil Parkin

• Decrpyting the password field in table

  Hi , Is there any way to decrypt the password field in one table without using the symmetric key…

  sram24_mca

  1 replies

  11 years ago

  By: Gail Shaw

• Passing Integers in my query

  so I am working on this one timer and I am either too tired or struggling on how to pass multiple …

  cory 76184

  6 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• Unpivoting multiple columns.

  hi all, I want to unpivot multiple columns in my table and i came across this article http://manga…

  srilu_bannu

  9 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• Read Letters until first Number

  hi i need to extract the letters of a postcode up until the first occurrence of a number eg BT67 8k…

  dopydb

  7 replies

  11 years, 1 months ago

  By: mister.magoo

• Help remove cursor and impelment usig something else

  DECLARE expiredRegs CURSOR STATIC FOR SELECT DISTINCT register_ID, sessionID, event_ID FROM reg…

  rshashid

  1 replies

  11 years, 1 months ago

  By: Luis Cazares

• Primary Key creation - before and after bulk insert

  I need to insert a large (less than half a million) number of records into a table at once. This ha…

  Arjun Sivadasan

  28 replies

  11 years, 1 months ago

  By: Paul Golabowski

• sql_variant

  Hi All, I still can't seem to find a use or reason for "sql_variant" datatype. Surely you should al…

  Christopher Stobbs

  14 replies

  11 years, 1 months ago

  By: MMartin1