Search results

👌 👌 👌 👌 👌 👌 👌 :love::love::love::love::love::love::love::love::love: (y)(y)(y)(y)(y)(y)(y)(y)(y)(y) best

error Conversion failed when converting the varchar value 'CREATE VIEW MyView AS SELECT * FROM Client where Client.ID=' to data type int. I do this DECLARE @viewSQL NVARCHAR(MAX) = 'CREATE VIEW ' + @viewName + ' AS SELECT * FROM Client' + 'where ID='+@ID;

No, ignore but I don't now what can I do

link access to Microsoft SQL Server view

this error appear Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'VIEW'.

AI suggestion CREATE PROCEDURE [dbo].[MyProcedure] @ID int AS BEGIN -- if object_id ('myview' ,'v') is not null DROP VIEW IF EXISTS myview DECLARE @sql nvarchar(max) SET @sql = 'CREATE VIEW dbo.myview AS SELECT dbo.Client.ClientName, dbo.Client.ID FROM client WHERE...

Why does this code not accept the parameters inside SQL create view from the stored procedure? I want to pass the value of stored procedure parameters to create a view Create PROCEDURE MyProcedure @ID int AS BEGIN -- if object_id ('myview' ,'v') is not null DROP VIEW IF EXISTS myview...

friends If I have an online SQL server Db and I have 10 users for example Should I create one user for all these users and they all login by this username and password or create for every user ( username and password)

Thanks for your answer (y)

is the stored procedure in the SQL server equal or replacement of the update - delete - append query in Access I ask this question because views not support delete or update in SQL server

I saw this link before posting my post not give me any solution

here is all steps in a video

do you have any video? I don't have resources link access with SQLite

try to link the table from sqllite but an error appears near linked Private Sub Command0_Click() Dim connection As New ADODB.connection Dim rst As New ADODB.Recordset ' Set the connection string connection.ConnectionString = "DRIVER={SQLite3 ODBC Driver};DATABASE=e:\mydb.db" ' Open the...

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

Hello friends What should I do if the table contains over 3 Million records for example? should I create 3 views? and convert it to Excel (each one separately) or is there an easy solution in SQL SERVER MANAGEMENT STUDIO

1- Installing SQL server slows my computer 2- I tried opening bak with sqllite but not work also 3- I don't complex solution SQL sever , azure etc (Handy solution) Thanks

I found this code but need a connection to SQL server I don't want to use SQL SEVER Sub ImportSQLServerBAK() 'Declare variables Dim strSQLServerConnStr As String Dim strSQLServerBAKFilePath As String Dim strAccessDBPath As String 'Enter the SQL Server connection string...