sql-server-express

Minimal code to connect to MSSQL Server Express and extract some table data using Visual C++ Express

I have the following software installed on the machine: Microsoft SQL Server Express 2005 Microsoft Visual C++ Express 2008[详细]

2023-04-13 10:05 分类：问答

SQLServer: What is the error with this stored procedure for creating dynamic pivot table?

I created the following stored procedure to get a dynamic pivot table which is expandable with any number of employees in the first column and with any number of course开发者_如何学Pythons in the firs[详细]

2023-04-13 06:03 分类：问答

Replication from one SQL Server Express to another

I have one SQL Server Express instance with a pretty normal well formed database. I need to have the data continuously replicated to a SQL Server Express instance on another server.[详细]

2023-04-11 20:43 分类：问答

How to run the instance of SQL Server Express 2008

How to run the SQL Server 2008 Express edition, when I go to start menu, the SQL Server 2008 R2 Configuration tools there is only one option SQL Server installation center.[详细]

2023-04-08 10:57 分类：问答

Error when using JDBC Driver- java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

I am trying to use the Microsoft SQL Server 2008 Type 4 JDBC Driver in a java desktop application. However when I run the program I get the following error--[详细]

2023-04-08 10:47 分类：问答

how to produce multiple rows into 1 column value or sql statement with comma seperated in T-sql

ColumnNameIsOrderedSeq_ID ABC22 DEF11 GHI0NULL JKL14 MNO13 PQR05 I have a table (table1) in the database with above values stored in it.[详细]

2023-04-08 04:14 分类：问答

Getting the database name from a SQL Server Express database in Visual Studio

I\'m currently using this connection string to attach to my database that I created in Visual Studio:[详细]

2023-04-08 00:14 分类：问答

Connection between windows service and sql database

I am trying to establishing a connection between a Windows service written in C# and a SQL Server Express database. But when connection.open is called I get this exception[详细]

2023-04-07 03:22 分类：问答

how to execute bulk insert statement in java (using JDBC) with db=SQL Server 2008 Express

I am trying to execute a BULK INSERT statement on SQL Server 2008 Express. (It basically takes all fields in a specified file and inserts these fields into appropriate columns in a table.)[详细]

2023-04-06 23:40 分类：问答

ASP.NET C# GridView - variable number of columns and image thumbnail

Using GridView1.DataBind(); and AutoGenerateColumns=\"true\" how can I find specific column and instead of URL display the thumbnail of image from that URL?[详细]

2023-04-06 21:15 分类：问答