Sys.Sql_Modules return objects detail in Sql Server database. We can get detail about Stored Procedures, Replication filter procedure , Views , DML Triggers ,SQL Scalar Function ,SQL in line table, SQL Table value function ,Rules
Columns
object_id
definition
uses_ansi_nulls
uses_quoted_identifier
is_schema_bound
uses_database_collation
is_recompiled
null_on_null_input
execute_as_principal_id
SELECT object_id, definition, uses_ansi_nulls, uses_quoted_identifier,
is_schema_bound,uses_database_collation, is_recompiled,null_on_null_input, execute_as_principal_id
FROM sys.sql_modules
Friday, August 26, 2016
Thursday, August 25, 2016
Logical processing order of SELECT statement
Logical processing order of SELECT statement in SQL Server
When SQL query is executing on SQL server ,it has a order. This order call as Logical Processing Order.So let's logical processing order of SELECT statement.
1. FROM
2. ON
3. OUTER
4. WHERE
5 GROUP BY
6 CUBE or ROLLUP
7 HAVING
8 SELECT
9 DISTINCT
10 ORDER BY
11 TOP
SQL query to get table names and schema in Database
SQL query to get Table and Schmas in Database
There are many way to get table names and related schema in Database, Below I mention some of them1.
SELECT SCHEMA_NAME(schema_id) 'SchemaName' , name 'TableInDb'
FROM sys.tables
Return all tables and related schema in selected database
2.
SELECT TABLE_CATALOG ,TABLE_SCHEMA ,TABLE_NAME ,TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES
this will return more information than first one, it's return VIEWs in Database as well
3.
SELECT t.name 'TableName' ,s.name 'SchemaName'
FROM sys.tables AS t
INNER JOIN sys.schemas AS s
ON t.[schema_id] = s.[schema_id]
SELECT t.name 'TableName' ,s.name 'SchemaName'
FROM sys.tables AS t
INNER JOIN sys.schemas AS s
ON t.[schema_id] = s.[schema_id]
WHERE s.name = N'dbo';
Wednesday, August 24, 2016
UNION and UNION ALL in T-SQL
UNION and UNION ALL
UNION
- use to select related information from two or more table
- selected column should use same data type
- selected column count should be equal
- Return DISTINCT value ( remove duplicate records)
UNION ALL
- Same as UNION , except that it pull all rows in selected table (which mean it doesn't consider duplicate records).
If you know that all records are unique , it's better to use UNION , otherwise use UNION ALL
Friday, August 19, 2016
How to pass parameter to an Exe
How do pass parameter to EXE
We can use below mention method pass parameter to an Exe from different application. WPF application or Windows form application , we can use common way to do it.
1. Add reference System.Diagnostics your class.
2. Then need start process.
ProcessStartInfo processStrInfo = new ProcessStartInfo();
processStrInfo.FileName = /// Exe path;
processStrInfo.Arguments = /// Parameter to pass as string;
processStrInfo.UseShellExecute = false;
Process.Start(processStrInfo);
3. parameter can send as string.
string tempCommandArgs ="TestPara";
ProcessStartInfo processStrInfo = new ProcessStartInfo();
processStrInfo.FileName = "test.exe"; /// Exe path;
processStrInfo.Arguments = tempCommandArgs /// Parameter to pass as string;
processStrInfo.UseShellExecute = false;
Process.Start(processStrInfo);
Process.Start(processStrInfo);
4 .When we passing multiple parameter, we can use space between parameters .
tempCommandArgs =COMPANYNAME +" "+USERID
5. If parameter value have spaces.
ex - COMPANYNAME can be "Test Company"
In this time we can use below method (add stroke to start of parameter and end of parameter)
tempCommandArgs ="\"" + COMPANYNAME + "\"" + " "
+"\"" + USERlOGINNAME. + "\"";
Note:-
This is way to pass parameter to Exe as argument , But running exe from another running application (exe) is not good practice. It will consume some more memory
Now take a look at how to consume passed argument form exe.
Note:-
This example I have done with WPF application
1. We can override OnStartup in App.xaml.cs
protected override void OnStartup(StartupEventArgs e)
{
string[] args = Environment.GetCommandLineArgs();
args = e.Args;
if (args.Count() > 0)
{
COMPANYNAME = args[0];
USERNAME = args[1];
}
}
Thursday, August 18, 2016
How to convert WPF Application project to Class Library
How do convert WPF Application to Class Library
Let's see how can we convert exist WPF Application project to Class Library project.
- Right click on WPF application project and select project properties.
- Then select application and change the Out put type to Class Library, save it.
- Open App.xaml and remove StartupUri from it.
- Then build project, you can see some error with the project. so here is the trick to remove error,
- Exclude App.xaml file from project and build project again , it will build project without any errors.
- So if you want add App.xaml file to project ,now you can include App.xaml file again.
Note:-
If you going create new project to your solution, you can chose WPF User Control Library or WPF Custom Control Library.
Subscribe to:
Posts (Atom)