What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
HP,
17 50445We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
3 5832SQL 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 8269Hi 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 advance
6 7581we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
6 9918in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
8 9699
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to set database to be single_user in ms sql server?
Is resultset an interface?
How do you Implement SSIS Packages in your Project?
What stored by the model?
Explain Geometry datatype in sql server 2008 with example
what are the new features in SSRS?
If we delete pack Spec what will be the status of pack Body ?
What is the difference between NOROW and LOCKROW?
Explain use of expression builder.
How to create a scrollable cursor with the scroll option?
Do you know what is a with(nolock)?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is the maximum size of a dimension? : sql server analysis services, ssas