T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Difference between temporary table and table variable

  I need to know the difference between temp table and table variable..n also the similarities betwee…

  deepikamm

  7 replies

  15 years, 1 months ago

  By: TheSQLGuru

• ROW LOCK while Insert or Updating data in the DB table

  I want to Insert and update same DB table from multiple connections. When i try to do this, i am ge…

  Balaji M R

  1 replies

  15 years, 1 months ago

  By: Grant Fritchey

• Search for an Underscore

  Okay, here's a dumb question that I can't believe I haven't been able to figure out on my own... Ho…

  hughesj23

  3 replies

  15 years, 1 months ago

  By: Gail Shaw

• question with output the number of rows insert

  Hi All, I've a simple SP, just insert, and output number of row been added. my .net app call this S…

  dlam 18073

  3 replies

  15 years, 1 months ago

  By: dlam 18073

• Convert character string date and time into DATETIME data type

  Hi, HEre my query it fetched date and time from table and seperate date and time. while i convertin…

  SPtrt

  4 replies

  15 years, 1 months ago

  By: Jeffrey Williams

• Export to Excel – Format cell

  I do a export from a query into an Excel file. This works fine, however the export of numeric value…

  lars.fornell

  2 replies

  15 years, 1 months ago

  By: lars.fornell

• Expected output

  Hi Team, I need below output Owner of the DB,AutoIncrementof DB,Recovery MOdel of aDB, No.of Maint…

  shiv-356842

  1 replies

  15 years, 1 months ago

  By: crazy4sql

• Problem with Varible with MAX in SP

  Hi, I have a stored procedures with 5 Parameters Example: Create Proc Test ( @parameter1 as varcha…

  Saravanan_tvr

  8 replies

  15 years, 1 months ago

  By: deepak.gupta 25154

• Dynamic SQL

  I've got a stored procedure as: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo]…

  moogle

  6 replies

  15 years, 1 months ago

  By: moogle

• Table value Parameter

  Hi, I have created a Table value parameter as below and executed. Now where can I see this type in …

  gary1

  3 replies

  15 years, 1 months ago

  By: deepak.gupta 25154

• Grouping

  Lets say you have the following tables: Name: --Name_ID Int --Name Char(20) Colors -- Color Char(2…

  mike 57299

  12 replies

  15 years, 1 months ago

  By: tfifield

• Help with Query

  I'm not sure if this is going to make sense, but I have a refresh log table of people with first na…

  Mike Scalise

  3 replies

  15 years, 1 months ago

  By: Evil Kraig F

• SQL server 2005 - accessing a table from another database

  Hello, I'm writing a stored proc. in SQL Server 2005. I need to get data from another database in …

  paucann

  4 replies

  15 years, 1 months ago

  By: paucann

• Working out consecutive days T-SQL

  I need to produce some statistics from our meeting booking system: The setup for this problem is be…

  squidder11

  3 replies

  15 years, 1 months ago

  By: squidder11

• Recursive REPLACE function to change table names in Stored Procedure definition fails

  Hello, everyone. I have been asked by my IT Development department to perform a difficult task on m…

  ivopereira

  3 replies

  15 years, 1 months ago

  By: Lowell