Technical Article

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

William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

Read the latest Blogs

Forums

Usage of #TempTables and an Index in Stored Procedure

By BOR15K

We have a stored procedure, working for yonks, which has a CREATE session temp...

Referencing a table type In Dynamic SQL

By Weegee71

I want to use a table variable in a merge statement using Dynamic SQL...

modify dtsx connection

By roshanbi

Hello Team, kindly advise how to change dtsx connection? below is source details: Data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers