Posts by Fernando dos Santos • 61 points

• 0

  votes

  1

  answer

  48

  views

  A: How do you know if the phrase is on the list?

  Good night Pedro. What you’re doing won’t work because you’re not checking the variable presente with another string but with the generated people list lista_pessoas for this you need to iterate…

  python python-3.x

  answered 4 years ago Fernando dos Santos 61

• 1

  votes

  1

  answer

  113

  views

  A: Sql Server Procedure

  Good night Gabriel. The error does not occur because of the values incorrectly passed in the parameters because the second example is right, but because it is writing the variables as string.…

  sql-server stored-procedures

  answered 5 years, 3 months ago Fernando dos Santos 61

• 0

  votes

  1

  answer

  83

  views

  A: How to Insert in Postgresql based on data from a Dataframe

  Felipe, good night. I recommend you use it instead of psycopg2 use the SQLAlchemy because it works in an integrated way with pandas making the process less laborious. Your connection would look…

  python-3.x postgresql pandas

  answered 5 years, 3 months ago Fernando dos Santos 61

• 1

  votes

  1

  answer

  781

  views

  A: How to change the shape of a cell with Pyhton and Openpyxl?

  Good morning, Vitor. Excel formats are not like the types in the programming languages, they are like a rule and Excel has some predefined and names for them for example 'Accounting', 'Text' and…

  python excel

  answered 5 years, 9 months ago Fernando dos Santos 61

• 1

  votes

  1

  answer

  1231

  views

  A: How to increase the Grid View Result font in SQL Server Management Studio 17.9.1?

  To increase the size of Grid View Result go to Tools -> Options will open a window. Follow the following steps: 1 ENVIRONMENT -> 2 FONTS AND COLORS -> 3 SEARCH FOR "GRID RESULTS" -> 4…

  sql sql-server ssms

  answered 5 years, 9 months ago Fernando dos Santos 61