T-SQL

• Topics

  Started by

  Posts

  Last post

• PERCENTAGE

  I am trying to calculate percentage in select statement but i am getting wrong result, please help …

  rs

  2 replies

  22 years ago

  By: rs

• Returning a RID

  I have a table that does not have an index.   There are some duplicate rows in the table…

  ericp37

  3 replies

  22 years ago

  By: kg_murthy

• list of tables with identity field.

  I need to get a list of  tables where there is an identity field. I didn't find these informat…

  Linata

  6 replies

  22 years ago

  By: rockmoose

• Full-Text Indexing Issue -- Please Reply

  The Microsoft SQL full-text indexing seems to be working fine, however why does it only work when I…

  finance_teacher

  1 replies

  22 years ago

  By: vadba

• trigger problem

  Here is my trigger code. CREATE TRIGGER insert_into_emp ON emp FOR INSERT,UPDATE,DELETE AS SET XACT…

  ambrose_sql

  5 replies

  22 years ago

  By: ambrose_sql

• Forcing Exception logging not be SUBJECT to ROLLBACK inside a transaction

  I need to be able to log (insert) data exceptions into an exception table from stored procedures an…

  Dean Natenzon

  3 replies

  22 years ago

  By: Dean Natenzon

• Can I format a float with a specific scientific notation format?

  I have a table with floats and I want to format them in a view so that they are always displayed&nb…

  bpelletier

  2 replies

  22 years ago

  By: bpelletier

• TSQL Debugger from a workstation

  Trying to use the TSQL debugger in Query Analyzer on a workstation on the local LAN. Environment: S…

  Tim OPry

  6 replies

  22 years ago

  By: Tim OPry

• isql output question

  I am running a script using isql and sending the output to a txt file via -o; The put put contains…

  arobinson

  4 replies

  22 years ago

  By: arobinson

• Catching error from UDF inside a SP

  Hi all. I have a UDF wich basically do some like this: CREATE FUNCTION( @func_param )RETURNS INT A…

  Mithrandir

  5 replies

  22 years ago

  By: SteveB-74825

• bulk insert not inserting everything...

  Hi all, I'm using this code to read in the contents of a file: (@filename & @filecontent are de…

  BitRocks

  8 replies

  22 years ago

  By: dongadoy

• Calculating days in a month

  Can anyone point me to SQL Server code that can calculate the number of days in a specific month? &…

  vanGogh-136038

  5 replies

  22 years ago

  By: covitz

• Help on the Group by ...

  Hi folks, I am a new user and i have to count the records that i have in double in a table. I …

  Dan_2003

  3 replies

  22 years ago

  By: Gannonator

• need ideas on Count()

  Hi friends The following query returns list of our cliens requests (categorywise we mark each each …

  sqlpro

  3 replies

  22 years ago

  By: sqlpro

• Trying to compare date fields

  I have been on a 3-year hiatus from SQL and I'm just coming back to it, trying to refresh my memory…

  Paul Kendall

  1 replies

  22 years ago

  By: Johan Bijnens