consultas dinamicas transact sql

Recursos: Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server (Inglés) 2nd ed. Edición Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries (Inglés) Tapa blanda – 2 Octubre 2019 SQL Server DMVs in Action: Better Queries with Dynamic Management Views (Inglés) 1st Edición Expert Performance Indexing in SQL Server 2019:…

Continue Reading

jupyter notebook extract data from sql server python data science

Source code: !conda install -y -q pymssql import pymssql con = pymssql.connect(server=’LAPTOP-CJ5ACQN6\SQLEXPRESS’,user=’gasUser’,password=’gasUser’,database=’AdventureWorksDW2017′) cursor = con.cursor() query = “SELECT * FROM DimCustomer” cursor.execute(query) data = cursor.fetchall() for item in data: print(item) con.close() if you get the following error: “20009, b’DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist”, then…

Continue Reading

basic operations on Jupyter notebook python data science

basic operations on Jupyter notebook: value = 50 print (value) PI = 3.1416 #PI number radio = input(“Please, enter the radius of the circumference: “) #ask the user to enter some value longitud = 2 * PI * float(radio) #calculation print(“The length of the circumference is: “, round(longitud,2)) References: https://amzn.to/2XHb9uB https://amzn.to/3dJ4KVg https://amzn.to/2BCijI0 https://amzn.to/30f2ykJ https://amzn.to/2zb5rHZ

Continue Reading

circular arc length python visual studio code

In this video, we will see how to calculate the circular arc length using python with Visual Studio Code as IDE. We will using a function from another file to validate if the input set by the user it is actually a number or not Code: https://github.com/navarronet/python_projects/blob/master/longitud_del_arco.py Python reference: https://docs.python.org/3/tutorial/errors.html Resources: https://amzn.to/2y8KMUq https://amzn.to/3bIDuod https://amzn.to/3g1Al68 https://amzn.to/2WFrxLF…

Continue Reading