|
|
Entries for the 'Sql' Category
|
Microsoft Sql Server Management Studio Express How to Edit More than 200 Rows
|
|
In Microsoft Sql Server Management Studio Express (MS SSMS Express 2008), if you right click on a table you have the option to Select Top 1000 Ro...
|
|
| Sql 440
|
|
|
|
|
Sql Server Changing the Default Database
|
|
In Windows 7, Sql Server Express R2 with SSMS, the default database is the master database.
Not great. If you run a script and forget to specify the ...
|
|
| Sql 460
|
|
|
|
|
Understanding SqlCmd Variables and the Use Command
|
|
SqlCmd variables appear to be object references or at least something related, not strings.
SqlCmd variables can be set to strings, but they can also...
|
|
| Sql 1368
|
|
|
|
|
Sql How to Get the First Occurance of a Value (Email) in a Column
|
|
A common Sql problem is getting the first record of each set of records with a duplicate value in a column.
For example, suppose you have a set ...
|
|
| Sql 1051
|
|
|
|
|
Variables in Sqlcmd Setvar and :r commands
|
|
Author's note: updated the below article and have posted a new article on the same subject on May 3, 2011, for Windows 7, Sql Server Express 2008 R2.
...
|
|
| Sql 2311
|
|
|
|