I have a view in a Sql Server database that is not returning any
records at all.
However the underlying Sql returns 3,004 records. I've deleted the
view then rebuilt it but still find that "select * from

I have an nvarchar field that has data like:
XYZ40AB
WX32A
27 blah

Using SQL 2000, I've inherited a large number of stored procedures that
rely on cursors.  I often would like to check the number of rows
retrieved by these cursors.
Studying @@CURSOR_ROWS in SQL Server Books Online, I understand that it

please give full details of each and every types of cursors . espesiaaly about keyset cursors
From http://www.developmentnow.com/g/113_2006_10_0_2_0/sql-server-programming.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/

I have table with xml filed. Using this field for select as min,group by,
where. Using the data like "xmlFiled.value('(//errortime)[1]','datetime'))".
My table has 1.8 Million recs .
My TestDB has only 16,000 recs.

ALTER PROC STUDENTS
(    @M1        INT,
    @M2        INT,
    @M3        INT,

Check out for Free Mock tests on Oracle OCP OCA and many more
@TechFaq360:
http://www.techfaq360.com

In the SQL below I only want to /* Add to groups */ if there is no violation
of the primary key (MemberEmail). How could I do this?
I guess I'd also need to return an error code so that I can also let the
webservice that uses the stored procedure know that the reason it didn't

I have created a Stored Procedure to Return FirstName & LastName
Please find the Example
EXEC sp_EmployeeName @CustID = 'SP1234'
Output

I have a table COUPONS with a clustered index on two columns (username,
insert_date). This table references table USERS on username.
1. Which is better:  The clustered index on COUPONS  be (username,
inserted_date) or (inserted_date, username)?

for one of my projects, I need to store values within one procedure call
within one stored procedure and retrieve a subset of these rows within a
second procedure.
In other words, the first proc selects some rows from actual facts

I am dealing with an Aceess Sql Server application. I need to send emails to
one or more users of system based on conditions that can be traced to sql
server database table. I have not used sql server email before. I am looking
for some articles/ concepts to enable me get started ...

Is there an easy way to alter the schema of a table without having to
repopulate it's data or losing data? I'd assume it'd be the same way for a
sproc too? thanks!

Let's say I have a numbers table in a temp table  like follows:
Idx,Key
-1,10
0,9

AmountId    BeingAmount    EndAmount
1    50            80
1    90            140
1    150            200