T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• create a constraint over 30 columns to have a Unique combination

  hello i have a table with over 60 columns, and i have to implement a constraint on this data set wh…

  Nicolas BrainPowered.Net

  5 replies

  14 years, 1 months ago

  By: Nicolas BrainPowered.Net

• Getting two different rows as columns

  Hi, I'm having some trouble in getting some results. Here is my issue. I got two Tables, CREATE TAB…

  tripri

  12 replies

  14 years, 1 months ago

  By: siva 20997

• Incrementing a table name

  I have a sql server table named raw17. Is there a way to create a new table that increments the nu…

  gary.morey

  23 replies

  14 years, 1 months ago

  By: davidandrews13

• how to properly put variable into SQLString

  Hello, could anybody help. I would like to know how to properly put variable(@dat1) into SQLString…

  peter478

  13 replies

  14 years, 1 months ago

  By: R.P.Rozema

• DElete Duplicates

  Hi, I have duplicates in my table A VehicleID Timestamp CardNum CompanyName CANum Link C…

  PSB

  5 replies

  14 years, 1 months ago

  By: Dwain Camps

• Changing the auto-number/incremented value (not setting it back to 1)

  I have a table with 39+ million rows. Earlier today a developer who "plays" around with this table…

  MyDoggieJessie

  4 replies

  14 years, 1 months ago

  By: R.P.Rozema

• how to add the primarey key constraint in existing table

  Hi Friends, create table pkcon (id int,name varchar(20)) -- here i'm trying to add the primary key …

  sandeep4testing

  3 replies

  14 years, 1 months ago

  By: sandeep4testing

• Creating all possible combinations of two numbers of two columns without recursion or repeatation.

  I have got two columns. I need to create a possible combinations out of it without recursion. (Cros…

  rockybhai

  6 replies

  14 years, 1 months ago

  By: Sean Lange

• update multiple rows with subquery that use EXCEPT

  Hi, I'm writing a script that will update selected multiple rows of records I got from my EXCEPT se…

  ladyblue1075

  4 replies

  14 years, 1 months ago

  By: ladyblue1075

• Updating Across a Partitioned View

  This post concerns updating across a partitioned view, and not unlike others about this subject I’m…

  YogaMatt

  3 replies

  14 years, 1 months ago

  By: spaghettidba

• Filtering IsNull Alternatives

  I have a group of tables that represent people and various profile information. I am working on a m…

  Gabriel P

  6 replies

  14 years, 1 months ago

  By: Gabriel P

• UNIQUE NOT NULL vs PRIMARY KEY

  Hi, I am very curious to know the key difference between unique not null and primary key.:w00t:

  deepikamm

  22 replies

  14 years, 1 months ago

  By: Eugene Elutin

• how to print all the column names with in a table in one row from sys table without pivot

  how to print all the column names with in a table in one row from sys table without pivot SELECT t…

  vijayangk

  10 replies

  14 years, 1 months ago

  By: Lynn Pettis

• Where clause troubles with variables

  Here's the basics of where I'm coming from. I'll do some more coding later on, so ignore the variab…

  SQL_Enthusiast

  5 replies

  14 years, 1 months ago

  By: drew.allen

• How to use dynamic sql and prevent sql injection

  I'm considering using dynamic sql for a particular stored procedure. This procedure is called from …

  Stephanie Giovannini

  3 replies

  14 years, 1 months ago

  By: R.P.Rozema