|
|
-
Lars007 Commented 10 Months ago through Just Learned
Interesting, I reviewed the BOL description of [sp_procoption][1]:
> Startup procedures must be in the
> master database and cannot contain
> INPUT or OUTPUT parameters. Execution
> of the stored procedures starts when
> all databases are recover...
|
-
Lars007 Commented 10 Months ago through Just Learned
Interesting, I reviewed the BOL description of [sp_procoption][1]:
> Startup procedures must be in the
> master database and cannot contain
> INPUT or OUTPUT parameters. Execution
> of the stored procedures starts when
> all databases are recover...
|
-
Lars007 Liked 10 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Lars007 knew 10 Months ago through Just Learned
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Lars007 Liked 10 Months ago through Just Learned
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Lars007 knew 10 Months ago through Just Learned
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Lars007 Liked 10 Months ago through Just Learned
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click**...
|
-
Lars007 Commented 10 Months ago through Just Learned
Good point *denzilwhite*.
I guess it all comes down to personal preference.
I would rather do the text edit than a checkbox select and scroll, so whatever floats your boat.
Using your example of 150 columns, the columns that are to be excluded can be...
|
-
Lars007 Commented 10 Months ago through Just Learned
Good point *denzilwhite*.
I guess it all comes down to personal preference.
I would rather do the text edit than a checkbox select and scroll, so whatever floats your boat.
Using your example of 150 columns, the columns that are to be excluded can be...
|
-
Lars007 Commented 10 Months ago through Just Learned
Great tips, both of them, but both are more complicated than necessary IMHO.<br>
If your primary goal is to simply expand the column list of a table into a query without manually typing it all in, try this: <br>
In SSMS 2k5:
1. right click the t...
|