T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• we're throwing around using the image data type for a project we're doing

  Anybody have any comments on pros and cons for going this route as opposed to storing the physical …

  Snargables

  5 replies

  14 years, 3 months ago

  By: Lynn Pettis

• Script run on one server but error on the other.

  SQL instance names are SQLSERVER1\foundation and SVBerry. Both are 2008 R2 10.50.1600. The query …

  Jeff Sims-413169

  3 replies

  14 years, 3 months ago

  By: Lowell

• Primary Key: GUID vs. INT

  Hi Folk, is it a big performance loose when using GUIDs as Primary Keys? Greetz Teutales

  Teutales01

  23 replies

  14 years, 3 months ago

  By: Lynn Pettis

• I need my columns to trim off a few pounds...!

  Okay Guru's, I got one for you! I believe I'm on the right path, but need some Syntax assistance. …

  SQL_Enthusiast

  10 replies

  14 years, 3 months ago

  By: Anders Pedersen

• How to insert two date values into table sending that values as parameter

  Hi i created a procedure for inserting data into table when i passing values as parameter for date …

  nhimabindhu

  4 replies

  14 years, 3 months ago

  By: OTF

• call/exec a Stored Procedure from a View

  Hi, is there a way, to call/exec a Stored Procedure from a View (SQLS 2008/R2)? 😉 Thanks and Best R…

  info 58414

  7 replies

  14 years, 3 months ago

  By: Lowell

• Fire trigger when IMPORT bulk data using import task.

  Hi Experts, I have a AFTER trigger that is fired after a insert, delete, update activity on a table…

  Eswin

  4 replies

  14 years, 3 months ago

  By: Lynn Pettis

• SSIS SCENARIO

  Hi, Is there any difference between OLEDB Destination and SQL Server Destination in SSIS. Thanks in…

  maheshkrishnas

  1 replies

  14 years, 3 months ago

  By: HowardW

• Having Count

  Hi All, I am having trouble with a statement, i am trying to select all data from 2 tables which li…

  martin.kerr 34088

  15 replies

  14 years, 3 months ago

  By: Ant-Green

• Help Query: Updating data rows of same table!

  Hi All, I have populated the test data as under DECLARE @My_table AS TABLE ( [ID] [smallint] IDE…

  Abrar Ahmad_

  2 replies

  14 years, 3 months ago

  By: Abrar Ahmad_

• NORMINV SQL EQUVALENT CODE

  Hi .. Can u pls say equvalent sql code for NORMINV Excel Function .. Note I need NORMINV not NORMSI…

  greeshma.patla

  3 replies

  14 years, 3 months ago

  By: greeshma.patla

• PL/SQL Translation

  I was given this to translate and I've figured out the obvious syntax differences. But I need help …

  Scott Solice

  9 replies

  14 years, 3 months ago

  By: Jared

• Howe to get unique row

  hi, i have one group suppose @member ,that is parent group,now they has member ,member1 and another…

  hbtkp

  4 replies

  14 years, 3 months ago

  By: Jeff Moden

• How to cascade update when DRI cycles

  I have a requirement to add 3 foreign keys with cascade update to one table. The key fields are cum…

  Stephanie Giovannini

  2 replies

  14 years, 3 months ago

  By: Stephanie Giovannini

• IMPORT DATA INTO A TABLE FROM A FLAT FILE

  Hello All, I’m having a problem importing the data from a .dat flat file that I receive via FTP. I’…

  Ronnie Jones

  5 replies

  14 years, 3 months ago

  By: LutzM