Above example is only for reference and not the perfect solution.

DECLARE @GblTableName NVARCHAR(300)

SET @GblTableName = '[tempdb].[dbo].[Temp' + REPLACE(CAST(NEWID() AS NVARCHAR(50)), '-', '') + ']' ...

U can try out with ##temp tables that is (global temp table) use this only u can not find with #temp.

Moreover, u can create physical temp table in tempdb. that...

Thank you,

I will check with it.

U should keep format of 'YYYY-MM-DD' while insert from VS..

You should keep it to simple recovery model, untill u dont think your all transactions should logged in log file till the database backup process and it increses size...

I would say, u can update columns by N/A because u later don't have to handle from .net as sql server is more faster in compare to .net and it...

DateTime Range : January 1, 1753, through December 31, 9999

DateTime2 Range : 0001-01-01 through 9999-12-31

January 1,1 AD through December 31, 9999 AD

This is bacause u have taken field as DateTime, u should try DateTime2 insted.

Best way is to use union for all condition..

Hi,

Try this..

Hope this will help

SELECT OutTab.ID ,

Names =

STUFF (...

There will no windows log,

Sql manages internally and u can access it through sql only.

if u want to go ahead with database side, i will insist to go for microsoft certification. it can be recognized all over the world.

The 'Data Platform' exams are:

70-461: Querying...

Hi Gila,

Can u please share from where u are getting pass videos, I know this is silly as u must attend summits but is it available for those who can...

Provide table structures..