SQL Server FAQs

By using xp_sendmail store procedure we can do this but my problem is what parameter needs to be pass to this store procedure if I want to send mail from my local machine to another user, bcos&nb...

With SQL Server 2005, there is no need to use MAPI client to send emails. Fellow developers who have used MAPI in the previous versions of SQL Server are well aware of the challenges it had. However i...

As suggested by krishna create table test_a(a int)insert into test_a values(1)insert into test_a values(1)insert into test_a values(3)insert into test_a values(4)insert into test_a values(5)inser...

Inset data:

insert into targettable
select top 5 * from sourcetable

delete data:
1. select distinct * into targettable from sourcetable

2. delete from sourcetable

3. insert into sourcetable
    select * from targettable

Define: By default select puts exclusive lock. Specifying no lock puts no lock on the table.
Advantage: Improve the peformance
Disadvantage: Dirty reads
Suggestion: Use in static table data (with fewer DML operations)

It is useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is curren...

no.
Its automatically fired on DML statements.
these can not be triggered manually.

no.because,stored procedures are explicity invoked and trigger is nothing but a stored procedure but fires an event or data modifications occur.trigger is a implicity invoked.

select * from table_name with (index(index_name))

There are 5 types of join in sqlservercross joininner joinleft outer joinright outer joinfull outer joincross joinselect * from table1cross join table2cross join table3cross join table4inner joinselec...

Revoke db_datareader and db_datawriter permission from the database.

No need to do so.
the data  fetched by the sql query returns the unsorted data unless the order by clause is not used.

select top 5 avg(rank) from table_name group by rank order by rank desc

select top 3 * from students order by average desc

Data objects are basic runtime entities.

Stored procedures,views,tables,database diagrams are the data objects

CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000

Using Pivot Option in MS SQL Server 2005.

Table to table data transfer

select * into targettable from table
flat file to table data transfer
use bcp command
bcp pubs2..publishers in pub_out -c -t , -r r
 

Here is the example for you question.



USE YourDB

GO

INSERT INTO
MyTable (FirstCol,
SecondCol)

SELECT First
,1

UNION ALL

SELECT Second
,2

UNION ALL

SELECT Third
,3

UNION ALL

SELECT Fourth
,4

UNION ALL

SELECT Fifth
,5

GO

insert into t1 values(,,,) insert into t2 values(,,,) insert into t3 values(,,,,)......try this ........

CREATE TABLE product(pid INT PRIMARY KEY,pname VARCHAR(10),invoiceid INT UNIQUE)

create table (field1 datatype contraint constraint-name constraint_type,fields2,field3.........)
(or)
alter table add constraint constraint constraint_name constraint_type(fieldname)

Eg:

create table emp(eno int constraint uni1 unique,ename varchar(20)

To Display list of tables in the database:
SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'

To describe the structure of a particular table
SP_HELP table_name;

use
sp_help

It displays all the tables created in that database

Clustered Index

clustered index

Hi,

In this case, We can disable the script task at the run time but we cannot disable succeeding tasks based on the variable. I tried and got to know this. Please correct me if i am wrong.

Regards
Shree

Hi Dhara,


1. create a variable
2. assign value for variable in the script task.
3. Use expression to enable or disable the taks based on the variable values.

let me know if you have any more details.


cheers,
gnanam.

Cursor is used to eliminate the repeated(duplicate) records in a table.

In Embedded SQl we can get

You can access this through the following syntax

[Another Server IP].[Database Name].[Owner].[Table Name]

e.g.

[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster]