,Packages.PackageName,Packages.PackagePeriod,Receive_Payment.InstallCharge ,Receive_Payment.AmountToPay,Receive_Payment.PyingAmount,Receive_Payment.Balance ,Receive_Payment.DiscountToPay,Area.AreaName,C_Register
I have an error in Stored Procedure using bcp - bulk data transfer to csv file Error: Must Declare the scalar variable@Export_Excel It is Stored Procedure Pls advice me Thank you Maideen DECLARE @Servername varchar(100) SET @Servername ='xxxx' DECLARE @EXPORT_EXCEL TABLE ( [BL_NO] [va...
how to declare a variable similar to table column type? how to declare variable in table valued function How to delete ALL jobs from sql server? How to delete data that not exists in another table? How to delete duplicate rows from temp table? How to delete last 6 months data using stor...
But I get an error saying :Must declare the scalar variable "@NB_APP". Can someone have a look at this please? Thanks DECLARE @NB_APP INT; RESTORE DATABASE ABA_01 FROM DISK = 'D:\SQL\BACKUP\ABA_01.bak' WITH MOVE 'ABA_01_Data' TO 'D:\SQL\DATA\ABA_01_Data.mdf', ...
SQL Server is a client-server platform. The only way to interact with the back-end database is by sending requests that contain commands for the database. The protocol used to communicate between your application and the database is called TDS (Tabular Data Sream) and is described on MSDN ...
Collation is one of those settings in SQL Server that most of the developers would rather avoid understanding and just go with the defaults. At some point during the production life of an application, collations may decide to “strike back” causing unpredictable errors and frustration. This blog...
public class SimpleBinding : System.Web.UI.Page { // Declare a protected instance variable, to refer to an entity object protected CustomerEntity customer; private void InitializeComponent() { // Create an entity object, and assign it to the instance variable this.customer = new CustomerEntity(...
Please start any new threads on our new site at All Forums SQL Server 2005 Forums Transact-SQL (2005) How to use sp_executesql
things about this error is that it doesn't tell you which column(s) the problem relates to,...
declare @i int set @i = 0 while @i < 10000 begin declare @ch varchar(10) set @ch = cast (@i as varchar(10)) insert into t (c1) values (@ch) set @i = @i + 1 end go create index indx_c1 on t(c1) go update statistics t with fullscan ...