T-SQL

• Topics

  Started by

  Posts

  Last post

• Complicated query

  Hello, I have 2 following tables: CREATE TABLE MAIN_TABLE (record_id int PRIMARY KEY,sol_number var…

  Eroshenko

  5 replies

  23 years, 9 months ago

  By: Eroshenko

• Sql Server

  I have one table in my database Employee There are three columns in employee table and in table i h…

  renu

  3 replies

  23 years, 9 months ago

  By: SQLZ

• Drop Temp. Table

  how to drop a temprory table created by command create table #123 thanks in advance from alkesh

  alkesh.parikh

  3 replies

  23 years, 10 months ago

  By: Andy Warren

• Sql mail Configuration

  How to configure Sql mail by using the store procedure xp_sendmail.. thanks in advance from alkesh

  alkesh.parikh

  5 replies

  23 years, 10 months ago

  By: Andy Warren

• Can we use any ActiveX Object in SQL Server

  Can we use any kind of activex object in SQL server stored procs. I have used CDONTS component to s…

  paras_98

  1 replies

  23 years, 10 months ago

  By: Andy Warren

• triggers problem

  hello there, i have written a trigger for the city table. whenever a user enters a value in it it w…

  keyur

  2 replies

  23 years, 10 months ago

  By: GRN

• SELECT Into a Stored procedure

  Into a store procedure I want write a SELECT changing dynamically the name of table to select. I ha…

  taki

  6 replies

  23 years, 10 months ago

  By: taki

• Ident_current and Dynamic SQL

  Hello, Could some one please tell how to get the current Identity value from a table using Dynamic …

  kiranpchandran

  4 replies

  23 years, 10 months ago

  By: Andy Warren

• Table update using Trigger

  I have table A with three fields. Emp_Code Char(3), Emp_Name varchar(15), Policy_Change_Date dateti…

  satish

  4 replies

  23 years, 10 months ago

  By: satish

• accessing tables from 2 different databases

  hello there, i want to access two different tables a and b which are in two different databases d1 …

  keyur

  1 replies

  23 years, 10 months ago

  By: Andy Warren

• Using Output Variables from One Procedure to Other

  I just needed a help from you. The problem that I am facing is that I am not able to use the output…

  paras_98

  1 replies

  23 years, 10 months ago

  By: Andy Warren

• Dynamic TSQL in trigger using values from inserted

  How to build dynamic TSQL statement in an instead of trigger for inserting values from inserted to …

  Attila Sandor

  5 replies

  23 years, 10 months ago

  By: Andy Warren

• TSQL Stored Procedure giving Problems.

  I have a stored Procedure to calculate Percentiles of a Numeric field.The stored Procedure works fi…

  sxnandwa

  7 replies

  23 years, 10 months ago

  By: sxnandwa

• Sending SP output to a text file

  We have SQL Servers: 6.5/7/2000. How can I issue, via SQLServereAgent scheduler, the commands "sp_h…

  Barkingdog

  2 replies

  23 years, 10 months ago

  By: Andy Warren

• Nested Triggers

  hi once again, i am working on MS-SQL 7.0. Just Recently we have shifted our database from Access t…

  keyur

  5 replies

  23 years, 10 months ago

  By: keyur