what is the basic diffrence betn a col declared in char(1) and in varchar(1)2 2629
difference between truncate, delete aur drop?2 2841
how can u get last observation in an unknown dataset ?1083
What is stored procedure in SQL..??2 2485
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting2 1978
what is package and it uses and how can u call a package
Which is the best place or learning center for MS SQL?????In Bangladesh?????
what is difference between view and Dip.
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
whats new about truncate in sql server 2008?
Does any body please help me what question's have asked for SSRS in the interview?
If we delete pack Spec what will be the status of pack Body ?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What is Lock table in SQL?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Explain Capacity planning to create a database? and how to monitor it?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60