Development

• Topics

  Started by

  Posts

  Last post

• NOT NULL and Spaces

  Hi, I'm trying to eliminate all rows where the column is either NOT NULL or contains spaces. So my…

  dale_keller

  10 replies

  17 years ago

  By: Lynn Pettis

• Slow ODBC Query but Faster Through Studio Manager

  I have a stored procedure we run from VB6 code using DSNless ODBC that ran fine through SQL Server …

  R Loberg

  4 replies

  17 years ago

  By: R Loberg

• Combined Primary Keys or 1 Auto Incrementer?

  Dear All I have a table Pages and it has the following fields PageId smallint PageName nvarchar(250…

  Johann Montfort

  6 replies

  17 years ago

  By: Johann Montfort

• deleteCommand with Join -issue..

  Hi there I have two tables ( tbl_user and tbl_user_role ). tbl_user_role is joined to tbl_user by …

  cgoasduff

  3 replies

  17 years ago

  By: Johan Bijnens

• Logging user variables into a table

  I would like to log the names, values of user variables used in a package. This package can be any …

  Jacobus-785651

  1 replies

  17 years ago

  By: Jacobus-785651

• coversion

  how to convert sql server200:5 sql script in oracle 10g form 🙂

  ravi41184

  1 replies

  17 years ago

  By: krayknot

• The Recomended way (SQL 2005) to handle Default Value on Existing Null Enabled Column

  DB Platform: SQL Server 2005 Enterprise Ed (64) The Situation: Existing table used to store logins …

  YSLGuru

  16 replies

  17 years ago

  By: YSLGuru

• The Difference between Using Assignment & Aliases

  First off let me say that I hope this isn't a dumb question; I have the feeling it's one of those t…

  YSLGuru

  6 replies

  17 years ago

  By: Jeffrey Williams

• Sending mails from SQL 2005

  We are facing some issue with Sql Server 2005 Database Mail Queue functionality using "msdb.dbo.sp_…

  Rookee DBA

  1 replies

  17 years ago

  By: Lowell

• Problems with xp_sendmail SQL 2005

  Hello all, MS SQL 2005 I would like to email the results of a SP, i am using the following code: e…

  A Little Help Please

  2 replies

  17 years ago

  By: kjaved

• Training

  Can anyone point me in the right direction for training in T-SQL? Onsite training, online, labs, e…

  SQLSeTTeR

  2 replies

  17 years ago

  By: SQLSeTTeR

• To insert table of data into database through SP

  Hi, I need to insert a delimited string of data into database through a stored procedure The strin…

  meeraarjun

  8 replies

  17 years ago

  By: meeraarjun

• Loop through a list of parameters to pass to a sproc

  I have a sproc that has two parameters. It lives on a server which I only have remote access to. My…

  stacik

  3 replies

  17 years ago

  By: stacik

• sp testing

  Hi, I need to test stored procedures with various input parameters to make sure no input make it cr…

  fredrik-690611

  5 replies

  17 years ago

  By: Grant Fritchey

• GROUP BY Problem in my Script

  Hi, SELECT DISTINCT dbo.RoomRates.RoomID, CASE WHEN (dbo.RoomRates.Overflo…

  Babu Kumarasamy

  3 replies

  17 years ago

  By: Sander A.