T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SP to get Server Users

  I am looking for the stored proceedure to get all of the users and their rights on a server. I hav…

  Kyle Schlapkohl

  8 replies

  18 years ago

  By: Jeff Moden

• tallying values in columns of each row

   I have a table where each row has 20 columns col1, col2, col3 etc...., 16 of which contain nu…

  Coriolan

  5 replies

  18 years ago

  By: Jason Selburg

• Exec SP to all the database in a server

  Hi all I want to execute an SP to all the databases. But i don't have the SP in all of them. Please…

  Prakash-205770

  3 replies

  18 years ago

  By: Prakash-205770

• Bulk Insert Using Openrowset

  I have a text file with 4 columns (semi-colon seperated) and variable number of rows. I have manage…

  Steve Ring

  1 replies

  18 years ago

  By: Jeff Moden

• sp_helplogins

  I am trying to discern the various aspects of the t sql behind this stored proceedure. Has anybody…

  Kyle Schlapkohl

  1 replies

  18 years ago

  By: Andras Belokosztolszki

• Exec SP to all the database in a server

  Hi all I want to execute an SP to all the databases. But i don't have the SP in all of them. Please…

  Prakash-205770

  1 replies

  18 years ago

  By: Andras Belokosztolszki

• trigger help

  Hi all, I have created the trigger for audit purpose. I just wanted to have on column to be instert…

  SQLRep

  3 replies

  18 years ago

  By: SQLRep

• sql commands

  what is the command to find out 2nd highest salary in a salary column

  cvsuman

  1 replies

  18 years ago

  By: Aaron Ingold

• Need to get results of an EXEC(@string_variable) into a local variable

  Here's one example: declare @LockCount int, @WhereClause varchar(1000) set @WhereClause = ' Projec…

  Takauma

  2 replies

  18 years ago

  By: Ray M

• ''Varchar'' in sql to ''memo'' in Access

  I am exporting my sql table to the access database. My text fileds in SQL are stored as varchar(50)…

  Nuts

  1 replies

  18 years ago

  By: Bob Fazio

• Advise on date conversion

  Hi all. I am exporting shipment data from a UPS system to an internal SQL Server 2005 table. I don'…

  David Tyler-455966

  6 replies

  18 years ago

  By: David Tyler-455966

• sp_helplogins

  I am trying to send the output from sp_helplogins to a table, however, whenever I run it the result…

  Kyle Schlapkohl

  3 replies

  18 years ago

  By: Andras Belokosztolszki

• Outer Joins on Composite Keys using Join Syntax in the From Clause (ANSI SQL:1992)

  Can anyone tell me how to rewrite this query in ANSI SQL: 1992 instead of using the *= operator for…

  tibins

  1 replies

  18 years ago

  By: Greg Walker

• Need help figuring out relation of table to sequence number.

  I am getting an error (20598) row not found.  I am given a transaction sequence number and I n…

  JR McGee

  1 replies

  18 years ago

  By: Gail Shaw

• I could sure use a "DATE" function and/or data type....

  I am migrating another SybaseSQLA db to SS2K5.  SybaseSQLA  has a DATE datatype whi…

  Takauma

  4 replies

  18 years ago

  By: Jeff Moden