MAC number from Query Analyzer
This procedure shows you the MAC number of your Enthernet card in a format exactly the same as when running: ipconfig /all from command shell. Updated thx to Larry A.
2003-05-31
137 reads
Returning data with col number
This script enables you to return data from SQL Server's table without specyfing the name of the column .All you only need to supply is the column number, that you want the data from. In the example we want to chose all rows from the second column (categories table - northwind) Column number is based […]
2003-05-07
157 reads
Blogs
Adding a Check Constraint to a Table–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Azure SQL Database Elasticity – Presentation Notes
By DataOnWheels
This blog covers the content and points to the code used to create the...
How To: Create Schema Only Database Copies
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Forums
Joining 2 select results into a single row
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...
Ask SSC