what is the main difference between constraints(like primary key etc..)& joins?2 3826
What are the types of backup and tell me the difference between full and differential backup?4 9550
Wht is Stuff in sql ser2 2650
how to get 25th row in any table in sqlserver can u tell me syntax8 6949
How to find the last update record in SQL Server?4 13302
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...7 6029
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
what is the sql equivaent of the dataset relation object ?
Delete duplicate rows without using rowid.
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How do use Having,Group by,Group function in SQL?
If user is owning any SQL Objects, can we drop that user
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
how to overcome kernel isssues
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
sql database suspect We have a sql database that is showing as suspect. How can we recover?
how to take backup bcp out for a column in table in sql server?
How you trouble shoot when any job fails
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A