[SQL Server] SQL commands to learn

---

• SQL commands to learn
• Using AND
• defferred name resolution

SQL commands to learn Posted: 04 Jun 2013 12:44 PM PDT Can anybody recommend a good online guide to SQL commands? Or at least a list of the ones I should learn first?

Using AND Posted: 03 Jun 2013 08:20 PM PDT Hi,I am confused with a query that:SELECT STNNo FROM table1 where VoucherBookletNo = 'VVB0000021' AND VoucherBookletNo ='VVB0000025'When I run this query it return nothing. WHy?TableName:transactionID, StoreID, STNNo, VoucherBookletNo, Quantity, AllocatedDateTableData:1 1004 1004000032 VVB0000021 16 2013-06-04 11:11:19.7872 1004 1004000032 VVB0000022 16 2013-06-04 11:11:19.7873 1004 1004000032 VVB0000023 16 2013-06-04 11:11:19.7874 1004 1004000032 VVB0000024 16 2013-06-04 11:11:19.7875 1004 1004000032 VVB0000025 16 2013-06-04 11:11:19.7876 1004 1004000032 VVB0000026 16 2013-06-04 11:11:19.787

defferred name resolution Posted: 03 Jun 2013 09:03 PM PDT Dear AllI am using sql 2008 . While compiling the procedures it does not give error even if table not present.I need to trap this error. How to achieve it?Regards

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610