Sunday, May 26, 2013

[T-SQL] Which is faster, Sub Query or Join? and Why ?

[T-SQL] Which is faster, Sub Query or Join? and Why ?


Which is faster, Sub Query or Join? and Why ?

Posted: 25 May 2013 11:33 PM PDT

Hi Friends,I'm new to SQL.And I wand to know Which is faster, Sub Query or Join? and Why ?Thanks in Advance.

Automatically inserts into the database on a specific day

Posted: 25 May 2013 08:56 PM PDT

Hello everyone,I have database with about 20 tables,and some of them must be populate automatically.. So , on specific day that I set ,it is nesseccery to that row (with some data) will be automatiacally insert into table.for example, it is necessary to first day of each month to automatically insert a row into a table.. Is anyone have any idea?

No comments:

Post a Comment

Search This Blog