• Register

Recent questions tagged tsql

0 votes
1 answer 4 views
Problem: Does anyone know how to solve this error? > A file activation error occurred the physical file name.
asked 2 days ago Irenka Kiri 17.9k points
0 votes
1 answer 3 views
Problem: Please, I need a solution of > Error converting data type nvarchar to uniqueidentifier.
asked 2 days ago Junia Phoebe 15.3k points
0 votes
1 answer 3 views
Problem: I'm looking for a way to group whilst also concatenating rows into a comma separated string.
asked 2 days ago Junia Phoebe 15.3k points
0 votes
1 answer 2 views
Problem: Can someone please guide me on how to resolve >A return statement with a return value cannot be used in this context.
asked 5 days ago ummeshani 10.8k points
0 votes
1 answer 8 views
Problem: I am trying to find out an answer but need someone’s help .. How to compare two tables in sql server?
asked 6 days ago Ifra 37.2k points
0 votes
1 answer 5 views
Problem: I am getting this .. can you help me to solve it? Sql server move table to different schema
asked May 5 Ifra 37.2k points
0 votes
1 answer 4 views
Problem: I have a problem in joining the two columns from two different tables. The Scenario is: I have a table A with 11 columns and another table B with 6 columns. There is a column names SAMPLE1 which exists in both the tables.But, SAMPLE2 from 1st table A and ... me in writing the code. Actually that code I need to use in select statement. Can also use temp tables or case statements and etc.
asked May 4 ochena 23.3k points
0 votes
1 answer 2 views
Problem: From https://en.wikipedia.org/wiki/Microsoft_SQL_Server#T-SQL T-SQL (Transact-SQL) is the secondary means of programming and managing SQL Server. I thought that T-SQL is the only means for programming and managing SQL Server, because it is the only SQL ... "means of programming and managing SQL Server" mean? What is the primary "means of programming and managing SQL Server"? Thanks.
asked May 3 anika11 32.2k points
0 votes
1 answer 8 views
Problem: I came across with this problem > View server state permission was denied on object 'server' database 'master'
asked Apr 30 ummeshani 10.8k points
0 votes
1 answer 10 views
Problem: Any solution to this issue > If you delete a stored procedure, function, or trigger and then create it again
asked Apr 28 ummeshani 10.8k points
0 votes
1 answer 9 views
Problem: Please can anyone tell me the right procedure to do it? Sql server row_number in where clause
asked Apr 27 Ifra 37.2k points
1 vote
1 answer 4 views
Problem: I am currently learning Vhdl but unable to solve this issue: Vhdl code for 4 to 1 multiplexer using structural modelling.
asked Apr 26 PkGuy 23.5k points
1 vote
1 answer 5 views
Problem: Database connection is missing and Iget this message: Database connection mysql is missing or could not be created.
asked Apr 25 PkGuy 23.5k points
0 votes
1 answer 7 views
Problem: I did a select * on a table. I exported the results and tried to import it and write to another table (I have to do this via ssis, I cannot do this via sql server (i.e. select into) for security permission purposes, but I can do it this way). How can I ... to use an ole db source step, but my server instance does not appear for some reason, so now I'm trying to export/import out of SSMS.
asked Apr 25 sumaiya simi 43.9k points
0 votes
1 answer 21 views
Problem: Any solution to this issue > Bulk load data conversion error (type mismatch or invalid character for the specified codepage)
asked Apr 22 ummeshani 10.8k points
0 votes
1 answer 9 views
Problem: I am in trouble while solving it .. please help me .. create database failed. some file names listed could not be created. check related errors.
asked Apr 21 Ifra 37.2k points
0 votes
1 answer 9 views
Problem: How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)
asked Apr 19 ummesalma 29.2k points
1 vote
1 answer 3 views
Problem: Need help with the restoration of a data base. Cannot open backup device operating system error 2.
asked Apr 18 PkGuy 23.5k points
0 votes
1 answer 5 views
Problem: I'm confused about the differences between these. Running the following SQL gets me two identical result sets. Can someone please explain the differences? SQL RANK() versus ROW_NUMBER()
asked Apr 18 ummesalma 29.2k points
0 votes
1 answer 3 views
Problem: How can I group only by month from a date field (and not group by day)? Here is what my date field looks like: 2012-05-01 Here is my current SQL: select Closing_Date, Category, COUNT(Status)TotalCount from MyTable where Closing_Date >= '2012-02-01' and Closing_Date <= '2012-12-31' and Defect_Status1 is not null group by Closing_Date, Category
asked Apr 13 Atik03 26.5k points