Limitations and restrictions - User-defined functions cannot be used to perform actions that modify the database state. What that means, primarily, is that you can't CREATE, DROP, or INSERT into ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...

I need to call a stored procedure from python. The stored procedure is performing a database backup; an output value is to be returned to python. conn = pyodbc.connect(self.master_conn_string, ...

This is a pain when trying to display the amounts on a VB form and having to reformat .00 to 0.00.<BR>I am thinking of just using null and >0 values instead of allowing a zero value. <BR><BR>So ...