Skip to content Skip to sidebar Skip to footer
Showing posts from January, 2023

How To Save Documents Like PDF,Docx,xls In Sql Server 2008

I develop a web application that let users to upload files like images and documents. this file div… Read more How To Save Documents Like PDF,Docx,xls In Sql Server 2008

Multiple Case SQL Query Retrieve Single Row As Multiple Column

Table: ID VT_Type1 Vt_type2 VT_Type3 Status_1 Status_2 Status_3 Date_1 Date_2 Date_3 1 -1 … Read more Multiple Case SQL Query Retrieve Single Row As Multiple Column

Can't Create Stored Procedure With Table Output Parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Ge… Read more Can't Create Stored Procedure With Table Output Parameter

How Do I Find Out What Tables Have Data In A File In SQL Server?

I want to drop a now supposedly redundant file in SQL Server (2005), but when I try to drop it I am… Read more How Do I Find Out What Tables Have Data In A File In SQL Server?

CDC Is Enabled, But Cdc.dbo_CT Table Is Not Being Populated

I have enabled CDC using the following steps: exec sys.sp_cdc_enable_db; exec sys.sp_cdc_enable_ta… Read more CDC Is Enabled, But Cdc.dbo_CT Table Is Not Being Populated

Entity Framework 7 And SQLite Tables Not Creating

I've been trying for awhile to figure out how to use a single DBContext to create multiple tabl… Read more Entity Framework 7 And SQLite Tables Not Creating

Save Image Column To File In SQL Server 2000

I have a table with an image column in SQL Server 2000. I need to save the image data to a file on… Read more Save Image Column To File In SQL Server 2000

How To Deal With Encrypted Sqlite Database In IPhone?

I have an encrypted version of an sqlite database and also I have the KEY but honestly I have no id… Read more How To Deal With Encrypted Sqlite Database In IPhone?

Setting WHERE Condition To Use Ids.Contains() In ExecuteSqlCommand()

I'm using Entity Framework and I want to perform a bulk update. It is way too inefficient to lo… Read more Setting WHERE Condition To Use Ids.Contains() In ExecuteSqlCommand()

How To Retrieve Data Which Is Not Present In Any Field Of One Table In SQL Server?

I want to retrieve a data which is not present in any field from Table1 For example I have two tabl… Read more How To Retrieve Data Which Is Not Present In Any Field Of One Table In SQL Server?

Selecting Data From A Treeview

I use a ttk.TreeView as a multicolumn ListBox which effectively displays the sql data I send to it … Read more Selecting Data From A Treeview

How Do I Filter Out NaN FLOAT Values In Teradata SQL?

With the Teradata database, it is possible to load values of NaN, -Inf, and +Inf into FLOAT columns… Read more How Do I Filter Out NaN FLOAT Values In Teradata SQL?

How Do I Filter Out NaN FLOAT Values In Teradata SQL?

With the Teradata database, it is possible to load values of NaN, -Inf, and +Inf into FLOAT columns… Read more How Do I Filter Out NaN FLOAT Values In Teradata SQL?

Getting Sheet Name From Excel

I am uploading excel files to a SQL Server database. I am currently using this line to get the data… Read more Getting Sheet Name From Excel

Calculate Running Percentage In SQL

Could anyone help me with calculating a running percentage in SQL? Suppose we have the following da… Read more Calculate Running Percentage In SQL

Add A Column To A Table In All Schemas Of A PostgreSQL Database

I have a Postgres 8.4 schema like below: My_Database |-> Schemas |-> AccountA … Read more Add A Column To A Table In All Schemas Of A PostgreSQL Database

SSIS Reading LF As Terminator When Its Set As CRLF

using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is… Read more SSIS Reading LF As Terminator When Its Set As CRLF

Problems With INNER JOIN And LEFT/RIGHT OUTER JOIN

I have three tables: Orders OrderId, int PK CustomerId, int FK to Customer, NULL allowed Cust… Read more Problems With INNER JOIN And LEFT/RIGHT OUTER JOIN

Regarding Sqlite Replication

I am working in sqlite db in my application using c++ linux. I have a requirement to replicate the … Read more Regarding Sqlite Replication

Stored Procedure Not Returning Filtered Results When Using NULL To Ignore Parameter If Empty

I have a query in which the user can choose which columns they wish to search on (each column has a… Read more Stored Procedure Not Returning Filtered Results When Using NULL To Ignore Parameter If Empty