Development

• Topics

  Started by

  Posts

  Last post

• What is difference between Inline Table-values Function and Multi-statement Table-vlued Function

  What is difference bwtween Inline Table-values Function and Multi-statement Table-vlued Function? M…

  Pravin Patel-491467

  9 replies

  17 years, 1 months ago

  By: Gail Shaw

• DB gurus & gurettes!Anybody see anything inefficient about this sproc?

  CREATE PROCEDURE [dbo].[svg_RiskGetCardLocationByIso] declare @CardNum varchar(100), declare @DateF…

  davidsalazar01

  4 replies

  17 years, 1 months ago

  By: davidsalazar01

• Database Mail with hotmail

  i configured Database mail with my company domain and it works fine and thank you for everyone help…

  ikrami2000

  9 replies

  17 years, 1 months ago

  By: tfifield

• Migrating ISQL batch file into MS SQL SVR 2005 with SQLCMD

  Hi all - I have an ISQL Batch File here: isql.exe -U SA -P XXXXXX -d DBNAME -S SERVERNAME -n -i vsm…

  jonathanmreynolds

  3 replies

  17 years, 1 months ago

  By: Grant Fritchey

• Query Proble (From Pravin)

  SELECT SUM(Amount) AS Amount_1 ,Sum(Amount) AS Amount_2 FROM xyz WHERE Column_1 = 2 AND Column_2 = …

  Pravin Patel-491467

  1 replies

  17 years, 1 months ago

  By: ChrisM@Work

• Need a little help on this query

  Hi to all CREATE TABLE SCHOOL (id INT , class VARCHAR(50), name VARCHAR(100), avaliation INT) INSER…

  carlos.tapadinhas

  3 replies

  17 years, 1 months ago

  By: steveb.

• Loading the database into the client

  Hi, While loading the database to the client for demo / installations, is it good to generate scrip…

  Anamika

  1 replies

  17 years, 1 months ago

  By: Grant Fritchey

• Make the row values into a table / list

  Hi, I have a table like col1,col2,col3....suppose the values are product, brand, color i want to re…

  Anamika

  4 replies

  17 years, 1 months ago

  By: ravithegreat

• Stored procedure that makes me to pull my hair out

  Hi guys, I have the following stored procedure. It runs fine only that I cannot capture for some re…

  JJ Duru

  5 replies

  17 years, 1 months ago

  By: JJ Duru

• Importing from Excel to SQL via VB.NET

  Hi there all. I am using the 'insert into' command to import from excel into SQL database. The func…

  msaidi2

  9 replies

  17 years, 1 months ago

  By: Madhivanan-208264

• Data View

  I have a table named employee inout and having below data; Employee codeIn dateIn timeOut time 0…

  eashrak-806640

  1 replies

  17 years, 1 months ago

  By: Chris Harshman

• doubt in e-mail in sql

  hi all, How get/modify the profile_name of a db to send a email from sql (to add profile_name para…

  nageswara.dhaveji

  1 replies

  17 years, 1 months ago

  By: ck9663

• SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'

  USE [DBA] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE […

  Bhuvnesh

  7 replies

  17 years, 1 months ago

  By: jacob sebastian

• Query to get Login details

  I have a table storing user login & logout details with userid, username, login & logout …

  RCRock

  1 replies

  17 years, 1 months ago

  By: Lynn Pettis

• How to change the returned data in SQL?

  Dear All, I have a simple query, and I need to change the returned data. I mean if some row has a v…

  obarahmeh

  3 replies

  17 years, 1 months ago

  By: obarahmeh