I have a big sql file and I need to run it in management studio. The file
size is 248Mb. When I open the file and run it, I receive the following
error:
Cannot execute script.

i want to flag 500 rows in a staging table as the rows i'm going to process
right now. Once they've been processed they will be deleted, and another 500
will get marked. i don't really care which 500 rows, just 500 of them.  If
the rows has a unique key, i would do an

Any one please help me below query what is the meaning.
IIF(RTL_SML_CONTRACT.TERM_DT=0 Or RTL_SML_CONTRACT.BOOKING_DT=0, 0,
CDate(Mid$(RTL_SML_CONTRACT.TERM_DT,5,2)
& "/"&

Assuming my database contains two tables. Each table with one clustered index
and no non-clustered indexes.
Given that these tables may share a data page within an extent. Is there any
benefit to using different fill factors for each of these tables when

I have written some ASP.NET webservices and some SQL Stored Procedures.
For example, I have a webservice that adds a new employee with 10 input
parameters and 2 output (CounterID and IDKey).
I would like the webservice to return any errors that the stored procedure

I got a slight problem that i just cant understand.
I have the folowing statement
select Case when vfpris is null then 0 else COnvert(numeric(8,2), vfpris)
end

I'm writing a script to create a database.  I'd like to add a description to
the columns when the tables are created via T-SQL (as opposed to manual
entry) but I can't seem to find any documentation that tells me how to do
this.  Is it possible to set this property via SQL?

I have asked in this forum about the posibility handle a SELECTED TABLE
through a variable. Some collaeges told me it is not possible.
Question.
Is this also valid for temporary tables?

I need to update a column in one table based on the output of a view.
The view has two columns IDItem and IDCode.
The table to update has IDItem , IDCode and IDCode2. I require to update
IDCode in this table based on the view, linked on IDItem where IDCode2=5.

1) I have a stored procedure that inserts into Table2 all the values from
Table1. This INSERT statement is within Begin Transaction and Commit
Transaction.
INSERT INTO TABLE2

I have two databases that work tightly together. That means the stored
procedures include lots of cross database queries.
The problem is that when the name of either of the two databases might
change and all cross database queries in stored procedures won't work

I have the following ddl in sql server 2005
id int
sentto nvarchar(1000)
sentto can be like this:

I'm having a table with a column storing Phone numbers. A single
record can have multiple phone numbers separated with "<BR>". I need
to perform search on any phone numbers in it. and even the number is
formatted before storing.

I have a varchar column which has formatted text in it...bullets, tabs, hard
returns, etc..
If I write a SQL script against this table, it will not paste these edits
into Excel. However, if I Open the Table in SSMS and copy from SSMS and paste

I've created many xmls on my sql server 2005 using FOR XML statement.
including single sml. multi nodes, explicit ect...
From Now I give to my programmes the xml example to allow them build their
own code to use my xml.