ASP.NET C# Telerik RadGrid is null when using site master

I am trying to convert my current web project to utilize a site master, rather than having my navigation and headers on every individual page. I have a RadGrid defined on a content page that uses a site.master. If I try to launch the project, it will error upon anything that tries to access a […]

TSQL sp_executesql

I have a simple table: CREATE TABLE [dbo].[test] ( [eins] [varchar](50) NOT NULL, [zwei] [varchar](50) NULL, CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED ([eins] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] with two columns eins und zwei, both varchar(50) with the values […]

SQL – How to Delete master data with many relation and used in many time

What is the best practice to delete a column that be used a lot in system (I use SQL Server and EF6 code first) For example: I have a table to store the department information. In some business, they use a lot of this department information in many business, and there are some stored procedures […]

connecting a java app to external microsoft sql server 2012

I have created a SQL server 2012 database. I need to connect to the database by using Java app created on another pc. this is my code but I cannot connect to the database, and I get error: “Login failed. The login is from an untrusted domain and cannot be used with Windows Authentication.” (my […]

How to put a description in an sql server database

I use SQL Server Express 2012 and have multiple SQL Server databases and sometimes it gets difficult to find out which is which. So I want to put a description on each database. But I am not able to find any such option in the management studio. Has anybody faced this problem and knows the […]

Extracting specific column values embedded within composite Strings of codes

I am trying to create a piece of code in sql server 2008 that will grab specific values from each distinct string within my dbo table. The ultimate goal is to make a drop down box within Visual Studio so that one can choose all lines from the database that contain a specific product code […]

Copying images to a remote server in a job results in an invalid datalength of 1024 bytes

We have images that are stored in a table on remote servers. The table is using the image column data type. Our replication client (not SQL server replication it’s custom) copies the data in the table to a central database using a series of triggers and jobs from the remote locations to a central database. […]

Rollback updated data in table in SQL Server 2008 R2

I am using SQL Server 2008 R2 and in my database I have by mistake updated all the data in one table and all the records in one column are updated and I want to get back those data which was updated. Is it any query or something rollback functionality to get those data back?

SQL Server: SUM of a column based on another column

OrderDetailID OrderID ProductID Quantity ——————————————– 1 10248 11 12 2 10248 42 10 3 10248 72 5 4 10249 14 9 5 10249 51 40 I need to get the total quantity based on the OrderID. So ideally the result should look like: OrderID Quantity —————- 10248 27 10249 49 I guess I have to […]

How can I determine whether Stored Procedure Parameter is optional from C# code (I am using Sql Server)

This question already has an answer here: How can I determine if a SQL Server stored procedure parameter has a default? 7 answers

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.