Search results

based on this table this is not dynamic storage (variable) 1-9 storage 5 bytes not affected by increasing or decreasing the number is this correct? @Minty

second question: Here is the SQL Code I know I can create sequences by using SQL Code but I love using GUI Table Design my question is How can I build sequence in design time (not the IDENTITY ) CREATE TABLE [MyTable] ( [ID] [bigint] PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR...

I don't understand what you mean :unsure: but I edit my question

what is the answer to the second question in table design if I have filed ID data type: Int and Sequence : Called (Custom Serial) What properties should I use to use Sequence? how bound Sequence with this field

if I use the max 38 and store 1-9 examples for the number 100052.22 is the storage become 17

1- How can I use the sequence as the default value for a field? or as a computed field 2- Is sequence must be bound to the field by using SQLcode only when creating the tables by using the create table statement

if I create a field with this size decimal[ (38,2) is this affect the performance? maybe I will use a small number or not use the all 38 number

Can you check this question @arnelgp thanks in advance

I need to load all query to one and the load them to one table this code worked but I can't convert it to table load to table because list query only as a name in a new combined query Sub CombinePowerQueries() Dim conn As WorkbookConnection Dim qry As WorkbookQuery Dim i As...

friends Is there any VBA code to append all existing queries Bard Code Is Sub CombineAllQueries() Dim query As WorkbookQuery Dim combinedQuery As String For Each query In ActiveWorkbook.Queries combinedQuery = combinedQuery & " " & query.Formula & " " & Chr(13) & " " &...

friends Is there any developer create free code (Application) to import files to power query? the file have the same structure and same data types we can use I mean he put this code in the public library code

(y) (y) (y) (y) (y) (y) (y)

I found this link is very useful Please review less than 3 Minutes

Should I buy IP Static from the Azure Portal Or Internet Service Provider

(y) (y)(y)(y)(y)(y)(y)(y)(y)(y)

Does the message appear if link access to the SQL server (Tables)

Thank for your efforts and time (y)

why does this message appear every time or every day when opening SQL server management studio

I don't understand online backup azure I connected to Azure Database using SQL server Management studio when using the shortcut on db not find task -----backup backup appear with local db online

How can make Back-Up Azure SQL SEVER DB From SQL SERVER M S Notes: The backup option not listed when using the shortcut menu