I have a table that will give me all the users id
Select userid from UserTable
I have a stored procedure that will give me the user workplace given the userid as arguement.
Exec GetUserWorkSpace userid
I am trying to find out how I can loop through 'Exec GetUserWorkSpace userid' for all the userid from UserTable. I would like to insert the result from GetUserWorkSpace into a table.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…