Since you didn’t provide any code here and asked for the directions, so here you go. Lets assume your TextBox name is ‘textBox1‘ and there is some button beside it. On the click event of that button you should be querying your database for the customer names that matches the text inside your ‘textBox1‘. The … Read more
@@RowCount returns the Number of Rows affected by the statement last executed Where @@trancount returns the number of Open Transactions in the Current Session Suppose I have a Table TableA with 5 Rows SELECT * FROM TableA SELECT @@ROWCOUNT Executing the Above I will get 2 Result sets, The first one will list all the … Read more
If I understand you correctly, you are looking for all the store procedure names that have the nolock keyword: SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%nolock%’ AND ROUTINE_TYPE=’PROCEDURE’ 9 solved How to find list of tables used in stored procedure without “With (nolock)” words [closed]
You can use concat as SELECT Source, QtyPrevious, QtyToday, ProductPrevious, ProductToday, AvaDatePr, AvaDateToday, Clusters, CONCAT(X, ”, Y) as Z from your_table_name; solved How to concatenate two different values from two different columns with comma ” , ” using TSQL?
You can use FLOOR function to do this. It will round up your numbers, so you can pick only this that are not integers. create table #t (i decimal(12,6)) insert into #t values (1), (1.1) select * from #t where FLOOR(i) <> i solved Show data where the value is after the decimal point
Move the CA_AN subquery to a Cross Apply and check the is not null on the where clause SELECT REGION = et_region, [STORE CODE] = e.et_etablissement, [STORE NAME] = et_libelle, CA = CONVERT(DECIMAL(15,2),SUM(gl_totalttcdev)), NBRTICKETS = CONVERT(DECIMAL(15,0),COUNT(distinct(GL_NUMERO))), NBRARTICLES = CONVERT(DECIMAL(15,0),SUM(GL_QTEFACT)), UPT = CONVERT(DECIMAL(15,2),SUM(GL_QTEFACT)/COUNT(DISTINCT(GL_NUMERO))) , PM = CONVERT(DECIMAL(15,2),SUM(gl_totalttcdev)/COUNT(DISTINCT(GL_NUMERO))), CA_AN = MAX(CA_AN.caan) FROM piece LEFT JOIN ligne ON … Read more
Other than the number of rows affected by a query, you can also display the the steps that your database server actually performed to execute your query. This is often called the “execution plan”. In SQL Server Management Studio, you can select the Include Actual Execution Plan (Ctrl+M) option prior to executing your query. Following … Read more
Possible this be helpful for you – DECLARE @temp TABLE (ID INT) — For 2008 and higher INSERT INTO @temp (ID) VALUES (1), (2), (3) — For 2005 and higher INSERT INTO @temp (ID) SELECT ID FROM ( SELECT ID = 4 UNION ALL SELECT 5 UNION ALL SELECT 6 ) t SELECT * FROM … Read more
You need cross join : select t1.*, t2.category from table1 t1 cross join (select distinct category from table2) t2; However if you don’t have duplicate then you can directly express it as : select * from table1 t1 cross join table2 t2; 3 solved SQL Server Temp Table Insert from other temp table [closed]
In Oracle, you have to use dynamic SQL as you can’t execute DDL in PL/SQL as is. Why PL/SQL? Because IF-THEN-ELSE is PL/SQL, not SQL. Presuming this is part of your PL/SQL procedure, you’d then if col_length(‘EMP_NUM’, ‘EMPLOYEE’) is not null then execute immediate ‘alter table employee modify emp_num not null’; end if; That’s for … Read more
Please try this one it will give output as yours. Create table #Table (rowNo int identity(1,1), ID varchar(100)) insert into #Table values(‘32132’) insert into #Table values(‘32132,32132’) insert into #Table values(‘32132,32132,6456,654,645’) declare @TableRow int = (select count(*) from #Table),@Tableloop int = 1 while(@Tableloop <= @TableRow) begin Declare @var varchar(100) ; SET @var = (select ID from … Read more
If you cross join your Week and Student tables to get all combinations, and then use not exists to determine where no TimeSheet record exists. select W.WeekID, S.StudentID from [Week] W cross join Student S where not exists (select 1 from TimeSheet T where T.StudentID = S.StudentID and T.WeekID = W.WeekID); 0 solved I have … Read more
This is what are you looking for SELECT `t1`.* FROM `messages` `t1` INNER JOIN ( SELECT MAX(`id`) as `latest`, `user_id` FROM `messages` GROUP BY `user_id`) `t2` ON `t1`.`user_id` = `t2`.`user_id` AND `t1`.`id` = `t2`.`latest` solved this is sql table tbl_message distinct records by user_id but last id display mins DESC record form id [closed]
How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#? solved How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
Warning: mysqli_stmt::bind_param(): Number of variables doesn’t match number of parameters in prepared statement [duplicate] solved Warning: mysqli_stmt::bind_param(): Number of variables doesn’t match number of parameters in prepared statement [duplicate]