what are the joins,primary key,foriegn key, candidate key, super key and expain them?6 11486
can we call functions from stored procedure in SQL Server 2005 ? How?3 9188
What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?3 3019
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.5 3745
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance6 3178
How to list all tables having unique constraints in any of the columns in a database.1 2878
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz6 5656
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.8 3822
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.
If we delete pack Spec what will be the status of pack Body ?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
SQL Server Architecture ?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
If a stored procedure is taking a table data type, how it looks?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How you trouble shoot when any job fails
How to trouble shoot if unable to connect SQL Server
How can we call UDF(User Define Function) using C# code in ASP.net ?
can any body tell me how to know the password of current user in sql server