T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Lock and No Locks

  Hi, Need help on understanding when to use locks and no locks on sql querys Thanks for the help

  forum member

  7 replies

  15 years, 5 months ago

  By: bmk086

• A sysntax error

  Hi this is my store procedure ALTER PROCEDURE [dbo].[ConnectionCourseEmpProc] @VarEmp_Id int, …

  nazaninahmady_sh

  2 replies

  15 years, 5 months ago

  By: Praveen Goud Kotha

• Query help..

  Hi all I have to form a query, need some help on that,Here is the case.... From a table that has an…

  sql_learner29

  12 replies

  15 years, 5 months ago

  By: MMartin1

• Rename Table Without Stored Procedure

  Hi, I want to rename the table without using a stored procedure. Possible solution: Create copy of …

  amrata88

  5 replies

  15 years, 5 months ago

  By: Jeff Moden

• remove ""

  i have a table having double quotes (" ") in all 10 columns. (sample values like "10101" ,"1291919…

  bang.prashant

  4 replies

  15 years, 5 months ago

  By: Tonci Korsano

• query on indexes

  I have a particular table that has several indexes. How can I write (a) T-sql statement(s) that wi…

  mw_sql_developer

  4 replies

  15 years, 5 months ago

  By: Gail Shaw

• ssis problem in T-Sql

  Hi everyone, I have a strange requirement in SSIS, that I wanted to share with you all, and need so…

  riajain9

  10 replies

  15 years, 5 months ago

  By: Ben Teraberry

• delete a row from parent and all child records

  I want to delete a row, which is dependent on some other tables(more than 32). How to delete a row …

  HBK_4700

  1 replies

  15 years, 5 months ago

  By: Eugene Elutin

• Is a cursor the best way to bulk insert to multiple tables with foreign key?

  Hello All, I have read many times that cursors are bad and try to avoid using them. However, I have…

  Paul-202125

  6 replies

  15 years, 5 months ago

  By: Eugene Elutin

• SQL Query Problem

  Hi all, I have a problem to write this query, anyone can give me any ideas ? 🙂 There are two tables…

  sqlbaby2

  7 replies

  15 years, 5 months ago

  By: Praveen Goud Kotha

• using CASE in WHERE clause

  Hi, i would like to compare a value in the Where clause if it is SELECT * FROM Tbl1 WHERE TYPE = CA…

  Anamika

  12 replies

  15 years, 5 months ago

  By: Kingston Dhasian

• Column_Type

  Hi What is Column_Type. Why is it used for? Thanks S John

  m--S3qU3L

  5 replies

  15 years, 5 months ago

  By: m--S3qU3L

• Function with Select * that references a View

  In the code below, the function continues to return the columns from the original view after the vi…

  Edward Boyle-478467

  7 replies

  15 years, 5 months ago

  By: Eugene Elutin

• Repetitive Operators

  Hi.. We can fetch the same result by using !<(Not Less than) or >=(Greater than or equ…

  Praveen Goud Kotha

  4 replies

  15 years, 5 months ago

  By: Dave Ballantyne

• Encryption using TRIPLE_DES returns NULL

  I am trying Encrypt some numbers using SS 2005 Here is my Table Structure CREATE TABLE [dbo].[Acco…

  Minnesota - Viking

  3 replies

  15 years, 5 months ago

  By: Minnesota - Viking