Can a synonym name of a table be used instead of a table name in a select statement?
No Answer is Posted For this Question
Be the First to Post Answer
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
What is the difference between stored procedure and user defined functions?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql
Explain primary key, foreign key and unique key?
What is buffer cash and log cache in sql server?
Define the term DML, DDL and DTL?
How to truncate the log in sql server 2012? : sql server database administration
Which table keeps the locking information?
List out a number of the wants to setup a SQL Server failover cluster?
What are the steps you will take to improve performance of a poor performing query?
can foreign key take role of primary key?
5 Answers CarrizalSoft Technologies, TCS, Villa Marie,