I have a database and am concatenatiing strings in a view. the value is
coming up as null so I assumed that this was becasue 'concat null yields
null' was set to true. I changed this setting (using the below) and checked
it with the query on the database property (as well as ...

I have a process that builds records to be loaded to my forecast table and
the records looks like this.
MM YY   Customer Type fctlbs
07    2008 abc          cu    100

Is there an MS-DOS command for "What MS-SQL Server instances on this box?"
I've tried:
sqlcmd -L
but it lists everything the box can see, not just what's on the box.

declare @max int
select count(lastname) from customers where payment>200
I would like to store the results on the query in @max. How can I do
that

Hi, can someone help me out with a query, im really stuck as to why
this doesnt work :(
Ive got a tree of data, with the tree stored using nested sets. Each
node on the tree has a "mode". mode 0 means "inherit the mode from my

After suffering from irregular but frequent SQL Injection Attacks over the
last three weeks,
I've finally managed to find a way to stop them, but I don't understand how.
I think it's

i have SQL File distict.sql like this
CREATE VIEW  [dbo].[vFM_11023_CAPropertyStatement]  
AS
SELECT  CAST(tTS_District.District AS VARCHAR(10))  + ' – ' +

I have designed the following table that is generic in datatype for its
primary data ...
Id (PK, bigint, not null)
SymbolId (int, not null)

If someone put text in an image data type, is there a way to search that
column for specific data (full-text indexing would NOT be on the column)?
In particular, it appears the  Content column of the  tbl_Content table in
the  TfsVersionControl database contains the source code ...

How can i remove identity constraint from a table.
Create Table Abc
(
Col1 Int not Null Identity(1,1),

I have a temp table  #Output  with 3 fixed columns. I have to add some
columns to the #Output dynamically based on a variable @max.
Is it possible to add columns dynamically to a temp table? If yes
whats the syntax.

I am getting the following error message when I run sp_databases:
Server: Msg 8115, Level 16, State 2, Procedure sp_databases, Line 32
Arithmetic overflow error converting expression to data type int.
I also get the same message when I run  "select count(*) from ...."

I am loving the new debugger in SQL 2008!  But as spent several hours this
morning playing with it, it struck me that I could spend hours delving around
stored procedures, stepping through, seeing how they work.  But being as I've
worked with SQL for 10+ years, and have never ...

use [mydb]
go
sp_help dbo.myFunction
Msg 170, Level 15, State 1, Line 1

I'm doing a school project and I'm supposed to be able to track campgrounds
and their amenities.  Here is some of the information I'm supposed to store:
CAMPGROUND
Number of Sites   Number