T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Using Lile and OR in a WHERE clause

  Hi, I need to use a Like statement with an Or statement in a where clause. below is what I am tryi…

  David Tooker

  6 replies

  10 years ago

  By: drew.allen

• Assigning value to scalar variable from select statement

  How do I set the value of a variable in a function to a scalar value extracted from a table? For ex…

  SeanAchim

  3 replies

  10 years, 1 months ago

  By: ijalcavaliers

• if in a query filter....function?

  I need to make the querys where the filter is changing (depends on the values contained in some fie…

  antonela

  2 replies

  10 years, 1 months ago

  By: antonela

• Insert database name into a table

  Hi all I'm trying to set up a maintenance plan with logging on several servers (there's none at all…

  richardmgreen1

  3 replies

  10 years, 1 months ago

  By: richardmgreen1

• BCP and SQL Server Express

  I am trying to do BCP , but throwing “unable to load BCP resource DLL. BCP cannot continue” I have …

  ethio6

  2 replies

  10 years, 1 months ago

  By: oxford-45

• get Count(*) to return 0

  I have to join two tables that share the column report_Id. I want to return the counts of all repor…

  Faye Fouladi

  17 replies

  10 years, 1 months ago

  By: lucky.ncube

• DateAdd overflow using Numbers Table

  I have a table "Numbers" with a single int field "N". The records go from 0 through 100,000. I'm t…

  ArcticEd32

  10 replies

  10 years, 1 months ago

  By: kaj

• NATURAL JOIN

  I have never seen the specific syntax "NATURAL JOIN" used (or documented) in T-SQL. Maybe it is. …

  dglane

  19 replies

  10 years, 1 months ago

  By: Lynn Pettis

• Combine columns from multiple tables into a single table with sum

  I'm having a hard time figuring out the right way to ask the question, so I'm sorry if the subject …

  ArcticEd32

  4 replies

  10 years, 1 months ago

  By: ArcticEd32

• IF table exists, DROP TABLE then CREATE TABLE - script not working

  Hi all, This code to change a column name is not working and I'm not able to figure out why: IF OBJ…

  jhager

  14 replies

  10 years, 1 months ago

  By: Jovan Popovic

• Why OPENROWSET returns error

  I have a sp and need to run it with parameter exec spGetCategoriesByDocIDAsTable 811 This will retu…

  halifaxdal

  7 replies

  10 years, 1 months ago

  By: JediSQL

• SQL Injection - What to look for in a string

  Hi, I was asked to go through stored procedures and make modifications so SQL injections would be …

  SQThaal

  7 replies

  10 years, 1 months ago

  By: Ed Wagner

• Dynamic SQL to grant permission but avoid SQL injection

  I was asked to go through stored procedures and make modifications so SQL injections would be impos…

  SQThaal

  2 replies

  10 years, 1 months ago

  By: SQThaal

• group by continual

  Hello, Let's say I have a table with 2 columns, id and name, where I insert 4 rows: id name 1 …

  SeeknFind

  4 replies

  10 years, 1 months ago

  By: SeeknFind

• send mail stored procedure reply issue

  I have a stored procedure to send email and it works. The issue is when the recipient clicks on Re…

  is250sp

  2 replies

  10 years, 1 months ago

  By: is250sp