Posts by RichardCL • 211 points
6 posts
-
2
votes2
answers94
viewsA: Azure Shared App Service
The shared application service is suitable for small websites with little traffic. For an entertainment portal, you will probably need a higher level, as Thiago said. The Blue’s service is flexible…
-
2
votes1
answer48
viewsA: how to add a value per parameter to a select statement in sql within a simple table-Valued function?
It is necessary to put the expression in parentheses. See Books Online > TOP (Transact-SQL) -- https://msdn.microsoft.com/en-us/library/ms189463.aspx For example, this code works: USE…
-
1
votes3
answers688
viewsA: Select with various Procedures
Here are some examples to show how to do. You can use stored Procedure or table-Valued Function. Scalar Function is not suitable, because it returns only one result and three averages are required.…
sql-serveranswered RichardCL 211 -
2
votes1
answer4700
viewsA: How to create a local database in SQL server 2016?
You need an SQL Server "engine" to create databases. SSMS is only a client tool. You can install SQL Server Express on your PC, it’s free.…
sql-serveranswered RichardCL 211 -
0
votes2
answers801
viewsA: Keep table records synchronized between two different databases
Better use SQL Server Replication, assuming the two databases are in SQL Server. SQL Server has three types of Replication: Transactional, Merge, and Snapshot. In this case, Transactional could be…
-
1
votes1
answer8934
viewsA: Conversion failed when Converting the varchar value '???? ' to data type int
You can reproduce the problem like this. CREATE TABLE TESTE ( ID varchar(4) NOT NULL ); GO INSERT INTO TESTE (ID) VALUES ('1234'), ('4567'); GO UPDATE TESTE SET ID = 9250 WHERE ID = 1234; GO…
sql-serveranswered RichardCL 211