1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required
i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used..
A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
A left outer join B
B right outer join A gives the same result then what is
the use of two?
33
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
32
Any one plz send me SQL Server Developer/DBA resume for 4
years experience
code to create procedure for taking databse backup in sql
server or i have the query for it but what it's query
returns means i want to show on my jsp that the databse
backup has been taken on the basis of that return
value.does it returns 0 or 1.wat is the code for that
Write a Select Query to display title for each group of
records, which are collected with Compute Clause?
Like
titlefield
column-A column-B .....
.....
.....
Sum
...
titlefield
column-A column-B .....
.....
.....
Sum
...
What is Fragmentation and Defragmentation? For 32GB
Table,How can we do the fragmentation?
27
what is difference between view and Dip.
140
hi,
how to link a text file and a .rpt file in my tables of sql
server and to retrieve those records for further use. reply
me as soon as possible.
49
Can anyone tell that the extra features are there in SQL
SERVER 2008 that are not available in previous versions .
63
if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
To Refer this Site to Your Friends 
Site Map
