T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• The Guru's Guide To Transact SQL

  Is "The Guru's Guide To Transact SQL" the best book available to learn T-SQL or I should read one o…

  YankeesSQL

  1 replies

  14 years, 10 months ago

  By: ColdCoffee

• Dynamically load expected records

  Hi, I have to dynamically load records using this update statement below. UPDATE V SET V.Vehicle…

  PSB

  1 replies

  14 years, 10 months ago

  By: Sean Lange

• Ordering with nulls

  I've the results of a full outer join that I want ordered. This is just an example as I'm strugglin…

  kuopaz

  9 replies

  14 years, 10 months ago

  By: toddasd

• UPDATE statement with INSERT

  This works okay, but it's not really what I want... :crazy: Can anyone help me with a script? IF E…

  SQL_Enthusiast

  2 replies

  14 years, 10 months ago

  By: R.P.Rozema

• Using Intersect in a IF statement

  Assume table1 and table2. col1 in table1 has a row values 'HELLO WORLD' and 'HELLO ALL', which can…

  Blue Rabbit

  4 replies

  14 years, 10 months ago

  By: Lowell

• CASE Statement to count non-nulls

  Hello All, See the sample data below. I need to evaluate Field1, Field2, Field3, and Field4 and ret…

  Chrissy321

  4 replies

  14 years, 10 months ago

  By: Chrissy321

• Difference in PATINDEX behaviour in SQL 2008 vs 2000

  Hello All, I am doing a database migration from SQL Server 2000 to 2008. During migration, I found …

  SMNayak

  2 replies

  14 years, 10 months ago

  By: SMNayak

• Using table valued parameters with SPs pros and cons

  Hi, Just was wondering, from the best practices point of view, are there any disadvantages in using…

  Roust_m

  4 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Help on XML read and insert

  Need help on below XML read and insert... DECLARE @x XML SET @x = '<i18n> …

  s-sql

  2 replies

  14 years, 10 months ago

  By: s-sql

• please interpret sql clause

  What is the following clause, placed in front of an INSERT statement, accomplishing? Specifically …

  KoldCoffee

  11 replies

  14 years, 10 months ago

  By: KoldCoffee

• how to alter user name?

  Hi, Login Name - HWDATA User name - HWData I want to change the user like HWDATA. how to do that? …

  SQL Galaxy

  1 replies

  14 years, 10 months ago

  By: baabhu

• Error with converting to bigint in case statement

  I'm having a problem properly converting a value properly using a case statement. For some reason …

  Rogman

  9 replies

  14 years, 10 months ago

  By: Rogman

• Help with SQL Query

  Hi, i got a table which resembles like IdTypeAddressCity 1Homeabcca 1Officexyzal 1Workrj…

  tripri

  7 replies

  14 years, 10 months ago

  By: tripri

• Date and Time Query Help

  Hello - I need some T-SQL help and hope someone can clear my head of this. I have a query I want t…

  david.ostrander

  6 replies

  14 years, 10 months ago

  By: david.ostrander

• Basing the where clause on certain conditions

  I have some tables which I am trying to perform a join. My result set data comes from the DATA_TABL…

  Rog Saber

  4 replies

  14 years, 10 months ago

  By: Rog Saber