Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-09 : 09:05:25
|
| Dinu writes " I'm novice in SQL Server and I must do a test, and I have no time to search for this things. Please , answer me !!!! create table #tab1 (a int null, b varchar(10) null) - What kind of table it is #tab1? - What users can acces the #tab1? - It is created in the current DB? - What happend (with the table ) when the user is disconected? Please help me with this questions !!!!!!!!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-08-09 : 09:07:08
|
| Words cannot express how much I hope you failed that test. You might want to consider the fast food industry as an alternate career. |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-08-09 : 10:49:28
|
| answers that will fit your new vocation:- What kind of table it is #tab1?a two top- What users can acces the #tab1?the first two people to sit down- It is created in the current DB?Yes, the current Dining Bay- What happend (with the table ) when the user is disconected? Hopefully, they paid the tab, and left you a tipFor fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-08-09 : 12:34:19
|
I can't believe you gave him the answers !!  - Jeff |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-09 : 15:44:25
|
| The answers are given to keep him in this forum. Otherwise he will post this (and similar) questions in some other forum and v'll miss the opportunity of answering such wonderful Qs.Srinika |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-09 : 18:57:24
|
| You guys are really going to regret this.Dinu just used those answers to get hired a a "Senior Database Architect". The client was especially impressed by his wry sense of humor.He is currently hard at work designing a system that you will one day be assigned to fix.CODO ERGO SUM |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-08-09 : 21:48:01
|
quote:
Originally posted by Michael Valentine Jones
You guys are really going to regret this.Dinu just used those answers to get hired a a "Senior Database Architect". The client was especially impressed by his wry sense of humor.He is currently hard at work designing a system that you will one day be assigned to fix.CODO ERGO SUM
And, of course, he is making more money than any of us.- Jeff |
|
|
|
|
|
|
SQL Server simple Questions ! Please help me !