Development

• Topics

  Started by

  Posts

  Last post

• SQl function returning NUll though the query used in function pulls up the data.

  Hello, I have created a SQl function that pulls up the concatenated text from the select query. The…

  sathish.tbj

  1 replies

  14 years, 12 months ago

  By: tommyh

• Insert Trigger - Foreign Key Violation - UnCommittable transaction

  I am facing an issue in Insert Trigger in SQL Server 2005. I have 2 tables. Whenever I insert into …

  Perichiappan L

  1 replies

  14 years, 12 months ago

  By: Johan Bijnens

• insert lots of data into a table from scratch: why so many reads on the target table?

  Dear all, I have a simple piece of code where I try to pump some data into a newly created temp tab…

  Eric Mamet

  4 replies

  14 years, 12 months ago

  By: Eric Mamet

• Delete Data from Excel

  Hi, I have 1 excel in C drive which is i am writing into it, and sending as attachment using SQL s…

  parth83.rawal

  8 replies

  14 years, 12 months ago

  By: le_billy

• how to use a "variable default value"

  Hello, is it possible to use a "variable" default value on a field. I'll try to make it clear with …

  M_N_M

  5 replies

  14 years, 12 months ago

  By: M_N_M

• Question about Triggers in SQL SERVER 2005

  Hi Guys, I am using SQL SERVER 2005. I havent used any trigger till now in my job. So I am facing a…

  grkanth81

  1 replies

  14 years, 12 months ago

  By: Bhuvnesh

• Count() by date range

  a. tblMen i. ManId (Int) – Primary Key ii. TestDate (Datetime) – The date that the person has taken…

  Redmond01

  1 replies

  14 years, 12 months ago

  By: Dave Ballantyne

• Bifurcating XML data into various tables

  hi, I am trying to import an XML file into SQL server 2005. Will it not create the tables and requ…

  bhatt.vikalp

  2 replies

  14 years, 12 months ago

  By: LutzM

• Integer Division to get Percentage

  I am trying to get percentages. I realize that I am doing integer division and the result will be …

  24tjf

  3 replies

  14 years, 12 months ago

  By: postonoh

• Datetime format issue in SQLServer2k5

  is there any possibility to set the date format "dd-mon-yyyy hh24:mm:ss " in SQLServer2k5?... not u…

  BeginnerBug

  3 replies

  14 years, 12 months ago

  By: ChrisM@Work

• error log in sql server2005

  i have stored procedure as follows proc_multi_trans() { insert stmt // here i want to make a log i…

  BeginnerBug

  12 replies

  14 years, 12 months ago

  By: BeginnerBug

• Query tweak required

  Select top 5 'MY DATABASE TABLE: ' + name from sysobjects where xtype = 'u' order by 1 desc Pre…

  Bhuvnesh

  7 replies

  14 years, 12 months ago

  By: Bhuvnesh

• parent nodes for xml explicit

  Hi there- I am trying to shape an xml result from a query using xml explicit. I am very new to usin…

  danielah

  5 replies

  15 years ago

  By: danielah

• Row by Row Arithmetic

  Dear Experts, I have an interesting problem here. I have a two values on a row. Say value A = 5000…

  martin.edward

  2 replies

  15 years ago

  By: SQLCHENNAI

• Loop calendar table and delete rows

  Hi, I have two tables (SQL Server 2005) "PeoplesCalender" and "Leavers". The two tables look like t…

  SQL_Kills

  3 replies

  15 years ago

  By: SQL_Kills