Category "sql-server-2017"

which is best using delete or truncate when i need to delete all data from table?

I work on sql server 2017 I need to delete all rows from table student_course but I don't know which is best for use delete from student_course OR truncate tab

SQL Server 2017 undetected deadlock issue

The problem is: BEGIN TRANSACTION SELECT TOP 1 q.* ) FROM [QTable] q WITH(UPDLOCK) WHERE <some condition> ORDER BY <some columns&

How to keep columns header on excel without change after export data to excel file?

I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist, and keep header w

T-SQL - search in filtered JSON array

SQL Server 2017. Table OrderData has column DataProperties where JSON is stored. JSON example stored there: { "Input": { "OrderId": "abc", "Data": [

Converting VARCHAR with divide operand to INT

I have a VARCHAR which will return the value something like this '40/4'. Is there a way to convert this VARCHAR to an INT? I tried casting but it is not working

Sql server 2017 install error 16389

I keep getting the error for sql server 2017 install. Don't know how to solve (01) 2018-02-15 19:46:58 Slp: Error result: -2147467259 (01) 2018-02-15 19:46:58

SQL Server \ CONTAINS FORMSOF INFLECTIONAL Phrase \ Not Working as Expected

I am trying to use the contains operator with FORMOF INFLECTIONAL, but I'm not getting what I think is the expected result. Here is the query. This query is no