What is a job?3 3218
What are primary keys and foreign keys?3 2908
How would you Update the rows which are divisible by 10, given a set of numbers in column?3 7751
If a stored procedure is taking a table data type, how it looks?1 4587
How m-m relationships are implemented?2 5811
How do you know which index a table is using?4 8660
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?3 5382
How do you find the error, how can you know the number of rows effected by last SQL statement?2 6405
How can you get @@error and @@rowcount at the same time?9 15649
What are the type of joins? When do we use Outer and Self joins?3 7423
Questions regarding Raiseerror?1 4950
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
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
If the job running very slow what is the action you do
how to take backup bcp out for a column in table in sql server?
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.
Why do you want to join software field as you have done your BE in Electronics?
Comment,Datatypes are unlimited
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
how to use DTS package in 2000,2005,2008 in sql server
How you trouble shoot when any job fails
What is data modeling and Reterminal integrity?
which backup strategy you are following at ur company
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
OPTIMIZATION OF SP,CURSOR,TRIGGERS