What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table
HP,
17 49886We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
3 5702SQL 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 8068Hi 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 7381we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
6 9680in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
8 9454
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is meant by dirty read?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to integrate the ssrs reports in application?
How to add more data to the testing table in ms sql server?
What are partitioned views and distributed partitioned views?
Does sql server 2016 have ssms?
How to create a user to access a database in ms sql server using "create user" statements?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Do you know what is xpath?
What stored by the msdb?
How can I create a report based on a query? : sql server management studio
Why use identity in sql server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is rtm version in sql server?