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
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
By SQLBalls
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container...
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
Forums
Usage of #TempTables and an Index in Stored Procedure
We have a stored procedure, working for yonks, which has a CREATE session temp...
Referencing a table type In Dynamic SQL
I want to use a table variable in a merge statement using Dynamic SQL...
modify dtsx connection
Hello Team, kindly advise how to change dtsx connection? below is source details: Data...
Ask SSC