Technical Article

RE: Datatype Issues... 8000 characters is too small.

  • Reply

Hi Roxanne,Have you tried writing VB code that uses ADO to execute your built queries?You would need to return the SQL queries in a resultset.  So, you might add the following code at the stored procdeclare @sql_stmts table (   cols varchar(8000),   from varchar(8000),   where varchar(8000) )-- repeat insert below for each query […]


Technical Article

RE: Running a stored proc on table results

  • Reply

This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample? quote: Table data type can't be used as a parameter in stored procedures! you will have to create a loop to cyle through the table to either send an […]



What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs


Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers