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
139 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
161 reads
Blogs
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Snowflake – Where is the explain/execution plan?
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
Daily Coping 22 Sep 2022
By Steve Jones
Today’s coping tip is to ask a trusted friend to tell you what strengths...
Forums
When use sql graph on sql server 2019 ?
I working on sql server 2019 . i read more about sql graph but...
how to change hard coded dates to ytd please
Dear Helpers, Below query is working fine giving me what i needed but if...
Couldn't allocate new page for database alert even the Database has free space
Hi, We have a database. We received the alert Could not allocate new page...
Ask SSC