Below is my syntax for creating the temp table in MS SQL (and that behaves as expected)

I have a SQL Table with X being a date column and varchar as Datatype. I need to retrieve non-monday days from the column. Can someone help here to retrieve the information.

I’m trying to do a simple task which is importing an excel into SSMS and I keep getting this error message. TITLE: SQL Server Import and Export Wizard

Working on a SQL Server Management Studio query. The goal is to return the Max(CreateDate) and Table Names from a query that returns a set of values from a field called WhenSQL. Each table has its own CreateDate field. The table names are returned within aset of values. Here are two examples of the sets of values returned from the main SQL query:

For instance let’s say I have the following stored procedure.

I am trying to restore a .bak file using SSMS. But SSMS is raising an error about insufficient memory in drive C. But my c drive have 132 gb of free space. What should I do?

I’m trying to achieve a particular format when scripting table data in my SQL DB. I’ve checked a ton of posts, worked with each option in the SSMS script wizard, and can’t find the format/conditions I’m looking for. Currently, when I script the table data through the SSMS Wizard, I get results with explicit Insert statements for each item such as this :

i have two table

AccountId LoginId

If I had a db table with: